APPS.JL_ZZ_RECEIV_INTERFACE dependencies on WSH_NEW_DELIVERIES

Line 229: FROM wsh_new_deliveries del

225: l_tow_veh_antt_inscr,
226: l_seal_number,
227: l_wagon_code,
228: l_ferry_code
229: FROM wsh_new_deliveries del
230: WHERE del.name =
231: p_interface_line_rec.interface_line_attribute3;
232:
233: EXCEPTION

Line 253: FROM wsh_new_deliveries del,

249:
250: BEGIN
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 =

Line 264: FROM wsh_new_deliveries del_x,

260: AND dl.pick_up_stop_id = pickup_stop.stop_id
261: AND pickup_stop.trip_id = t.trip_id
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

Line 673: FROM wsh_new_deliveries del

669: l_tow_veh_antt_inscr,
670: l_seal_number,
671: l_wagon_code,
672: l_ferry_code
673: FROM wsh_new_deliveries del
674: WHERE del.name =
675: x_interface_line_rec.interface_line_attribute3;
676:
677: EXCEPTION

Line 697: FROM wsh_new_deliveries del,

693:
694: BEGIN
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 =

Line 708: FROM wsh_new_deliveries del_x,

704: AND dl.pick_up_stop_id = pickup_stop.stop_id
705: AND pickup_stop.trip_id = t.trip_id
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