APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_TRIP_STOPS

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 1151: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt

1147:
1148: CURSOR c_Get_Trip(v_del_id NUMBER) IS
1149: select wt.trip_id , wt.carrier_id, wt.ship_method_code, wt.mode_of_transport,
1150: wt.tp_plan_name -- glog proj
1151: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
1152: where wdl.pick_up_stop_id=wts.stop_id
1153: and wdl.delivery_id=v_del_id
1154: and wts.trip_id=wt.trip_id;
1155:

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 1999: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;

1995: l_msg_count NUMBER;
1996: l_msg_data VARCHAR2(20000);
1997:
1998: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
1999: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;
2000: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2001: l_freight_cost_id NUMBER;
2002: l_stop_id NUMBER;
2003: l_trip_id NUMBER;

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 2167: debug('Call WSH_TRIP_STOPS_PUB.Create_Update_Stop to Update the Seal Code','Update Trip Stop');

2163:
2164: IF (p_seal_code IS NOT NULL ) THEN
2165: --patchset J. Shipping API cleanup
2166: IF (l_debug = 1) THEN
2167: debug('Call WSH_TRIP_STOPS_PUB.Create_Update_Stop to Update the Seal Code','Update Trip Stop');
2168: END IF;
2169: l_stop_info.stop_id := l_stop_id;
2170: l_stop_info.trip_id :=l_trip_id;
2171: l_stop_info.DEPARTURE_SEAL_CODE := p_seal_code;

Line 2172: WSH_TRIP_STOPS_PUB.Create_Update_Stop(

2168: END IF;
2169: l_stop_info.stop_id := l_stop_id;
2170: l_stop_info.trip_id :=l_trip_id;
2171: l_stop_info.DEPARTURE_SEAL_CODE := p_seal_code;
2172: WSH_TRIP_STOPS_PUB.Create_Update_Stop(
2173: p_api_version_number => 1.0
2174: ,p_init_msg_list => l_init_msg_list
2175: ,x_return_status => l_return_status
2176: ,x_msg_count => l_msg_count

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:

Line 2728: wsh_trip_stops_pub.stop_action(

2724: IF (l_debug = 1) THEN
2725: DEBUG('Interface the Trip now. Trip Id :' || p_trip_id || ' Pick Up Stop Id: ' || l_stop_id, 'Close_Trip');
2726: END IF;
2727:
2728: wsh_trip_stops_pub.stop_action(
2729: p_api_version_number => 1.0
2730: , p_init_msg_list => l_init_msg_list
2731: , x_return_status => l_return_status
2732: , x_msg_count => l_msg_count