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 315: FROM wsh_new_deliveries dl,

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

Line 1546: wsh_new_deliveries wnd,

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

Line 2143: FROM wsh_new_deliveries

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

Line 2298: FROM wsh_new_deliveries

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

Line 2519: FROM wsh_new_deliveries

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

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

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

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

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

Line 3153: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

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

Line 3162: FROM wsh_new_deliveries

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

Line 3348: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null

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

Line 3353: update wsh_new_deliveries

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

Line 3446: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null

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

Line 3451: update wsh_new_deliveries

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

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

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

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

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

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

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

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

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

Line 4267: FROM wsh_new_deliveries

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

Line 4272: FROM wsh_new_deliveries

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

Line 5453: wsh_new_deliveries dl

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

Line 5464: wsh_new_deliveries dl

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

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

5865: --
5866: -- Debug Statements
5867: --
5868: IF l_debug_on THEN
5869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5870: END IF;
5871: --
5872: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));
5873: g_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

5868: IF l_debug_on THEN
5869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5870: END IF;
5871: --
5872: FND_MESSAGE.SET_TOKEN('del_name',wsh_new_deliveries_pvt.get_name(pkup_dl.d_id));
5873: g_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5874: wsh_util_core.add_message(g_return_status);
5875: END IF;
5876:

Line 8151: FROM wsh_new_deliveries wnd,

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

Line 8164: FROM wsh_new_deliveries wnd,

8160: CURSOR c_get_laststop_dlvy(c_stop_id IN NUMBER) IS
8161: SELECT wnd.DELIVERY_ID
8162: , wnd.CUSTOMER_ID
8163: , wnd.ORGANIZATION_ID
8164: FROM wsh_new_deliveries wnd,
8165: wsh_delivery_legs wdl,
8166: wsh_trip_stops wts1
8167: WHERE wnd.delivery_id = wdl.delivery_id
8168: AND wdl.drop_off_stop_id = wts1.stop_id

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

8903: x_return_status OUT NOCOPY VARCHAR2) IS
8904:
8905: cursor c_get_trip_deliveries(p_trip_id in number) is
8906: select d.delivery_id, d.delivery_type
8907: from wsh_new_deliveries d, wsh_trip_stops s, wsh_delivery_legs l
8908: where d.delivery_id = l.delivery_id
8909: and l.pick_up_stop_id = s.stop_id
8910: and s.trip_id = p_trip_id
8911: order by d.delivery_type;