APPS.WSH_IB_TXN_MATCH_PKG dependencies on WSH_DELIVERY_LEGS

Line 5119: FROM wsh_delivery_legs wdl,

5115: NVL(wts1.actual_departure_date,wts1.planned_departure_date) planned_departure_date,
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

Line 5136: FROM wsh_delivery_legs wdl,

5132: NVL(wts.actual_departure_date,wts.planned_departure_date) planned_departure_date,
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

Line 5165: wsh_delivery_legs wdl

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: --
5169: l_dlvy_rec dlvy_csr%ROWTYPE;