eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_TRIP_STOPS

Line 223: ,wsh_trip_stops_ob_grp_v wts

219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
221: ,wt.ship_method_code
222: FROM wsh_trips_ob_grp_v wt
223: ,wsh_trip_stops_ob_grp_v wts
224: ,mtl_system_items_kfv msi
225: WHERE wt.trip_id = p_trip_id
226: AND wt.trip_id = wts.trip_id
227: AND (wt.vehicle_item_id = msi.inventory_item_id(+)

Line 267: wsh_trip_stops_ob_grp_v wts

263: FROM wsh_new_deliveries_ob_grp_v wnd,
264: -- 2767767
265: (SELECT wdl.delivery_id,wts.trip_id
266: FROM wsh_delivery_legs_ob_grp_v wdl,
267: wsh_trip_stops_ob_grp_v wts
268: WHERE wdl.delivery_id=p_delivery_id
269: AND wdl.pick_up_stop_id=wts.stop_id
270: AND ROWNUM=1) wts1 -- end 2767767
271: WHERE wnd.delivery_id = p_delivery_id

Line 281: wsh_trip_stops_ob_grp_v wts,

277: BEGIN
278: SELECT wts.trip_id,wt.name
279: INTO l_trip_id,l_trip_name
280: FROM wsh_delivery_legs_ob_grp_v wdl,
281: wsh_trip_stops_ob_grp_v wts,
282: wsh_trips_ob_grp_v wt
283: WHERE wdl.delivery_id=p_delivery_id
284: AND wdl.pick_up_stop_id=wts.stop_id
285: AND wt.trip_id=wts.trip_id

Line 999: wsh_trip_stops_ob_grp_v wts

995: BEGIN
996: SELECT distinct wts.trip_id
997: INTO l_trip_id
998: FROM wsh_delivery_legs_ob_grp_v wdl,
999: wsh_trip_stops_ob_grp_v wts
1000: WHERE wdl.delivery_id=p_delivery_id
1001: AND wdl.pick_up_stop_id=wts.stop_id
1002: AND rownum=1;
1003: IF (l_debug = 1) THEN

Line 1235: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt

1231:
1232: CURSOR c_Get_Trip(v_del_id NUMBER) IS
1233: select wt.trip_id , wt.carrier_id, wt.ship_method_code, wt.mode_of_transport,
1234: wt.tp_plan_name -- glog proj
1235: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
1236: where wdl.pick_up_stop_id=wts.stop_id
1237: and wdl.delivery_id=v_del_id
1238: and wts.trip_id=wt.trip_id;
1239:

Line 1729: wsh_trip_stops_ob_grp_v wts,

1725: BEGIN
1726: SELECT wts.trip_id,wt.name
1727: INTO l_trip_id,l_trip_name
1728: FROM wsh_delivery_legs_ob_grp_v wdl,
1729: wsh_trip_stops_ob_grp_v wts,
1730: wsh_trips_ob_grp_v wt
1731: WHERE wdl.delivery_id=l_deliveries.delivery_id
1732: AND wdl.pick_up_stop_id=wts.stop_id
1733: AND wt.trip_id=wts.trip_id

Line 1904: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

1900: -- Add the following code in case user created Trip manually from desktop
1901: BEGIN
1902: SELECT wts.trip_id
1903: INTO l_trip_id
1904: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
1905: WHERE wdl.delivery_id = p_delivery_id --l_delivery_id /* bug 2741857 */
1906: and wdl.pick_up_stop_id = wts.stop_id;
1907:
1908: IF l_trip_id IS NOT NULL THEN

Line 2095: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;

2091: l_msg_count NUMBER;
2092: l_msg_data VARCHAR2(20000);
2093:
2094: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2095: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;
2096: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2097: l_freight_cost_id NUMBER;
2098: l_stop_id NUMBER;
2099: l_trip_id NUMBER;

Line 2121: FROM wsh_trip_stops_ob_grp_v

2117: FOR UPDATE OF FREIGHT_COST_ID NOWAIT;
2118:
2119: CURSOR stops IS
2120: SELECT 'x'
2121: FROM wsh_trip_stops_ob_grp_v
2122: WHERE trip_id = p_trip_id
2123: FOR UPDATE NOWAIT;
2124:
2125: CURSOR trips IS

Line 2252: FROM WSH_TRIP_STOPS_OB_GRP_V wts, WSH_DELIVERY_LEGS_OB_GRP_V wdl

2248:
2249:
2250: SELECT stop_id
2251: INTO l_stop_id
2252: FROM WSH_TRIP_STOPS_OB_GRP_V wts, WSH_DELIVERY_LEGS_OB_GRP_V wdl
2253: -- WHERE wts.trip_id = p_trip_id
2254: WHERE wts.trip_id=l_trip_id
2255: AND wts.stop_id = wdl.pick_up_stop_id
2256: AND ROWNUM <2;

Line 2263: debug('Call WSH_TRIP_STOPS_PUB.Create_Update_Stop to Update the Seal Code','Update Trip Stop');

2259:
2260: IF (p_seal_code IS NOT NULL ) THEN
2261: --patchset J. Shipping API cleanup
2262: IF (l_debug = 1) THEN
2263: debug('Call WSH_TRIP_STOPS_PUB.Create_Update_Stop to Update the Seal Code','Update Trip Stop');
2264: END IF;
2265: l_stop_info.stop_id := l_stop_id;
2266: l_stop_info.trip_id :=l_trip_id;
2267: l_stop_info.DEPARTURE_SEAL_CODE := p_seal_code;

Line 2268: WSH_TRIP_STOPS_PUB.Create_Update_Stop(

2264: END IF;
2265: l_stop_info.stop_id := l_stop_id;
2266: l_stop_info.trip_id :=l_trip_id;
2267: l_stop_info.DEPARTURE_SEAL_CODE := p_seal_code;
2268: WSH_TRIP_STOPS_PUB.Create_Update_Stop(
2269: p_api_version_number => 1.0
2270: ,p_init_msg_list => l_init_msg_list
2271: ,x_return_status => l_return_status
2272: ,x_msg_count => l_msg_count

Line 2408: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

2404: , p_ship_method_code IN VARCHAR2 DEFAULT NULL
2405: ) IS
2406: CURSOR stop_cur IS
2407: SELECT wdl.pick_up_stop_id pick_up_stop_id
2408: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
2409: WHERE wts.trip_id = p_trip_id
2410: AND wdl.pick_up_stop_id = wts.stop_id;
2411:
2412: CURSOR del_cur IS

Line 2414: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

2410: AND wdl.pick_up_stop_id = wts.stop_id;
2411:
2412: CURSOR del_cur IS
2413: SELECT delivery_id
2414: FROM wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts
2415: WHERE wts.trip_id = p_trip_id
2416: AND wdl.pick_up_stop_id = wts.stop_id;
2417:
2418: l_del_cur del_cur%ROWTYPE;

Line 2821: FROM wsh_trip_stops_ob_grp_v wts, wsh_delivery_legs_ob_grp_v wdl

2817: END IF;
2818:
2819: SELECT stop_id
2820: INTO l_stop_id
2821: FROM wsh_trip_stops_ob_grp_v wts, wsh_delivery_legs_ob_grp_v wdl
2822: WHERE wts.trip_id = p_trip_id
2823: AND wts.stop_id = wdl.pick_up_stop_id
2824: AND ROWNUM < 2;
2825:

Line 2830: wsh_trip_stops_pub.stop_action(

2826: IF (l_debug = 1) THEN
2827: DEBUG('Interface the Trip now. Trip Id :' || p_trip_id || ' Pick Up Stop Id: ' || l_stop_id, 'Close_Trip');
2828: END IF;
2829:
2830: wsh_trip_stops_pub.stop_action(
2831: p_api_version_number => 1.0
2832: , p_init_msg_list => l_init_msg_list
2833: , x_return_status => l_return_status
2834: , x_msg_count => l_msg_count

Line 2874: FROM wsh_trip_stops_ob_grp_v wts, wsh_delivery_legs_ob_grp_v wdl

2870: END IF;
2871:
2872: SELECT stop_id
2873: INTO l_stop_id
2874: FROM wsh_trip_stops_ob_grp_v wts, wsh_delivery_legs_ob_grp_v wdl
2875: WHERE wts.trip_id = p_trip_id
2876: AND wts.stop_id = wdl.drop_off_stop_id
2877: AND ROWNUM < 2;
2878:

Line 2883: wsh_trip_stops_pub.stop_action(

2879: IF (l_debug = 1) THEN
2880: DEBUG(' Trip Id :' || p_trip_id || ' Drop Off Stop Id: ' || l_stop_id, 'Close_Trip');
2881: END IF;
2882:
2883: wsh_trip_stops_pub.stop_action(
2884: p_api_version_number => 1.0
2885: , p_init_msg_list => l_init_msg_list
2886: , x_return_status => l_return_status
2887: , x_msg_count => l_msg_count