APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_DELIVERY_LEGS

Line 1831: wsh_delivery_legs wdl

1827: SELECT wt.trip_id, wt.name, wt.lane_id,
1828: NVL(wdl.reprice_Required,'N') reprice_required
1829: FROM wsh_trips wt,
1830: wsh_trip_stops wts,
1831: wsh_delivery_legs wdl
1832: WHERE wdl.delivery_id = p_delivery_id
1833: AND wdl.pick_up_stop_id = wts.stop_id
1834: AND wt.trip_id = wts.trip_id
1835: AND wt.lane_id IS NOT NULL;

Line 2482: wsh_delivery_legs wdl,

2478: NVL(do_stop.shipments_type_flag,'O') do_stop_shipTypeFlag,
2479: pu_stop.trip_id trip_id
2480: FROM wsh_trip_stops pu_stop,
2481: wsh_trip_stops do_stop,
2482: wsh_delivery_legs wdl,
2483: wsh_new_deliveries wnd
2484: WHERE wnd.delivery_id = p_delivery_id
2485: AND wdl.delivery_id = wnd.delivery_id
2486: AND NVL(wnd.shipment_direction,'O') NOT IN ('O','IO')

Line 2507: wsh_delivery_legs next_leg,

2503: next_leg_pu_stop.trip_id trip_id --3410681
2504: FROM wsh_trip_stops next_leg_do_stop,
2505: wsh_trip_stops next_leg_pu_stop,
2506: wsh_trip_stops curr_leg_do_stop,
2507: wsh_delivery_legs next_leg,
2508: wsh_delivery_legs curr_leg,
2509: wsh_new_deliveries wnd
2510: WHERE next_leg.drop_off_stop_id = next_leg_do_stop.stop_id
2511: --AND st1.status_code = 'OP'

Line 2508: wsh_delivery_legs curr_leg,

2504: FROM wsh_trip_stops next_leg_do_stop,
2505: wsh_trip_stops next_leg_pu_stop,
2506: wsh_trip_stops curr_leg_do_stop,
2507: wsh_delivery_legs next_leg,
2508: wsh_delivery_legs curr_leg,
2509: wsh_new_deliveries wnd
2510: WHERE next_leg.drop_off_stop_id = next_leg_do_stop.stop_id
2511: --AND st1.status_code = 'OP'
2512: AND next_leg.pick_up_stop_id = next_leg_pu_stop.stop_id