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_DELIVERY_LEGS

Line 266: FROM wsh_delivery_legs_ob_grp_v wdl,

262: ,wnd.fob_code --Bug#9668537,9668537 and 9399092
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

Line 280: FROM wsh_delivery_legs_ob_grp_v wdl,

276: -- then trip id should be updated in wstt because user may try to close the trip from mobile.
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

Line 460: ,wsh_delivery_legs_ob_grp_v wdl

456: ELSE
457: SELECT wdi.SEQUENCE_NUMBER
458: INTO l_BOL
459: FROM wsh_document_instances wdi
460: ,wsh_delivery_legs_ob_grp_v wdl
461: WHERE wdl.delivery_id = p_delivery_id
462: AND wdi.entity_id = wdl.delivery_leg_id
463: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
464: AND rownum < 2;

Line 463: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

459: FROM wsh_document_instances wdi
460: ,wsh_delivery_legs_ob_grp_v wdl
461: WHERE wdl.delivery_id = p_delivery_id
462: AND wdi.entity_id = wdl.delivery_leg_id
463: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
464: AND rownum < 2;
465: -- Right now datamodel sugget that WDI - WDL >- WND. So for 1 delivery multiple delivery leg
466: -- multiple BOL. Desktop Application does not support this still I would like to show one BOL
467: END IF;

Line 998: FROM wsh_delivery_legs_ob_grp_v wdl,

994: -- if delivery is assigned to trip update of ship method is not allowed
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;

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 1728: FROM wsh_delivery_legs_ob_grp_v wdl,

1724: LOOP
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

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 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 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 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: