-
-

Supplier Information for a PO

PURCHASING

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