APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_TRIP_STOPS_OB_GRP_V

Line 182: ,wsh_trip_stops_ob_grp_v wts

178: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts
183: ,mtl_system_items_kfv msi
184: WHERE wt.trip_id = p_trip_id
185: AND wt.trip_id = wts.trip_id
186: AND (wt.vehicle_item_id = msi.inventory_item_id(+)

Line 225: wsh_trip_stops_ob_grp_v wts

221: FROM wsh_new_deliveries_ob_grp_v wnd,
222: -- 2767767
223: (SELECT wdl.delivery_id,wts.trip_id
224: FROM wsh_delivery_legs_ob_grp_v wdl,
225: wsh_trip_stops_ob_grp_v wts
226: WHERE wdl.delivery_id=p_delivery_id
227: AND wdl.pick_up_stop_id=wts.stop_id
228: AND ROWNUM=1) wts1 -- end 2767767
229: WHERE wnd.delivery_id = p_delivery_id

Line 239: wsh_trip_stops_ob_grp_v wts,

235: BEGIN
236: SELECT wts.trip_id,wt.name
237: INTO l_trip_id,l_trip_name
238: FROM wsh_delivery_legs_ob_grp_v wdl,
239: wsh_trip_stops_ob_grp_v wts,
240: wsh_trips_ob_grp_v wt
241: WHERE wdl.delivery_id=p_delivery_id
242: AND wdl.pick_up_stop_id=wts.stop_id
243: AND wt.trip_id=wts.trip_id

Line 916: wsh_trip_stops_ob_grp_v wts

912: BEGIN
913: SELECT distinct wts.trip_id
914: INTO l_trip_id
915: FROM wsh_delivery_legs_ob_grp_v wdl,
916: wsh_trip_stops_ob_grp_v wts
917: WHERE wdl.delivery_id=p_delivery_id
918: AND wdl.pick_up_stop_id=wts.stop_id
919: AND rownum=1;
920: IF (l_debug = 1) THEN

Line 1634: wsh_trip_stops_ob_grp_v wts,

1630: BEGIN
1631: SELECT wts.trip_id,wt.name
1632: INTO l_trip_id,l_trip_name
1633: FROM wsh_delivery_legs_ob_grp_v wdl,
1634: wsh_trip_stops_ob_grp_v wts,
1635: wsh_trips_ob_grp_v wt
1636: WHERE wdl.delivery_id=l_deliveries.delivery_id
1637: AND wdl.pick_up_stop_id=wts.stop_id
1638: AND wt.trip_id=wts.trip_id

Line 1809: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

1805: -- Add the following code in case user created Trip manually from desktop
1806: BEGIN
1807: SELECT wts.trip_id
1808: INTO l_trip_id
1809: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
1810: WHERE wdl.delivery_id = p_delivery_id --l_delivery_id /* bug 2741857 */
1811: and wdl.pick_up_stop_id = wts.stop_id;
1812:
1813: IF l_trip_id IS NOT NULL THEN

Line 2025: FROM wsh_trip_stops_ob_grp_v

2021: FOR UPDATE OF FREIGHT_COST_ID NOWAIT;
2022:
2023: CURSOR stops IS
2024: SELECT 'x'
2025: FROM wsh_trip_stops_ob_grp_v
2026: WHERE trip_id = p_trip_id
2027: FOR UPDATE NOWAIT;
2028:
2029: CURSOR trips IS

Line 2156: FROM WSH_TRIP_STOPS_OB_GRP_V wts, WSH_DELIVERY_LEGS_OB_GRP_V wdl

2152:
2153:
2154: SELECT stop_id
2155: INTO l_stop_id
2156: FROM WSH_TRIP_STOPS_OB_GRP_V wts, WSH_DELIVERY_LEGS_OB_GRP_V wdl
2157: -- WHERE wts.trip_id = p_trip_id
2158: WHERE wts.trip_id=l_trip_id
2159: AND wts.stop_id = wdl.pick_up_stop_id
2160: AND ROWNUM <2;

Line 2312: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

2308: , p_ship_method_code IN VARCHAR2 DEFAULT NULL
2309: ) IS
2310: CURSOR stop_cur IS
2311: SELECT wdl.pick_up_stop_id pick_up_stop_id
2312: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
2313: WHERE wts.trip_id = p_trip_id
2314: AND wdl.pick_up_stop_id = wts.stop_id;
2315:
2316: CURSOR del_cur IS

Line 2318: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

2314: AND wdl.pick_up_stop_id = wts.stop_id;
2315:
2316: CURSOR del_cur IS
2317: SELECT delivery_id
2318: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
2319: WHERE wts.trip_id = p_trip_id
2320: AND wdl.pick_up_stop_id = wts.stop_id;
2321:
2322: l_del_cur del_cur%ROWTYPE;

Line 2719: FROM wsh_trip_stops_ob_grp_v wts, wsh_delivery_legs_ob_grp_v wdl

2715: END IF;
2716:
2717: SELECT stop_id
2718: INTO l_stop_id
2719: FROM wsh_trip_stops_ob_grp_v wts, wsh_delivery_legs_ob_grp_v wdl
2720: WHERE wts.trip_id = p_trip_id
2721: AND wts.stop_id = wdl.pick_up_stop_id
2722: AND ROWNUM < 2;
2723: