Category: FUSION SQL QUERIES

/* 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