365: hz_parties contact_person,
366: hz_org_contacts supplier_contact,
367: hz_contact_points phone_record,
368: hz_contact_points email_record,
369: hz_relationships hrel
370: WHERE hrel.subject_id = contact_person.party_id
371: AND hrel.subject_table_name = 'HZ_PARTIES'
372: AND hrel.subject_type = 'PERSON'
373: AND hrel.object_id = hps.party_id