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'

Comments

Post a Comment

Popular posts from this blog

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