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_DELIVERY_DETAILS_GRP dependencies on WSH_NEW_DELIVERIES

Line 204: FROM wsh_new_deliveries

200: wsh_invalid_action EXCEPTION;
201:
202: CURSOR c_delivery_record IS
203: SELECT delivery_id
204: FROM wsh_new_deliveries
205: WHERE NAME = p_delivery_name;
206:
207: /*2777869*/
208: CURSOR c_delivery_id is

Line 210: FROM wsh_new_deliveries

206:
207: /*2777869*/
208: CURSOR c_delivery_id is
209: SELECT delivery_id
210: FROM wsh_new_deliveries
211: WHERE delivery_id = p_delivery_id;
212:
213: -- deliveryMerge
214: CURSOR c_get_assigned_delivery (c_delivery_detail_id NUMBER) IS

Line 1526: FROM wsh_new_deliveries

1522: l_assign_rec del_assign%ROWTYPE;
1523:
1524: CURSOR del_status(c_del_id NUMBER) IS
1525: SELECT status_code
1526: FROM wsh_new_deliveries
1527: WHERE delivery_id = c_del_id;
1528:
1529: l_del_status VARCHAR2(100) := NULL;
1530: l_msg_summary VARCHAR2(3000);

Line 2368: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record

2364: status_code,
2365: planned_flag,
2366: nvl(shipment_direction, 'O'), -- shipment_direction jckwok
2367: nvl(ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
2368: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
2369: FROM wsh_new_deliveries
2370: WHERE delivery_id = p_dlvy_id;
2371:
2372: --

Line 2369: FROM wsh_new_deliveries

2365: planned_flag,
2366: nvl(shipment_direction, 'O'), -- shipment_direction jckwok
2367: nvl(ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
2368: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
2369: FROM wsh_new_deliveries
2370: WHERE delivery_id = p_dlvy_id;
2371:
2372: --
2373: -- deliveryMerge

Line 2418: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2414: l_cc_return_status VARCHAR2(1);
2415: l_trip_id NUMBER;
2416:
2417: --dummy tables for calling validate_constraint_mainper
2418: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2419: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2420: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2421: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2422: l_cc_in_ids wsh_util_core.id_tab_type;

Line 2429: FROM wsh_new_deliveries

2425: l_delivery_detail_id NUMBER;
2426:
2427: CURSOR c_delcur(p_dlvy_id NUMBER) IS
2428: SELECT SHIP_METHOD_CODE, INTMED_SHIP_TO_LOCATION_ID
2429: FROM wsh_new_deliveries
2430: WHERE delivery_id = p_dlvy_id;
2431:
2432: --Compatibility Changes
2433:

Line 2462: l_dlvy_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

2458: -- K LPN CONV. rv
2459: --
2460:
2461: -- OTM R12 : due to record changes in WSHDEVLS
2462: l_dlvy_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2463: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2464: -- End of OTM R12 : due to record changes in WSHDEVLS
2465:
2466: -- OTM R12 : packing ECO

Line 2463: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

2459: --
2460:
2461: -- OTM R12 : due to record changes in WSHDEVLS
2462: l_dlvy_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2463: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2464: -- End of OTM R12 : due to record changes in WSHDEVLS
2465:
2466: -- OTM R12 : packing ECO
2467: l_gc3_is_installed VARCHAR2(1);

Line 3399: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null

3395: FOR delcurtemp in c_delcur(x_action_out_rec.delivery_id_tab(i)) LOOP
3396: l_cc_dlvy_intmed_ship_to:=delcurtemp.INTMED_SHIP_TO_LOCATION_ID;
3397: l_cc_dlvy_ship_method:=delcurtemp.SHIP_METHOD_CODE;
3398: IF l_cc_upd_dlvy_intmed_ship_to='N' and l_cc_dlvy_intmed_ship_to IS NOT NULL THEN
3399: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null
3400: where delivery_id=x_action_out_rec.delivery_id_tab(i);
3401: END IF;
3402: --IF l_cc_upd_dlvy_ship_method='N' and l_cc_dlvy_ship_method IS NOT NULL THEN
3403: IF l_cc_upd_dlvy_ship_method='N' THEN

Line 3409: update wsh_new_deliveries

3405: -- OTM R12 : update delivery
3406: -- no code changes are needed for the following update
3407: -- since it reaches here only when FTE is installed
3408:
3409: update wsh_new_deliveries
3410: set SHIP_METHOD_CODE=null,
3411: CARRIER_ID = null,
3412: MODE_OF_TRANSPORT = null,
3413: SERVICE_LEVEL = null