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_SHIPPING_INFO dependencies on HZ_PARTIES

Line 165: hz_parties hp, hz_party_usg_assignments hpu

161: hp.party_name carrier_name, -- Bug 5697730
162: to_char(NULL) bill_of_lading
163: FROM wsh_lookups wl,
164: wsh_new_deliveries dl,
165: hz_parties hp, hz_party_usg_assignments hpu
166: WHERE dl.name = v_delivery_name
167: AND hp.party_id(+) = dl.carrier_id -- Bug 5697730
168: AND hp.party_id = hpu.party_id(+) -- Bug 5697730
169: AND hpu.party_usage_code(+) = 'TRANSPORTATION_PROVIDER' -- Bug 5697730

Line 211: hz_parties hp, hz_party_usg_assignments hpu -- Bug 5697730

207: wsh_trip_stops ts2,
208: -- wsh_document_instances di, -- Bug 3146273
209: wsh_delivery_legs dg,
210: wsh_new_deliveries dl,
211: hz_parties hp, hz_party_usg_assignments hpu -- Bug 5697730
212: WHERE dl.name = v_delivery_name
213: AND hp.party_id(+) = t.carrier_id -- Bug 5697730
214: AND hp.party_id = hpu.party_id(+) -- Bug 5697730
215: AND hpu.party_usage_code(+) = 'TRANSPORTATION_PROVIDER' -- Bug 5697730