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_DELIVERY_LEGS

Line 244: wsh_delivery_legs dl,

240: BEGIN
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

Line 255: wsh_delivery_legs dl_x,

251: AND pickup_stop.trip_id = t.trip_id
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

Line 675: wsh_delivery_legs dl,

671: BEGIN
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

Line 686: wsh_delivery_legs dl_x,

682: AND pickup_stop.trip_id = t.trip_id
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