DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_CONTACT_POINTS

Line 367: hz_contact_points phone_record,

363: email_record.email_address email_address
364: FROM hz_party_sites hps,
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'

Line 368: hz_contact_points email_record,

364: FROM hz_party_sites hps,
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'