eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SUPPLIER_PARTY dependencies on HZ_CONTACT_POINTS

Line 1616: from hz_contact_points

1612:
1613: --Cursor to get object_version_number for party contact.
1614: CURSOR Get_Cont_Point_Version(p_contact_point_id NUMBER) IS
1615: select object_version_number
1616: from hz_contact_points
1617: where contact_point_id = p_contact_point_id;
1618:
1619: l_person_party_id NUMBER;
1620: l_phone_contact_point_id NUMBER;

Line 2130: hz_contact_points phone_record,

2126: hrel.end_date end_date -- IB-Phase-2
2127: from hz_party_sites hps,
2128: hz_parties contact_person,
2129: hz_org_contacts supplier_contact,
2130: hz_contact_points phone_record,
2131: hz_contact_points email_record,
2132: hz_relationships hrel
2133: where hrel.subject_id = contact_person.party_id
2134: and hrel.subject_table_name = 'HZ_PARTIES'

Line 2131: hz_contact_points email_record,

2127: from hz_party_sites hps,
2128: hz_parties contact_person,
2129: hz_org_contacts supplier_contact,
2130: hz_contact_points phone_record,
2131: hz_contact_points email_record,
2132: hz_relationships hrel
2133: where hrel.subject_id = contact_person.party_id
2134: and hrel.subject_table_name = 'HZ_PARTIES'
2135: and hrel.subject_type = 'PERSON'