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 200: FROM wsh_new_deliveries

196: wsh_invalid_action EXCEPTION;
197:
198: CURSOR c_delivery_record IS
199: SELECT delivery_id
200: FROM wsh_new_deliveries
201: WHERE NAME = p_delivery_name;
202:
203: /*2777869*/
204: CURSOR c_delivery_id is

Line 206: FROM wsh_new_deliveries

202:
203: /*2777869*/
204: CURSOR c_delivery_id is
205: SELECT delivery_id
206: FROM wsh_new_deliveries
207: WHERE delivery_id = p_delivery_id;
208:
209: -- deliveryMerge
210: CURSOR c_get_assigned_delivery (c_delivery_detail_id NUMBER) IS

Line 1522: FROM wsh_new_deliveries

1518: l_assign_rec del_assign%ROWTYPE;
1519:
1520: CURSOR del_status(c_del_id NUMBER) IS
1521: SELECT status_code
1522: FROM wsh_new_deliveries
1523: WHERE delivery_id = c_del_id;
1524:
1525: l_del_status VARCHAR2(100) := NULL;
1526: l_msg_summary VARCHAR2(3000);

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

2358: status_code,
2359: planned_flag,
2360: nvl(shipment_direction, 'O'), -- shipment_direction jckwok
2361: nvl(ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
2362: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
2363: FROM wsh_new_deliveries
2364: WHERE delivery_id = p_dlvy_id;
2365:
2366: --

Line 2363: FROM wsh_new_deliveries

2359: planned_flag,
2360: nvl(shipment_direction, 'O'), -- shipment_direction jckwok
2361: nvl(ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
2362: nvl(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
2363: FROM wsh_new_deliveries
2364: WHERE delivery_id = p_dlvy_id;
2365:
2366: --
2367: -- deliveryMerge

Line 2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2408: l_cc_return_status VARCHAR2(1);
2409: l_trip_id NUMBER;
2410:
2411: --dummy tables for calling validate_constraint_mainper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;

Line 2423: FROM wsh_new_deliveries

2419: l_delivery_detail_id NUMBER;
2420:
2421: CURSOR c_delcur(p_dlvy_id NUMBER) IS
2422: SELECT SHIP_METHOD_CODE, INTMED_SHIP_TO_LOCATION_ID
2423: FROM wsh_new_deliveries
2424: WHERE delivery_id = p_dlvy_id;
2425:
2426: --Compatibility Changes
2427:

Line 2456: l_dlvy_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

2452: -- K LPN CONV. rv
2453: --
2454:
2455: -- OTM R12 : due to record changes in WSHDEVLS
2456: l_dlvy_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2457: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2458: -- End of OTM R12 : due to record changes in WSHDEVLS
2459:
2460: -- OTM R12 : packing ECO

Line 2457: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

2453: --
2454:
2455: -- OTM R12 : due to record changes in WSHDEVLS
2456: l_dlvy_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2457: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2458: -- End of OTM R12 : due to record changes in WSHDEVLS
2459:
2460: -- OTM R12 : packing ECO
2461: l_gc3_is_installed VARCHAR2(1);

Line 3392: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null

3388: FOR delcurtemp in c_delcur(x_action_out_rec.delivery_id_tab(i)) LOOP
3389: l_cc_dlvy_intmed_ship_to:=delcurtemp.INTMED_SHIP_TO_LOCATION_ID;
3390: l_cc_dlvy_ship_method:=delcurtemp.SHIP_METHOD_CODE;
3391: IF l_cc_upd_dlvy_intmed_ship_to='N' and l_cc_dlvy_intmed_ship_to IS NOT NULL THEN
3392: update wsh_new_deliveries set INTMED_SHIP_TO_LOCATION_ID=null
3393: where delivery_id=x_action_out_rec.delivery_id_tab(i);
3394: END IF;
3395: --IF l_cc_upd_dlvy_ship_method='N' and l_cc_dlvy_ship_method IS NOT NULL THEN
3396: IF l_cc_upd_dlvy_ship_method='N' THEN

Line 3402: update wsh_new_deliveries

3398: -- OTM R12 : update delivery
3399: -- no code changes are needed for the following update
3400: -- since it reaches here only when FTE is installed
3401:
3402: update wsh_new_deliveries
3403: set SHIP_METHOD_CODE=null,
3404: CARRIER_ID = null,
3405: MODE_OF_TRANSPORT = null,
3406: SERVICE_LEVEL = null