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 255: wsh_trip_stops pickup_stop,

251: SELECT t.vehicle_number
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

Line 266: wsh_trip_stops pickup_stop_x,

262: AND pickup_stop.actual_departure_date =
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 =

Line 699: wsh_trip_stops pickup_stop,

695: SELECT t.vehicle_number
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

Line 710: wsh_trip_stops pickup_stop_x,

706: AND pickup_stop.actual_departure_date =
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 =