372: hz_parties contact_person,
373: hz_org_contacts supplier_contact,
374: hz_contact_points phone_record,
375: hz_contact_points email_record,
376: hz_relationships hrel
377: WHERE hrel.subject_id = contact_person.party_id
378: AND hrel.subject_table_name = 'HZ_PARTIES'
379: AND hrel.subject_type = 'PERSON'
380: AND hrel.object_id = hps.party_id