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.JL_ZZ_RECEIV_INTERFACE dependencies on WSH_TRIPS

Line 256: wsh_trips t

252: INTO l_vehicle_number
253: FROM wsh_new_deliveries del,
254: wsh_delivery_legs dl,
255: wsh_trip_stops pickup_stop,
256: wsh_trips t
257: WHERE del.name =
258: p_interface_line_rec.interface_line_attribute3
259: AND del.delivery_id = dl.delivery_id
260: AND dl.pick_up_stop_id = pickup_stop.stop_id

Line 267: wsh_trips tx

263: (SELECT min(pickup_stop_x.actual_departure_date)
264: FROM wsh_new_deliveries del_x,
265: wsh_delivery_legs dl_x,
266: wsh_trip_stops pickup_stop_x,
267: wsh_trips tx
268: WHERE del_x.delivery_id = del.delivery_id
269: AND del_x.delivery_id = dl_x.delivery_id
270: AND dl_x.pick_up_stop_id =
271: pickup_stop_x.stop_id

Line 700: wsh_trips t

696: INTO l_vehicle_number
697: FROM wsh_new_deliveries del,
698: wsh_delivery_legs dl,
699: wsh_trip_stops pickup_stop,
700: wsh_trips t
701: WHERE del.name =
702: x_interface_line_rec.interface_line_attribute3
703: AND del.delivery_id = dl.delivery_id
704: AND dl.pick_up_stop_id = pickup_stop.stop_id

Line 711: wsh_trips tx

707: (SELECT min(pickup_stop_x.actual_departure_date)
708: FROM wsh_new_deliveries del_x,
709: wsh_delivery_legs dl_x,
710: wsh_trip_stops pickup_stop_x,
711: wsh_trips tx
712: WHERE del_x.delivery_id = del.delivery_id
713: AND del_x.delivery_id = dl_x.delivery_id
714: AND dl_x.pick_up_stop_id =
715: pickup_stop_x.stop_id