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_PARTY_SITES

Line 1013: FROM hz_party_sites hps,

1009: WHERE delivery_id = p_delivId;
1010: --
1011: CURSOR c_GetShipperPartyRelId(p_locId NUMBER, p_delpartyId NUMBER) IS
1012: SELECT hrel.party_id, contact_person.party_id, email_record.email_address, hrel.end_date
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,

Line 1615: hz_party_sites hps,

1611: CURSOR validate_auto_tender_csr(p_carrier_id NUMBER,p_organization_id NUMBER) IS
1612: SELECT 1
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,