Query to get tax registration from supplier address level

Summary

Tax Registration from Supplier Address

Content

Hello 

I was wondering if you can share with me any SQL to get the Tax Registration at the address Level.

I have the following at Supplier Level

Thanks

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