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.WSH_TRIPS_ACTIONS dependencies on WSH_NEW_DELIVERIES

Line 104: from wsh_new_deliveries dl,

100: cursor get_pickup_delivery (c_stop_id number, c_stop_location_id number) is
101: select '1'
102: from dual
103: where exists (select dl.delivery_id
104: from wsh_new_deliveries dl,
105: wsh_delivery_legs dg
106: where dg.pick_up_stop_id = c_stop_id
107: and dl.initial_pickup_location_id = c_stop_location_id
108: AND nvl(dl.shipment_direction,'O') IN ('O','IO') -- J-IB-NPARIKH

Line 113: from wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl

109: and dl.delivery_id = dg.delivery_id );
110:
111: cursor get_org_id (c_trip_id number) is
112: select distinct dl.organization_id
113: from wsh_trip_stops st, wsh_delivery_legs dg, wsh_new_deliveries dl
114: where st.trip_id = c_trip_id
115: and dg.delivery_id = dl.delivery_id
116: and st.stop_location_id = dl.initial_pickup_location_id
117: and st.stop_id = dg.pick_up_stop_id;

Line 313: FROM wsh_new_deliveries dl,

309:
310: --Bug#: 2867209 - Start
311: CURSOR c_stop_del_status(p_stop_id NUMBER) IS
312: SELECT 1
313: FROM wsh_new_deliveries dl,
314: wsh_delivery_legs dg,
315: wsh_trip_stops st,
316: wsh_trips t
317: WHERE dl.delivery_id = dg.delivery_id AND

Line 1544: wsh_new_deliveries wnd,

1540: IS
1541: SELECT wdl.delivery_id, wt.name
1542: FROM wsh_trip_stops wts,
1543: wsh_Delivery_legs wdl,
1544: wsh_new_deliveries wnd,
1545: wsh_trips wt
1546: WHERE wt.trip_id = p_trip_id
1547: AND wts.trip_id = p_trip_id
1548: AND wdl.pick_up_stop_id = wts.stop_id

Line 2141: FROM wsh_new_deliveries

2137: ULTIMATE_DROPOFF_LOCATION_ID,
2138: MODE_OF_TRANSPORT,
2139: service_level,
2140: carrier_id
2141: FROM wsh_new_deliveries
2142: WHERE delivery_id = v_delivery_id;
2143:
2144: l_del_tbl Del_Rec_Type;
2145: l_del_tbl_not_sorted Del_Rec_Type;

Line 2296: FROM wsh_new_deliveries

2292: -- created as Include/Ignore for Planning based on the delivery
2293: -- and Include for Planning if null value at delivery
2294: CURSOR c_get_del_ignoreplan (p_delid IN NUMBER,p_ignore_flag IN VARCHAR2) IS
2295: SELECT NVL(ignore_for_planning,p_ignore_flag) ignore_for_planning
2296: FROM wsh_new_deliveries
2297: WHERE delivery_id=p_delid;
2298:
2299: l_ignore_ids wsh_util_core.id_tab_type;
2300: l_include_ids wsh_util_core.id_tab_type;

Line 2517: FROM wsh_new_deliveries

2513: status_code,
2514: --OTM R12, glog proj
2515: NVL(ignore_for_planning,p_ignore_flag),
2516: initial_pickup_date, ultimate_dropoff_date , nvl(shipment_direction,'O')
2517: FROM wsh_new_deliveries
2518: WHERE delivery_id = p_del_id;
2519:
2520: l_shipment_direction VARCHAR2(100);
2521:

Line 2638: wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

