Posts

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,              ...
1 comment
Read more

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'
Post a Comment
Read more

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>>;
4 comments
Read more