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_DELIVERY_DETAILS

Line 620: FROM wsh_delivery_details

616: AND type = 'PRINTER';
617:
618: CURSOR c_order_number(l_header_id NUMBER) IS
619: SELECT source_header_number
620: FROM wsh_delivery_details
621: WHERE source_header_id = l_header_id
622: AND rownum = 1;
623:
624: l_debug_on BOOLEAN;

Line 830: wsh_delivery_legs wdl, wsh_delivery_details wdd

826: --Cursor to get the Trip stop id associated with the PickUp Stop of delivery detail line.
827: CURSOR get_dd_pup_trip_stop(v_org_id IN NUMBER, v_dd_id NUMBER) IS
828: SELECT wts.STOP_ID
829: FROM wsh_trips wt, wsh_trip_stops wts, wsh_delivery_assignments_v wda,
830: wsh_delivery_legs wdl, wsh_delivery_details wdd
831: WHERE wdd.delivery_detail_id = v_dd_id
832: AND wdd.organization_id = v_org_id
833: AND wda.delivery_detail_id = wdd.delivery_detail_id
834: AND wdl.delivery_id = wda.delivery_id

Line 841: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

837:
838: -- Workflow Change
839: CURSOR c_get_picked_lines_count (c_delivery_detail_id NUMBER) IS
840: SELECT count (wdd.delivery_detail_id), delivery_id
841: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
842: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
843: AND wda.delivery_id = ( SELECT delivery_id
844: FROM wsh_delivery_assignments_v
845: WHERE delivery_detail_id = c_delivery_detail_id )

