/* Query to Get Supplier Tax Payer ID */
select 
HP.PARTY_NAME VENDOR_NAME,
PS.SEGMENT1 VENDOR_NUMBER,
PSP.ORGANIZATION_TYPE,
PSP.INCOME_TAX_ID,
PSP.VAT_REGISTRATION_NUM,
PSP.CREATED_BY,
PSP.CREATION_DATE
 from POZ_SUPPLIERS_PII PSP,
POZ_SUPPLIERS PS,
HZ_PARTIES HP
where 
PSP.VENDOR_ID=PS.VENDOR_ID
and PS.PARTY_ID=HP.PARTY_ID