Query for Supplier and Supplier Contact – Contact Directory

Below is the link between Supplier/Vendor to contact.

SELECT CON.party_name CONTACT, SUP.vendor_name SUPPLIER, ADDR.party_site_name ADDRESS, CON.party_id,
HR.end_date, SUP.vendor_id, SUP_CON.*
FROM hz_parties CON, hz_relationships HR, ap_suppliers SUP, hz_party_sites ADDR, ap_supplier_contacts SUP_CON
WHERE CON.party_id = HR.subject_id
AND HR.subject_type = 'PERSON'
AND HR.object_type = 'ORGANIZATION'
AND HR.relationship_code = 'CONTACT_OF'
AND HR.object_id = SUP.party_id
AND SUP_CON.per_party_id = CON.party_id
AND SUP_CON.org_party_site_id = ADDR.party_site_id
--AND SUP.vendor_id = 2240145