APPS.JL_ZZ_RECEIV_INTERFACE dependencies on WSH_NEW_DELIVERIES

Line 221: FROM wsh_new_deliveries del

217: l_tow_veh_plate_num,
218: l_tow_veh_plate_state_code,
219: l_tow_veh_antt_inscr,
220: l_seal_number
221: FROM wsh_new_deliveries del
222: WHERE del.name =
223: p_interface_line_rec.interface_line_attribute3;
224:
225: EXCEPTION

Line 243: FROM wsh_new_deliveries del,

239:
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 =

Line 254: FROM wsh_new_deliveries del_x,

250: AND dl.pick_up_stop_id = pickup_stop.stop_id
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

Line 652: FROM wsh_new_deliveries del

648: l_tow_veh_plate_num,
649: l_tow_veh_plate_state_code,
650: l_tow_veh_antt_inscr,
651: l_seal_number
652: FROM wsh_new_deliveries del
653: WHERE del.name =
654: x_interface_line_rec.interface_line_attribute3;
655:
656: EXCEPTION

Line 674: FROM wsh_new_deliveries del,

670:
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 =

Line 685: FROM wsh_new_deliveries del_x,

681: AND dl.pick_up_stop_id = pickup_stop.stop_id
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