Query to Extract GSTIN Number

This applies to India localization.

To Extract the GSTIN number and pan number attached to the vendors.

Script:

SELECT distinct
jprl.registration_number
jprl.secondary_registration_number sec_registration_number
FROM jai_party_regs jpr, jai_party_reg_lines jprl
ap_supplier_sites_all apsa
WHERE jpr.party_reg_id = jprl.party_reg_id
AND jprl.regime_id = :P_regime_id –jr.regime_id
–AND jr.regime_code not in (‘TDS’)
AND jprl.effective_to is null
AND jpr.PARTY_TYPE_CODE = ‘THIRD_PARTY_SITE’
AND apsa.vendor_id = jpr.party_id
AND apsa.vendor_id = :P_vendor_id — (576913, 510568, 1003)
AND apsa.vendor_site_id = jpr.party_site_id
–AND trim(apsa.state) = substr(trim(jr.regime_code), 1, 2);