2634: IF (p_entity = 'D') THEN
2635: --{
2636: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_AU_TRIP_ASSIGN_DEL');
2637: FND_MESSAGE.SET_TOKEN('DEL_NAME',
2638: wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
2639: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2640: l_num_skipped := l_num_skipped + 1;
2641: --}
2642: END IF;

Line 2688: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

2684: IF (l_initial_pickup_date is NULL or l_ultimate_dropoff_date is NULL)
2685: AND nvl(l_shipment_direction,'O') IN ('O', 'IO') THEN--{
2686: --
2687: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DATES_MISSING');
2688: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
2689: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
2690: l_num_skipped := l_num_skipped + 1;
2691: --
2692: ELSE

Line 3151: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

3147: l_num_warnings NUMBER;
3148: l_msg_count NUMBER;
3149: l_msg_data VARCHAR2(2000);
3150: --dummy tables for calling validate_constraint_mainper
3151: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3152: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3153: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3154: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3155: l_cc_in_ids wsh_util_core.id_tab_type;

Line 3160: FROM wsh_new_deliveries

3156: l_cc_fail_ids wsh_util_core.id_tab_type;
3157:
3158: CURSOR del_cur(p_dlvy_id NUMBER) IS
3159: SELECT SHIP_METHOD_CODE, INTMED_SHIP_TO_LOCATION_ID
3160: FROM wsh_new_deliveries
3161: WHERE delivery_id = p_dlvy_id;
3162: --and (SHIP_METHOD_CODE is not null OR INTMED_SHIP_TO_LOCATION_ID is not null);
3163:
3164: CURSOR trip_cur(p_trip_id NUMBER) IS

Line 3346: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null

3342: FOR delcurtemp in del_cur(l_id_tab_temp(i)) LOOP--{
3343: l_cc_dlvy_intmed_ship_to:=delcurtemp.INTMED_SHIP_TO_LOCATION_ID;
3344: l_cc_dlvy_ship_method:=delcurtemp.SHIP_METHOD_CODE;
3345: IF l_cc_upd_dlvy_intmed_ship_to='N' and l_cc_dlvy_intmed_ship_to IS NOT NULL THEN--{
3346: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null
3347: where delivery_id=l_id_tab_temp(i);
3348: END IF;--}
3349: --IF l_cc_upd_dlvy_ship_method='N' and l_cc_dlvy_ship_method IS NOT NULL THEN
3350: IF l_cc_upd_dlvy_ship_method='N' THEN--{

Line 3351: update wsh_new_deliveries

3347: where delivery_id=l_id_tab_temp(i);
3348: END IF;--}
3349: --IF l_cc_upd_dlvy_ship_method='N' and l_cc_dlvy_ship_method IS NOT NULL THEN
3350: IF l_cc_upd_dlvy_ship_method='N' THEN--{
3351: update wsh_new_deliveries
3352: set SHIP_METHOD_CODE=null,
3353: CARRIER_ID = null,
3354: MODE_OF_TRANSPORT = null,
3355: SERVICE_LEVEL = null

Line 3444: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null

3440: FOR delcurtemp in del_cur(x_del_rows(i)) LOOP--{
3441: l_cc_dlvy_intmed_ship_to:=delcurtemp.INTMED_SHIP_TO_LOCATION_ID;
3442: l_cc_dlvy_ship_method:=delcurtemp.SHIP_METHOD_CODE;
3443: IF l_cc_upd_dlvy_intmed_ship_to='N' and l_cc_dlvy_intmed_ship_to IS NOT NULL THEN--{
3444: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null
3445: where delivery_id=x_del_rows(i);
3446: END IF;--}
3447: --IF l_cc_upd_dlvy_ship_method='N' and l_cc_dlvy_ship_method IS NOT NULL THEN
3448: IF l_cc_upd_dlvy_ship_method='N' THEN--{

Line 3449: update wsh_new_deliveries

3445: where delivery_id=x_del_rows(i);
3446: END IF;--}
3447: --IF l_cc_upd_dlvy_ship_method='N' and l_cc_dlvy_ship_method IS NOT NULL THEN
3448: IF l_cc_upd_dlvy_ship_method='N' THEN--{
3449: update wsh_new_deliveries
3450: set SHIP_METHOD_CODE=null,
3451: CARRIER_ID = null,
3452: MODE_OF_TRANSPORT = null,
3453: SERVICE_LEVEL = null

Line 4069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4065: --
4066: -- Debug Statements
4067: --
4068: IF l_debug_on THEN
4069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4070: END IF;
4071: --
4072: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4072: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

4068: IF l_debug_on THEN
4069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4070: END IF;
4071: --
4072: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4074: wsh_util_core.add_message(x_return_status);
4075: warn_flag := TRUE;
4076:

Line 4102: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4098: --
4099: -- Debug Statements
4100: --
4101: IF l_debug_on THEN
4102: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4103: END IF;
4104: --
4105: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4105: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

4101: IF l_debug_on THEN
4102: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4103: END IF;
4104: --
4105: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
4106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4107: wsh_util_core.add_message(x_return_status);
4108: warn_flag := TRUE;
4109:

Line 4265: FROM wsh_new_deliveries

4261:
4262: CURSOR delivery_info (del_id IN NUMBER) IS
4263: SELECT initial_pickup_location_id,
4264: ultimate_dropoff_location_id
4265: FROM wsh_new_deliveries
4266: WHERE delivery_id = del_id;
4267:
4268: CURSOR C_DEL_PHYS_DROPOFF (del_id IN NUMBER, loc_id IN NUMBER) IS
4269: SELECT 'Y'

Line 4270: FROM wsh_new_deliveries

4266: WHERE delivery_id = del_id;
4267:
4268: CURSOR C_DEL_PHYS_DROPOFF (del_id IN NUMBER, loc_id IN NUMBER) IS
4269: SELECT 'Y'
4270: FROM wsh_new_deliveries
4271: WHERE delivery_id = del_id
4272: AND ultimate_dropoff_location_id=loc_id;
4273:
4274: l_phys_trip_pickup_loc_id NUMBER;

Line 5451: wsh_new_deliveries dl

5447: dl.volume,
5448: dl.organization_id
5449: FROM wsh_trip_stops t,
5450: wsh_delivery_legs dg,
5451: wsh_new_deliveries dl
5452: WHERE t.stop_id = l_stop_id AND
5453: dg.pick_up_stop_id = t.stop_id AND
5454: dl.delivery_id = dg.delivery_id AND
5455: dg.parent_delivery_leg_id is NULL;

Line 5462: wsh_new_deliveries dl

5458: SELECT dl.delivery_id d_id,
5459: dl.organization_id
5460: FROM wsh_trip_stops t,
5461: wsh_delivery_legs dg,
5462: wsh_new_deliveries dl
5463: WHERE t.stop_id = l_stop_id AND
5464: dg.drop_off_stop_id = t.stop_id AND
5465: dl.delivery_id = dg.delivery_id AND
5466: dg.parent_delivery_leg_id is NULL;

Line 5863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

5859: --
5860: -- Debug Statements
5861: --
5862: IF l_debug_on THEN
5863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5864: END IF;
5865: --
5866: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));
5867: g_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5866: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));

5862: IF l_debug_on THEN
5863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5864: END IF;
5865: --
5866: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));
5867: g_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5868: wsh_util_core.add_message(g_return_status);
5869: END IF;
5870:

