Supplier Contact
SELECT con.party_name contact,
sup.vendor_name supplier,
site.vendor_site_code site,
site.vendor_site_id,
site.org_id,
sup_con.vendor_contact_id,
con.party_id
FROM hz_parties con,
ap_supplier_sites_all site,
ap_suppliers sup,
ap_supplier_contacts sup_con
WHERE sup_con.per_party_id = con.party_id
AND sup_con.org_party_site_id= site.party_site_id
AND sup.vendor_id= site.vendor_id
AND con.party_name= '&Contact_Name' -- (HZ_PARTIES.party_name)
ORDER BY contact, supplier, site;