Line 1164: ELSIF (WSH_PR_CRITERIA.release_table(i).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN --{

1160: l_rel_delivery_detail_id(l_count_x_relstatus_details):= WSH_PR_CRITERIA.release_table(i).delivery_detail_id;
1161: --}
1162: -- X-dock, X-dock lines which have been processed above
1163: -- will have released status of S
1164: ELSIF (WSH_PR_CRITERIA.release_table(i).released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN --{
1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.logmsg(l_module_name,'IGNORING PLANNED X-DOCK LINE FOR MOVE ORDER LINE CREATION');
1167: END IF;
1168: --}

Line 1373: UPDATE wsh_delivery_details

1369: --{
1370: -- Bulk Update all Non-Transactable lines as Staged
1371: IF (l_count_x_relstatus_details > 0) THEN
1372: FOR i IN 1..l_count_x_relstatus_details LOOP
1373: UPDATE wsh_delivery_details
1374: SET released_status = 'Y',
1375: batch_id = p_batch_id,
1376: last_updated_by = l_user_id,
1377: last_update_date = l_date,

Line 1397: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.

1393: END IF;
1394: --Done Raise Event: Pick To Pod Workflow
1395: END LOOP;
1396:
1397: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.
1398: IF l_debug_on THEN
1399: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_rel_delivery_detail_id.count);
1400: END IF;
1401: WSH_INTEGRATION.DBI_Update_Detail_Log (

Line 1662: UPDATE wsh_delivery_details

1658: IF (g_trolin_tbl(i).return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1659: IF l_debug_on THEN
1660: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE WITH TROLIN.LINE_ID ' || G_TROLIN_TBL(I).LINE_ID );
1661: END IF;
1662: UPDATE wsh_delivery_details
1663: SET move_order_line_id = g_trolin_tbl(i).line_id,
1664: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,
1665: batch_id = p_batch_id,
1666: last_updated_by = l_user_id,

Line 1664: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,

1660: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATE WITH TROLIN.LINE_ID ' || G_TROLIN_TBL(I).LINE_ID );
1661: END IF;
1662: UPDATE wsh_delivery_details
1663: SET move_order_line_id = g_trolin_tbl(i).line_id,
1664: released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE,
1665: batch_id = p_batch_id,
1666: last_updated_by = l_user_id,
1667: last_update_date = l_date,
1668: last_update_login = l_login_id,

Line 1760: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.

1756: WSH_DEBUG_SV.log(l_module_name, 'g_trolin_tbl.count', g_trolin_tbl.count);
1757: WSH_DEBUG_SV.log(l_module_name, 'g_del_detail_ids.count', g_del_detail_ids.count);
1758: END IF;
1759:
1760: -- Update of wsh_delivery_details where released_status is changed, call DBI API after the update.
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail count',l_detail_tab.count);
1763: END IF;
1764: WSH_INTEGRATION.DBI_Update_Detail_Log (

Line 1868: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

1864: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1865: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1866: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1867: -- deliveryMerge
1868: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1869: l_unappended_det_tbl WSH_UTIL_CORE.Id_Tab_Type;
1870: l_default_ship_confirm_rule_id NUMBER := NULL;
1871: l_appended_del_tbl WSH_UTIL_CORE.Id_Tab_Type;
1872: l_tmp_del_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 1994: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);

1990: END LOOP;
1991: --{
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_id_tab_temp.count);
1994: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1995: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1996: END IF;
1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1998: p_delivery_detail_tbl => l_id_tab_temp,

Line 1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (

1993: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_id_tab_temp.count);
1994: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1995: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1996: END IF;
1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1998: p_delivery_detail_tbl => l_id_tab_temp,
1999: p_append_flag => p_append_flag,
2000: p_group_by_header => p_use_header_flag,
2001: p_commit => FND_API.G_FALSE,

Line 2015: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

2011: END IF;
2012: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2013: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2014: x_return_status := l_return_status;
2015: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2016: IF l_debug_on THEN
2017: WSH_DEBUG_SV.pop(l_module_name);
2018: END IF;
2019: RETURN;

Line 2161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);

2157: --{
2158: -- deliveryMerge
2159: IF l_debug_on THEN
2160: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2162: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2163: END IF;
2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2165: p_delivery_detail_tbl => l_del_details_tbl,

Line 2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

2160: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2162: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2163: END IF;
2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2165: p_delivery_detail_tbl => l_del_details_tbl,
2166: p_append_flag => p_append_flag,
2167: p_group_by_header => p_use_header_flag,
2168: p_commit => FND_API.G_FALSE,

Line 2182: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

2178: END IF;
2179: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2180: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2181: x_return_status := l_return_status;
2182: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2183: IF l_debug_on THEN
2184: WSH_DEBUG_SV.pop(l_module_name);
2185: END IF;
2186: RETURN;

Line 2271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);

2267: --{
2268: -- deliveryMerge
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2272: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2273: END IF;
2274:
2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

Line 2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

2271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2272: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2273: END IF;
2274:
2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2276: p_delivery_detail_tbl => l_del_details_tbl,
2277: p_append_flag => p_append_flag,
2278: p_group_by_header => p_use_header_flag,
2279: p_commit => FND_API.G_FALSE,

Line 2296: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

2292: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2293: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2294: --{
2295: x_return_status := l_return_status;
2296: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2297: IF l_debug_on THEN
2298: WSH_DEBUG_SV.pop(l_module_name);
2299: END IF;
2300: RETURN;

Line 3674: FROM WSH_DELIVERY_DETAILS

3670: WHERE WND.DELIVERY_ID = v_delivery_id
3671: AND nvl(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics
3672: UNION ALL
3673: SELECT DISTINCT ORGANIZATION_ID
3674: FROM WSH_DELIVERY_DETAILS
3675: WHERE SOURCE_CODE = 'OE'
3676: AND RELEASED_STATUS IN ('R', 'B', 'X') -- Added For Bug-2722194 (Non-Assigned and
3677: -- Ready to release Lines -> Base Bug-2687090)
3678: AND SOURCE_HEADER_ID = v_order_hdr_id

Line 3684: FROM WSH_DELIVERY_DETAILS

3680: AND v_del_detail_id in (0,-1,-2)
3681: AND v_delivery_id = 0
3682: UNION ALL
3683: SELECT DISTINCT ORGANIZATION_ID
3684: FROM WSH_DELIVERY_DETAILS
3685: WHERE DELIVERY_DETAIL_ID = v_del_detail_id
3686: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics
3687: AND v_delivery_id = 0
3688: UNION ALL

Line 3690: FROM WSH_DELIVERY_DETAILS WDD

3686: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics
3687: AND v_delivery_id = 0
3688: UNION ALL
3689: SELECT DISTINCT WDD.ORGANIZATION_ID
3690: FROM WSH_DELIVERY_DETAILS WDD
3691: WHERE v_delivery_id = 0
3692: AND nvl(WDD.LINE_DIRECTION , 'O') IN ('O', 'IO') -- J Inbound Logistics
3693: -- Bug 11669468: Included -2 in IN clause
3694: AND v_del_detail_id in (0, -1,-2)

Line 3700: FROM wsh_shipping_parameters wsp, wsh_delivery_details wdd

3696:
3697: --Cursor to get ship confirm rule and Packing level.
3698: CURSOR get_pack_ship_groups(v_batch_id in number) IS
3699: SELECT wsp.ship_confirm_rule_id, wsp.autopack_level
3700: FROM wsh_shipping_parameters wsp, wsh_delivery_details wdd
3701: WHERE wdd.batch_id = v_batch_id
3702: AND wsp.organization_id = wdd.organization_id
3703: GROUP BY wsp.ship_confirm_rule_id, wsp.autopack_level;
3704:

Line 3711: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,

3707: --Cursor to get delivery detail attributes for ship confirm rule and Packing level.
3708: CURSOR get_dels_in_group(v_batch_id in number, v_sc_rule_id in number, v_ap_level in number) IS
3709: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3710: wdd.ship_from_location_id
3711: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd,
3712: wsh_shipping_parameters wsp
3713: WHERE wdd.batch_id = v_batch_id
3714: AND wdd.delivery_detail_id = wda.delivery_detail_id
3715: AND wdd.organization_id = wsp.organization_id

Line 3724: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3720: --Cursor to get delivery detail attributes for batch_id.
3721: CURSOR get_dels_in_batch(v_batch_id in number) IS
3722: SELECT DISTINCT wda.delivery_id, wdd.organization_id,
3723: wdd.ship_from_location_id
3724: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3725: WHERE wdd.batch_id = v_batch_id
3726: AND wdd.delivery_detail_id = wda.delivery_detail_id
3727: AND NVL(wdd.LINE_DIRECTION , 'O') IN ('O', 'IO'); -- J Inbound Logistics
3728:

Line 3739: FROM wsh_delivery_details wdd,

3735: CURSOR c_get_backordered_details(l_batch_id NUMBER) IS
3736: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.parent_delivery_detail_id, wdd.organization_id,
3737: wdd.line_direction, wdd.gross_weight, wdd.net_weight, wdd.volume,
3738: wnd.planned_flag, wnd.batch_id
3739: FROM wsh_delivery_details wdd,
3740: wsh_delivery_assignments_v wda,
3741: wsh_new_deliveries wnd
3742: WHERE wdd.batch_id = l_batch_id
3743: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 3758: FROM wsh_delivery_details wdd,

3754: AND type = 'DOC';
3755:
3756: CURSOR c_get_unassigned_details(l_batch_id NUMBER, l_organization_id NUMBER) IS
3757: SELECT wdd.delivery_detail_id
3758: FROM wsh_delivery_details wdd,
3759: wsh_delivery_assignments_v wda
3760: WHERE wdd.batch_id = l_batch_id
3761: AND wdd.released_status in ('S','Y')
3762: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 3882: FROM wsh_delivery_details wdd,

3878: AND rownum = 1;
3879:
3880: CURSOR c_batch_unplanned_del(l_batch_id NUMBER) IS
3881: SELECT DISTINCT wda.delivery_id
3882: FROM wsh_delivery_details wdd,
3883: wsh_delivery_assignments_v wda,
3884: wsh_new_deliveries wnd,
3885: wsh_shipping_parameters wsp
3886: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 3913: FROM wsh_delivery_details wdd,

3909:
3910: -- X-dock changes to only select which have been released to warehouse from Inventory
3911: CURSOR c_wms_details (l_batch_id NUMBER, l_organization_id NUMBER, l_mo_header_id NUMBER) IS
3912: SELECT wdd.delivery_detail_id, wdd.move_order_line_id
3913: FROM wsh_delivery_details wdd,
3914: mtl_txn_request_lines mtrl,
3915: mtl_txn_request_headers mtrh
3916: WHERE wdd.batch_id = l_batch_id
3917: AND wdd.organization_id = l_organization_id

Line 3923: AND wdd.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE; -- auto pick confirm = 'N' for these lines

3919: AND wdd.move_order_line_id = mtrl.line_id
3920: AND mtrl.header_id = mtrh.header_id
3921: AND mtrh.header_id = l_mo_header_id
3922: AND mtrh.move_order_type <> 6
3923: AND wdd.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE; -- auto pick confirm = 'N' for these lines
3924:
3925:
3926: CURSOR c_dels_in_batch(l_batch_id NUMBER, p_organization_id NUMBER) IS
3927: SELECT delivery_id

Line 3993: FROM wsh_delivery_details

3989:
3990: --bug# 6689448 (replenishment project) : needs to pass replenishment requested lines to WMS
3991: CURSOR get_replenish_orgs(c_batch_id NUMBER) IS
3992: SELECT DISTINCT organization_id
3993: FROM wsh_delivery_details
3994: WHERE released_status = 'B'
3995: AND replenishment_status = 'R'
3996: AND batch_id = c_batch_id;
3997:

Line 4259: select count(*) into l_temp_num from wsh_Delivery_details where batch_id = p_batch_id;

4255:
4256: IF l_mode IS NULL THEN
4257: IF l_debug_on THEN
4258: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4259: select count(*) into l_temp_num from wsh_Delivery_details where batch_id = p_batch_id;
4260: WSH_DEBUG_SV.log(l_module_name,'DDs for batch ',l_temp_num);
4261: WSH_DEBUG_SV.log(l_module_name,'G_NUM_WORKERS ',G_NUM_WORKERS);
4262: END IF;
4263: END IF;

Line 4276: select count(*) into l_temp_num from wsh_Delivery_details where batch_id = p_batch_id;

4272: x_return_status => l_return_status);
4273:
4274: IF l_debug_on THEN
4275: WSH_DEBUG_SV.log(l_module_name,'INIT_PICK_RELEASE l_return_status',l_return_status);
4276: select count(*) into l_temp_num from wsh_Delivery_details where batch_id = p_batch_id;
4277: WSH_DEBUG_SV.log(l_module_name,'DDs for batch ',l_temp_num);
4278: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
4279: END IF;
4280:

Line 5560: UPDATE wsh_delivery_details

5556: --Batch ID set to NULL for all the children of Containers that did not get Pick Released.
5557:
5558: --bug# 6689448 (replenishment project): should not update batch_id value on the replenishment
5559: -- requested delivery detail lines.
5560: UPDATE wsh_delivery_details
5561: SET batch_id = NULL
5562: WHERE batch_id = g_batch_id
5563: AND ( (released_status in ('R','X'))
5564: OR ( released_status = 'B' and nvl(REPLENISHMENT_STATUS,'C') <> 'R') );

Line 7116: FROM WSH_DELIVERY_DETAILS

7112:
7113: --Cursor to get container attributes.
7114: CURSOR get_container(l_del_detail_id IN VARCHAR2) IS
7115: SELECT container_name, container_flag , organization_id
7116: FROM WSH_DELIVERY_DETAILS
7117: WHERE delivery_detail_id = l_del_detail_id;
7118:
7119: --Cursor to get trip status.
7120: CURSOR check_trip(c_trip_id IN NUMBER) IS

Line 7135: select released_status from wsh_delivery_details

7131: select status_code, organization_id from wsh_new_deliveries
7132: where delivery_id = c_delivery_id;
7133:
7134: CURSOR check_detail (c_delivery_detail_id IN NUMBER) IS
7135: select released_status from wsh_delivery_details
7136: where delivery_detail_id = c_delivery_detail_id;
7137:
7138: --Cursor to validate auto packing.
7139: CURSOR check_detail_for_AP (c_batch_id IN NUMBER) IS

Line 7141: from wsh_delivery_details d, wsh_shipping_parameters p

7137:
7138: --Cursor to validate auto packing.
7139: CURSOR check_detail_for_AP (c_batch_id IN NUMBER) IS
7140: select distinct p.organization_id
7141: from wsh_delivery_details d, wsh_shipping_parameters p
7142: where d.organization_id = p.organization_id
7143: and NVL(p.autopack_level,0) = 0
7144: and d.batch_id = c_batch_id;
7145:

Line 7151: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m

7147: --Cursor to validate ship confirm.
7148: CURSOR check_detail_for_SC (c_batch_id IN NUMBER) IS
7149: select distinct p.organization_id, p.ship_confirm_rule_id,
7150: p.autocreate_deliveries_flag, m.mo_pick_confirm_required
7151: from wsh_delivery_details d, wsh_shipping_parameters p, mtl_parameters m
7152: where d.organization_id = p.organization_id and
7153: m.organization_id = d.organization_id
7154: and (ship_confirm_rule_id IS NULL
7155: or NVL(p.autocreate_deliveries_flag, 'N') <> 'Y'

Line 7161: select 1 from wsh_delivery_assignments_v a, wsh_delivery_details d

7157: and d.batch_id = c_batch_id;
7158:
7159: --Cursor to check unassign delivery for an batch.
7160: CURSOR check_unassigned_dels(c_org_id IN NUMBER, c_batch_id IN NUMBER) IS
7161: select 1 from wsh_delivery_assignments_v a, wsh_delivery_details d
7162: where d.organization_id = c_org_id
7163: and d.batch_id = c_batch_id
7164: and d.delivery_detail_id = a.delivery_detail_id
7165: and a.delivery_id is null

Line 7179: wsh_delivery_details wdd

7175: --and include for planning
7176: CURSOR c_is_detail_assigned(p_detail_id IN NUMBER) IS
7177: SELECT 1
7178: FROM wsh_delivery_assignments wda,
7179: wsh_delivery_details wdd
7180: WHERE wda.delivery_detail_id = p_detail_id
7181: AND wda.delivery_detail_id = wdd.delivery_detail_id
7182: AND wda.delivery_id IS NULL
7183: AND NVL(wdd.ignore_for_planning, 'N') = 'N';

Line 7756: update wsh_delivery_details

7752:
7753: IF p_detail_ids.count > 0 THEN
7754: --Update the detail lines with batch id.
7755: FORALL i in 1..p_detail_ids.count
7756: update wsh_delivery_details
7757: set batch_id = l_batch_id
7758: where released_status in ('R', 'B', 'X')
7759: and nvl(replenishment_status,'C') = 'C' --bug# 6719369 (replenishment project)
7760: and delivery_detail_id = p_detail_ids(i);

Line 8231: FROM wsh_delivery_details wdd

8227: ,sum(wdd.requested_quantity2)
8228: INTO l_unallocated_quantity
8229: -- muom
8230: ,l_unallocated_quantity2
8231: FROM wsh_delivery_details wdd
8232: WHERE wdd.released_status = 'S'
8233: AND wdd.source_code = 'OE'
8234: AND wdd.source_line_id = p_demand_source_line_id
8235: AND NOT EXISTS

Line 8404: l_requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

8400:
8401: l_demand_source_header_id NUMBER;
8402: l_demand_source_line_id NUMBER;
8403: l_requested_quantity NUMBER;
8404: l_requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
8405: l_src_requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
8406: l_src_requested_quantity NUMBER;
8407: l_inv_item_id NUMBER;
8408: l_requested_quantity2 NUMBER;

Line 8405: l_src_requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;

8401: l_demand_source_header_id NUMBER;
8402: l_demand_source_line_id NUMBER;
8403: l_requested_quantity NUMBER;
8404: l_requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
8405: l_src_requested_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
8406: l_src_requested_quantity NUMBER;
8407: l_inv_item_id NUMBER;
8408: l_requested_quantity2 NUMBER;
8409: l_result NUMBER;