Query to get tax registration at supplier level – Oracle Fusion

The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications.

SELECT HP.party_name supplier_name
,SUP.segment1 supplier_number
,ZR.TAX_REGIME_CODE
,ZR.REGISTRATION_NUMBER tax_registration_number
,ZR.EFFECTIVE_FROM
FROM zx_party_tax_profile tax
,zx_registrations ZR
,hz_parties HP
,poz_suppliers SUP
WHERE TAX.party_id = HP.party_id
AND tax.party_type_code = ‘THIRD_PARTY’
AND ZR.PARTY_TAX_PROFILE_ID = TAX.PARTY_TAX_PROFILE_ID
AND HP.party_id = SUP.party_id
AND ZR.REGISTRATION_NUMBER IS NOT NULL