[Home] [Help]
265: --All lines in SS are imported
266:
267: SELECT count(*)
268: INTO l_ss_count
269: FROM wsh_delivery_details
270: WHERE ship_set_id = p_ship_set_id
271: AND source_header_id = p_order_header_id
272: AND source_code = p_source_code
273: AND released_status IN ('R','N','B')
344: IF (l_status = FALSE) THEN
345: --Check for SMC with top_model_line_id
346: SELECT count(*)
347: INTO l_smc_count
348: FROM wsh_delivery_details
349: WHERE top_model_line_id = p_top_model_line_id
350: AND source_header_id = p_order_header_id
351: AND ship_model_complete_flag = 'Y'
352: AND source_code = p_source_code
534: SRC_REQUESTED_QUANTITY,
535: --muom
536: SRC_REQUESTED_QUANTITY2,
537: INVENTORY_ITEM_ID
538: FROM WSH_DELIVERY_DETAILS
539: WHERE DELIVERY_DETAIL_ID = v_del_detail_id
540: AND RELEASED_STATUS IN ('R','B','X')
541: AND MOVE_ORDER_LINE_ID IS NULL
542: FOR UPDATE NOWAIT;
577: -- Standalone project Changes end
578: wda.delivery_id,
579: wdd.last_update_date,
580: wdd.client_id -- LSP PROJECT:
581: FROM wsh_delivery_details wdd,
582: wsh_delivery_assignments_v wda
583: WHERE wdd.delivery_detail_id = v_del_detail_id
584: AND wda.delivery_detail_id = wdd.delivery_detail_id
585: AND wdd.date_scheduled IS NOT NULL
917: -- cursor to get lines within a container
918: CURSOR get_inner_items (v_del_detail_id NUMBER) IS
919: SELECT WDD.DELIVERY_DETAIL_ID
920: FROM wsh_delivery_assignments_v WDA,
921: WSH_DELIVERY_DETAILS WDD
922: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
923: AND WDD.CONTAINER_FLAG = 'N'
924: AND WDA.DELIVERY_ASSIGNMENT_ID IN
925: (SELECT WDA1.DELIVERY_ASSIGNMENT_ID
934: -- Added condition AND CONTAINER_FLAG = 'Y' to fetch containers only.
935:
936: CURSOR get_batch_details (v_batch_id NUMBER, v_del_det NUMBER) IS
937: SELECT DELIVERY_DETAIL_ID -- If Launch PR from STF for del details, we stamp batch id
938: FROM WSH_DELIVERY_DETAILS -- on details. wsh_picking_batches has the detail as -1,
939: WHERE BATCH_ID = v_batch_id -- batch can have several delivery details
940: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
941: AND CONTAINER_FLAG='Y'
942: UNION
940: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
941: AND CONTAINER_FLAG='Y'
942: UNION
943: SELECT DELIVERY_DETAIL_ID -- If use PR form then we do not stamp batch id in wdd,
944: FROM WSH_DELIVERY_DETAILS -- wsh_picking_batches has the delivery detail stamped
945: WHERE DELIVERY_DETAIL_ID = v_del_det -- we can specify only one detail per batch
946: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO')
947: AND BATCH_ID IS NULL
948: AND CONTAINER_FLAG='Y';
1278: FETCH get_inner_items BULK COLLECT INTO g_det_lst;
1279: CLOSE get_inner_items;
1280: IF (g_det_lst.COUNT > 0) THEN
1281: FORALL i IN g_det_lst.FIRST..g_det_lst.LAST
1282: UPDATE WSH_DELIVERY_DETAILS
1283: SET BATCH_ID = p_batch_id
1284: WHERE DELIVERY_DETAIL_ID = g_det_lst(i);
1285: IF (SQL%ROWCOUNT > 0) THEN
1286: --{
1300: -- provided dd is not a container dd then
1301: -- update wdd for that dd_ID and change g_del_detail_id to -2.
1302: -- (Pick release is submitted from Release SO form/Public API)
1303: IF ( l_temp_line = -1 AND g_del_detail_id > 0 ) THEN
1304: UPDATE WSH_DELIVERY_DETAILS
1305: SET BATCH_ID = p_batch_id
1306: WHERE DELIVERY_DETAIL_ID = g_del_detail_id;
1307: IF (SQL%ROWCOUNT > 0) THEN
1308: g_del_detail_id := -2;
1929: ( ( p_mode = 'WORKER' and p_inv_item_id is not null ) or
1930: ( nvl(p_mode, 'SUMMARY') = 'SUMMARY' and g_inventory_item_id <> 0 ) ) )
1931: THEN
1932: Process_Buffer(p_print_flag,
1933: 'u', 'SELECT /*+ index(wdd WSH_DELIVERY_DETAILS_N9) */ ');
1934: ELSE
1935: Process_Buffer(p_print_flag,
1936: 'u', 'SELECT ');
1937: END IF;
2057:
2058: -- 20. Common Tables to be selected irrespective of P_MODE parameter
2059: --{
2060: Process_Buffer(p_print_flag,
2061: 'u', ' FROM WSH_DELIVERY_DETAILS WDD,');
2062: Process_Buffer(p_print_flag,
2063: 'u', ' wsh_delivery_assignments_v WDA,');
2064:
2065: -- Bug 2040002: Need WSH_NEW_DELIVERIES under following conditions only
2176: IF (g_del_detail_id = -1 OR g_del_detail_id = -2 ) THEN
2177:
2178: Process_Buffer(p_print_flag,'c',' AND WDA.DELIVERY_DETAIL_ID IN '
2179: ||'( SELECT DELIVERY_DETAIL_ID FROM '
2180: ||' WSH_DELIVERY_DETAILS WHERE BATCH_ID = :X_batch_id '
2181: ||' AND CONTAINER_FLAG = ''N'')'); -- ,p_batch_id);
2182:
2183: ELSIF (g_del_detail_id <> 0) THEN
2184: Process_Buffer(p_print_flag,'c', ' AND WDA.DELIVERY_DETAIL_ID = :X_del_detail_id'); -- ,g_del_detail_id);
3893: -- HW OPMCONV - Added qty2
3894: l_requested_quantity2 := l_requested_quantity2 - l_result2;
3895:
3896: IF l_debug_on THEN
3897: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
3898: END IF;
3899:
3900: -- HW OPMCONV - Added l_requested_quantity2 and re-arranged parameters
3901:
3898: END IF;
3899:
3900: -- HW OPMCONV - Added l_requested_quantity2 and re-arranged parameters
3901:
3902: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
3903: p_from_detail_id => v_delivery_detail_id,
3904: p_req_quantity => l_requested_quantity,
3905: x_new_detail_id => l_new_delivery_detail_id,
3906: p_req_quantity2 => l_requested_quantity2,