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_TRIP_STOPS

Line 245: wsh_trip_stops pickup_stop,

241: SELECT t.vehicle_number
242: INTO l_vehicle_number
243: FROM wsh_new_deliveries del,
244: wsh_delivery_legs dl,
245: wsh_trip_stops pickup_stop,
246: wsh_trips t
247: WHERE del.name =
248: p_interface_line_rec.interface_line_attribute3
249: AND del.delivery_id = dl.delivery_id

Line 256: wsh_trip_stops pickup_stop_x,

252: AND pickup_stop.actual_departure_date =
253: (SELECT min(pickup_stop_x.actual_departure_date)
254: FROM wsh_new_deliveries del_x,
255: wsh_delivery_legs dl_x,
256: wsh_trip_stops pickup_stop_x,
257: wsh_trips tx
258: WHERE del_x.delivery_id = del.delivery_id
259: AND del_x.delivery_id = dl_x.delivery_id
260: AND dl_x.pick_up_stop_id =

Line 676: wsh_trip_stops pickup_stop,

672: SELECT t.vehicle_number
673: INTO l_vehicle_number
674: FROM wsh_new_deliveries del,
675: wsh_delivery_legs dl,
676: wsh_trip_stops pickup_stop,
677: wsh_trips t
678: WHERE del.name =
679: x_interface_line_rec.interface_line_attribute3
680: AND del.delivery_id = dl.delivery_id

Line 687: wsh_trip_stops pickup_stop_x,

683: AND pickup_stop.actual_departure_date =
684: (SELECT min(pickup_stop_x.actual_departure_date)
685: FROM wsh_new_deliveries del_x,
686: wsh_delivery_legs dl_x,
687: wsh_trip_stops pickup_stop_x,
688: wsh_trips tx
689: WHERE del_x.delivery_id = del.delivery_id
690: AND del_x.delivery_id = dl_x.delivery_id
691: AND dl_x.pick_up_stop_id =