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_ROUTING_RESPONSE_PKG dependencies on HZ_CONTACT_POINTS

Line 1017: hz_contact_points phone_record,

1013: FROM hz_party_sites hps,
1014: hz_party_site_uses hpsu,
1015: hz_parties contact_person,
1016: hz_org_contacts supplier_contact,
1017: hz_contact_points phone_record,
1018: hz_contact_points email_record,
1019: hz_relationships hrel
1020: WHERE hps.party_site_id = hpsu.party_site_id
1021: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'

Line 1018: hz_contact_points email_record,

1014: hz_party_site_uses hpsu,
1015: hz_parties contact_person,
1016: hz_org_contacts supplier_contact,
1017: hz_contact_points phone_record,
1018: hz_contact_points email_record,
1019: hz_relationships hrel
1020: WHERE hps.party_site_id = hpsu.party_site_id
1021: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
1022: AND hrel.subject_id = contact_person.party_id

Line 1617: hz_contact_points hcp,

1613: FROM hz_relationships rel,
1614: wsh_carrier_sites wcs,
1615: hz_party_sites hps,
1616: hz_org_contacts hoc,
1617: hz_contact_points hcp,
1618: hz_contact_points hcp2,
1619: hz_parties party_rel,
1620: wsh_org_carrier_sites wocs
1621: WHERE wcs.carrier_site_id = hps.party_site_id

Line 1618: hz_contact_points hcp2,

1614: wsh_carrier_sites wcs,
1615: hz_party_sites hps,
1616: hz_org_contacts hoc,
1617: hz_contact_points hcp,
1618: hz_contact_points hcp2,
1619: hz_parties party_rel,
1620: wsh_org_carrier_sites wocs
1621: WHERE wcs.carrier_site_id = hps.party_site_id
1622: AND hps.party_id = rel.object_id