Query to find HSN code for an Inventory Item Oracle Apps R12

select b.reporting_code
from
apps.jai_item_templ_hdr_v a,apps.jai_reporting_associations_v b
where b.entity_id=a.template_hdr_id
and b.effective_from is not null
and b.effective_to is null
and b.regime_code='IND GST'
and b.reporting_type_code='GST_HSN_CODE'
and a.item_code= <<item_code>>;

Comments

  1. Abhishek Bajpai27 July 2017 at 23:59

    Very useful query..I was looking for the same.

    ReplyDelete
  2. Unknown17 October 2018 at 23:15

    Thanks for sharing , HSN Codewas introduced to ensure uniformity of goods all over the world. This was done to reduce costs and efforts and help in the classification of goods in a manner that could be understood by all.

    ReplyDelete
  3. Dinesh Jadhav11 January 2019 at 01:04

    useful info for me I was looking for the same.

    ReplyDelete
  4. Dinesh Jadhav11 January 2019 at 01:05

    useful info for me I was looking for the same.
    https://bit.ly/2pVZma2

    ReplyDelete

Post a Comment

Popular posts from this blog

Query for Getting State and GST Registration Number for a Supplier Oracle Apss R12

SELECT jrav.reporting_code state_code,        jrav.reporting_code_description state_name,        jprlv.registration_number GST_REGISTRTION_NUM   FROM apps.jai_party_reg_lines_v jprlv,        apps.jai_party_regs_v jprv,        apps.jai_reporting_associations_v jrav  WHERE jprlv.party_reg_id = jprv.party_reg_id    AND jprv.party_reg_id = jrav.entity_id    AND jprlv.regime_id = jrav.regime_id    AND jprv.party_id = <<po_headers.vendor_id>>    AND jprv.party_site_id =<<po_headers.vendor_site_id>>    AND jprv.org_id =<<po_headers.org_id>>    AND jprlv.effective_to IS NULL    AND jprlv.registration_number IS NOT NULL    AND jprlv.regime_code = 'IND GST'    and jrav.reporting_type_code='JAI_TP_IN_STATE'
Read more

API for Assigning GST Registration Number, PAN Number and State to a Customer Oracle Apps R12

Declare CURSOR C  IS SELECT DISTINCT A.*,        B.CUST_ACCOUNT_ID,        C.CUST_ACCT_SITE_ID,        (SELECT X.REGIME_ID         FROM APPS.JAI_REGIMES X         WHERE X.REGIME_NAME='INDIA GST'         ) REGIME_ID,        (SELECT Y.REPORTING_CODE_ID         FROM APPS.JAI_REPORTING_TYPES X,              APPS.JAI_REPORTING_CODES Y         WHERE X.REPORTING_TYPE_ID=Y.REPORTING_TYPE_ID         AND Y.REPORTING_CODE=A.STATE_CODE         AND X.REPORTING_TYPE_NAME='JAI_TP_IN_STATE'         AND ROWNUM=1) REPORTING_CODE_ID,          (SELECT Y.REPORTING_CODE_DESCRIPTION         FROM APPS.JAI_REPORTING_TYPES X,              ...
Read more