Obtain Supplier Information using Vendor ID on Requisition
SELECT hzp.party_name
FROM fusion.POZ_SUPPLIERS PS,
fusion.HZ_PARTies HZP
WHERE vendor_id = XXXXXXXXXXXXXX
AND hzp.party_id = ps.party_id
SELECT hzp.party_name ,
Ps.vendor_id ,
pssam.VENDOR_SITE_CODE,
pssam.vendor_site_id
FROM fusion.POZ_SUPPLIERS PS ,
fusion.POZ_SUPPLIER_SITES_ALL_M PSSAM,
fusion.HZ_PARTies HZP
WHERE
(
ps.vendor_id = &VENDOR_ID
OR upper(party_name) LIKE upper('&VENDOR_NAME')
)
AND hzp.party_id = ps.party_id
AND ps.Vendor_id = pssam.VENDOR_ID
