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

Line 1763: FROM wsh_new_deliveries

1759: IS
1760:
1761: CURSOR del_cur(c_dlvy_id NUMBER) IS
1762: SELECT ship_method_code, intmed_ship_to_location_id
1763: FROM wsh_new_deliveries
1764: WHERE delivery_id = c_dlvy_id;
1765:
1766: l_del_details_tbl WSH_UTIL_CORE.Id_Tab_Type;
1767: l_grouping_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 1800: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

1796: l_cc_return_status VARCHAR2(1);
1797: l_cc_count_del_rows NUMBER;
1798: l_cc_count_grouping_rows NUMBER;
1799: --dummy tables for calling validate_constraint_main
1800: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1801: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1802: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1803: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1804: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;

Line 2024: UPDATE wsh_new_deliveries

2020: FOR delcurtemp in del_cur(l_delivery_ids_tbl(i)) LOOP
2021: l_cc_dlvy_intmed_ship_to := delcurtemp.INTMED_SHIP_TO_LOCATION_ID;
2022: l_cc_dlvy_ship_method := delcurtemp.SHIP_METHOD_CODE;
2023: IF l_cc_upd_dlvy_intmed_ship_to = 'N' and l_cc_dlvy_intmed_ship_to IS NOT NULL THEN
2024: UPDATE wsh_new_deliveries
2025: SET intmed_ship_to_location_id = NULL
2026: WHERE delivery_id = l_delivery_ids_tbl(i);
2027: END IF;
2028: --IF l_cc_upd_dlvy_ship_method = 'N' and l_cc_dlvy_ship_method IS NOT NULL THEN

Line 2033: UPDATE wsh_new_deliveries

2029: IF l_cc_upd_dlvy_ship_method = 'N' THEN
2030:
2031: --OTM R12, this update is FTE part of code, OTM flow will not go through here
2032:
2033: UPDATE wsh_new_deliveries
2034: SET ship_method_code = NULL,
2035: carrier_id = NULL,
2036: mode_of_transport = NULL,
2037: service_level = NULL

Line 2175: UPDATE wsh_new_deliveries

2171: FOR delcurtemp in del_cur(l_delivery_ids_tbl(i)) LOOP
2172: l_cc_dlvy_intmed_ship_to := delcurtemp.INTMED_SHIP_TO_LOCATION_ID;
2173: l_cc_dlvy_ship_method := delcurtemp.SHIP_METHOD_CODE;
2174: IF l_cc_upd_dlvy_intmed_ship_to = 'N' and l_cc_dlvy_intmed_ship_to IS NOT NULL THEN
2175: UPDATE wsh_new_deliveries
2176: SET intmed_ship_to_location_id = NULL
2177: WHERE delivery_id = l_delivery_ids_tbl(i);
2178: END IF;
2179: --IF l_cc_upd_dlvy_ship_method = 'N' and l_cc_dlvy_ship_method IS NOT NULL THEN

Line 2184: UPDATE wsh_new_deliveries

2180: IF l_cc_upd_dlvy_ship_method = 'N' THEN
2181:
2182: --OTM R12, this update is FTE part of code, OTM flow will not go through here
2183:
2184: UPDATE wsh_new_deliveries
2185: SET ship_method_code = NULL,
2186: carrier_id = NULL,
2187: mode_of_transport = NULL,
2188: service_level = NULL

Line 3550: FROM WSH_NEW_DELIVERIES WND,

3546: v_FromReqDate IN DATE,
3547: v_ToReqDate IN DATE
3548: ) IS
3549: SELECT DISTINCT WND.ORGANIZATION_ID
3550: FROM WSH_NEW_DELIVERIES WND,
3551: WSH_DELIVERY_LEGS WLG,
3552: WSH_TRIP_STOPS WTS
3553: WHERE WTS.TRIP_ID = v_trip_id
3554: AND WTS.STOP_ID = WLG.PICK_UP_STOP_ID

Line 3571: FROM WSH_NEW_DELIVERIES WND,

3567: AND wl.source_location_id =
3568: hr.location_id))
3569: UNION ALL
3570: SELECT DISTINCT WND.ORGANIZATION_ID
3571: FROM WSH_NEW_DELIVERIES WND,
3572: WSH_DELIVERY_LEGS WLG,
3573: WSH_TRIP_STOPS WTS
3574: WHERE WTS.STOP_ID = WLG.PICK_UP_STOP_ID
3575: AND WLG.DELIVERY_ID = WND.DELIVERY_ID

Line 3583: FROM WSH_NEW_DELIVERIES WND

