APPS.WSH_IB_TXN_MATCH_PKG dependencies on WSH_NEW_DELIVERIES

Line 5120: wsh_new_deliveries wnd,

5116: NVL(wts.actual_arrival_date, wts.planned_arrival_date) planned_arrival_date,
5117: wt.carrier_id,
5118: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE
5119: FROM wsh_delivery_legs wdl,
5120: wsh_new_deliveries wnd,
5121: wsh_trip_stops wts,
5122: wsh_trip_stops wts1,
5123: wsh_trips wt
5124: WHERE wnd.delivery_id = p_deliveryId

Line 5137: wsh_new_deliveries wnd,

5133: NVL(wts1.actual_arrival_Date, wts1.planned_arrival_date) planned_arrival_date,
5134: wt.carrier_id,
5135: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE
5136: FROM wsh_delivery_legs wdl,
5137: wsh_new_deliveries wnd,
5138: wsh_trip_stops wts,
5139: wsh_trip_stops wts1,
5140: wsh_trips wt
5141: WHERE wnd.delivery_id = p_deliveryId

Line 5164: FROM wsh_new_deliveries wnd,

5160: NVL(wnd.ultimate_dropoff_date,wnd.latest_Dropoff_date) ultimate_dropoff_date,
5161: wnd.carrier_id,
5162: NVL(wnd.ITINERARY_COMPLETE,'N') ITINERARY_COMPLETE,
5163: wdl.delivery_leg_id
5164: FROM wsh_new_deliveries wnd,
5165: wsh_delivery_legs wdl
5166: WHERE wnd.delivery_id = p_deliveryId
5167: AND wnd.delivery_id = wdl.delivery_id (+);
5168: --

Line 5824: wsh_new_deliveries wnd

5820: wdd.src_requested_quantity2,
5821: wdd.last_update_date
5822: FROM wsh_delivery_details wdd,
5823: wsh_delivery_assignments_v wda,
5824: wsh_new_deliveries wnd
5825: WHERE wdd.source_code = 'PO'
5826: AND NVL(wdd.line_direction,'O') NOT IN ('O','IO')
5827: AND wdd.source_header_id = p_source_header_id
5828: AND wdd.source_line_id = p_source_line_id

Line 5977: FROM wsh_new_deliveries

5973: p_shipment_header_id IN NUMBER
5974: )
5975: IS
5976: SELECT DISTINCT initial_pickup_location_id
5977: FROM wsh_new_deliveries
5978: WHERE rcv_shipment_header_id = p_shipment_header_id;
5979: --
5980: --
5981: -- Check receipt line's matching status