Line 8140: FROM wsh_new_deliveries wnd,

8136: CURSOR c_get_firststop_dlvy(c_stop_id IN NUMBER) IS
8137: SELECT wnd.DELIVERY_ID
8138: , wnd.CUSTOMER_ID
8139: , wnd.ORGANIZATION_ID
8140: FROM wsh_new_deliveries wnd,
8141: wsh_delivery_legs wdl,
8142: wsh_trip_stops wts1
8143: WHERE wnd.delivery_id = wdl.delivery_id
8144: AND wdl.pick_up_stop_id = wts1.stop_id

Line 8153: FROM wsh_new_deliveries wnd,

8149: CURSOR c_get_laststop_dlvy(c_stop_id IN NUMBER) IS
8150: SELECT wnd.DELIVERY_ID
8151: , wnd.CUSTOMER_ID
8152: , wnd.ORGANIZATION_ID
8153: FROM wsh_new_deliveries wnd,
8154: wsh_delivery_legs wdl,
8155: wsh_trip_stops wts1
8156: WHERE wnd.delivery_id = wdl.delivery_id
8157: AND wdl.drop_off_stop_id = wts1.stop_id

Line 8896: from wsh_new_deliveries d, wsh_trip_stops s, wsh_delivery_legs l

8892: x_return_status OUT NOCOPY VARCHAR2) IS
8893:
8894: cursor c_get_trip_deliveries(p_trip_id in number) is
8895: select d.delivery_id, d.delivery_type
8896: from wsh_new_deliveries d, wsh_trip_stops s, wsh_delivery_legs l
8897: where d.delivery_id = l.delivery_id
8898: and l.pick_up_stop_id = s.stop_id
8899: and s.trip_id = p_trip_id
8900: order by d.delivery_type;