3579: AND v_order_hdr_id = 0
3580: AND v_del_detail_id in (0,-1)
3581: UNION ALL
3582: SELECT WND.ORGANIZATION_ID
3583: FROM WSH_NEW_DELIVERIES WND
3584: WHERE WND.DELIVERY_ID = v_delivery_id
3585: AND nvl(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics
3586: UNION ALL
3587: SELECT DISTINCT ORGANIZATION_ID

Line 3653: wsh_new_deliveries wnd

3649: wdd.line_direction, wdd.gross_weight, wdd.net_weight, wdd.volume,
3650: wnd.planned_flag, wnd.batch_id
3651: FROM wsh_delivery_details wdd,
3652: wsh_delivery_assignments_v wda,
3653: wsh_new_deliveries wnd
3654: WHERE wdd.batch_id = l_batch_id
3655: AND wdd.delivery_detail_id = wda.delivery_detail_id
3656: AND wdd.released_status = 'B'
3657: AND wdd.replenishment_status IS NULL -- replenishment2, select only back order delivery lines.

Line 3717: FROM wsh_new_deliveries wnd,

3713:
3714: CURSOR get_pick_up_stops (c_sc_batch_id NUMBER) IS
3715: SELECT DISTINCT wtp.trip_id, wst.stop_sequence_number,
3716: wst.stop_id, wst.stop_location_id
3717: FROM wsh_new_deliveries wnd,
3718: wsh_delivery_legs wlg,
3719: wsh_trip_stops wst,
3720: wsh_trips wtp
3721: WHERE wnd.delivery_id = wlg.delivery_id AND

Line 3739: FROM wsh_new_deliveries wnd,

3735:
3736: CURSOR get_all_stops (c_sc_batch_id NUMBER) IS
3737: SELECT wtp.trip_id, wst.stop_sequence_number, wst.stop_id ,
3738: wst.stop_location_id
3739: FROM wsh_new_deliveries wnd,
3740: wsh_delivery_legs wlg,
3741: wsh_trip_stops wst,
3742: wsh_trips wtp
3743: WHERE wnd.delivery_id = wlg.delivery_id and

Line 3758: FROM wsh_new_deliveries wnd2,

3754: we.EXCEPTION_NAME = 'WSH_SC_REQ_EXPORT_COMPL')
3755: UNION (
3756: SELECT wtp2.trip_id, wst2.stop_sequence_number,
3757: wst2.stop_id, wst2.stop_location_id
3758: FROM wsh_new_deliveries wnd2,
3759: wsh_delivery_legs wlg2,
3760: wsh_trip_stops wst2,
3761: wsh_trips wtp2
3762: WHERE wnd2.delivery_id = wlg2.delivery_id and

Line 3781: wsh_new_deliveries wnd,

3777: CURSOR c_batch_stop(l_batch_id NUMBER) IS
3778: SELECT wts.stop_id
3779: FROM wsh_trip_stops wts,
3780: wsh_delivery_legs wdl,
3781: wsh_new_deliveries wnd,
3782: wsh_picking_batches wpb
3783: WHERE p_batch_id IS NOT NULL
3784: AND wnd.batch_id = l_batch_id
3785: AND wdl.delivery_id = wnd.delivery_id

Line 3796: wsh_new_deliveries wnd,

3792: CURSOR c_batch_unplanned_del(l_batch_id NUMBER) IS
3793: SELECT DISTINCT wda.delivery_id
3794: FROM wsh_delivery_details wdd,
3795: wsh_delivery_assignments_v wda,
3796: wsh_new_deliveries wnd,
3797: wsh_shipping_parameters wsp
3798: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3799: AND wdd.batch_id = l_batch_id
3800: AND wdd.released_status = 'Y'

Line 3838: FROM wsh_new_deliveries

3834:
3835:
3836: CURSOR c_dels_in_batch(l_batch_id NUMBER, p_organization_id NUMBER) IS
3837: SELECT delivery_id
3838: FROM wsh_new_deliveries
3839: WHERE batch_id = l_batch_id
3840: AND organization_id = p_organization_id;
3841:
3842: CURSOR c_get_location(p_delivery_id NUMBER) IS

Line 3844: FROM wsh_new_deliveries

3840: AND organization_id = p_organization_id;
3841:
3842: CURSOR c_get_location(p_delivery_id NUMBER) IS
3843: SELECT initial_pickup_location_id
3844: FROM wsh_new_deliveries
3845: WHERE delivery_id = p_delivery_id;
3846:
3847: CURSOR c_requests (p_parent_request_id NUMBER) IS
3848: SELECT request_id

Line 5417: UPDATE wsh_new_deliveries

5413: l_completion_status := 'WARNING';
5414: END IF;
5415:
5416: -- Reset delivery batch id.
5417: UPDATE wsh_new_deliveries
5418: SET batch_id = NULL
5419: WHERE batch_id = g_batch_id;
5420:
5421: --Bug 3433645 :Automated Shipping Failing for Order with Huge Delivery Lines

Line 6989: select status_code, organization_id from wsh_new_deliveries

6985: where stop_id = c_stop_id;
6986:
6987: --Cursor to get delivery attributes.
6988: CURSOR check_delivery(c_delivery_id IN NUMBER) IS
6989: select status_code, organization_id from wsh_new_deliveries
6990: where delivery_id = c_delivery_id;
6991:
6992: CURSOR check_detail (c_delivery_detail_id IN NUMBER) IS
6993: select released_status from wsh_delivery_details

Line 7258: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);

7254: ELSIF (p_delivery_ids.COUNT > 0) THEN
7255: l_index := p_delivery_ids.FIRST;
7256: l_delivery_id := p_delivery_ids(l_index);
7257: --
7258: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);
7259: l_type := 'Delivery';
7260: ELSIF (p_detail_ids.COUNT > 0) THEN
7261: l_index := p_detail_ids.FIRST;
7262: l_detail_id := p_detail_ids(l_index);

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

7743: l_index := p_delivery_ids.NEXT(l_index);
7744: l_delivery_id := p_delivery_ids(l_index);
7745: --
7746: IF l_debug_on THEN
7747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7748: END IF;
7749: --
7750: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);
7751: ELSE

Line 7750: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);

7746: IF l_debug_on THEN
7747: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
7748: END IF;
7749: --
7750: l_name := WSH_NEW_DELIVERIES_PVT.Get_Name(l_delivery_id);
7751: ELSE
7752: EXIT; -- Only one loop when launching pick release for delivery details.
7753: END IF;
7754: