[Home] [Help]
12151: AND mmtt.cartonization_id is null -- only bulk non_cartoned lines
12152: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
12153: or mmtt.serial_allocated_flag is null)
12154: AND NVL(mmtt.fulfillment_base,'P') = 'P'
12155: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
12156: -- if bulk picking is not disabled and not pick entire wave only the honor sub/item is left, so no need to check l_bulk_pick_control, only need to check the sub/item flag
12157: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
12158: FROM mtl_secondary_inventories msi
12159: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
12232: AND mmtt.cartonization_id is null -- only bulk non_cartoned lines
12233: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
12234: or mmtt.serial_allocated_flag is null)
12235: AND NVL(mmtt.fulfillment_base,'P') = 'P'
12236: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
12237: -- if bulk picking is not disabled and not pick entire wave only the honor sub/item is left, so no need to check l_bulk_pick_control, only need to check the sub/item flag
12238: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
12239: FROM mtl_secondary_inventories msi
12240: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
12437: IF p_move_order_header_id = g_move_order_header_id THEN
12438: l_delivery_flag := g_delivery_flag;
12439: l_bulk_pick_control := g_bulk_pick_control;
12440: --Modified for bug#9381968
12441: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED ) THEN
12442: IF (l_debug = 1) THEN
12443: print_debug('Consolidating Tasks are not bulk picking enabled',4);
12444: END IF;
12445: return;
12452:
12453: Select DELIVERY_FLAG
12454: Into l_delivery_flag
12455: From WSH_PICK_GROUPING_RULES
12456: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
12457: and user_defined_flag = 'N' -- bulk picking default rule
12458: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
12459:
12460: -- check to see if the picking methodology is bulk picking disabled (including order picking)---
12467: g_delivery_flag := l_delivery_flag;
12468: g_bulk_pick_control := l_bulk_pick_control;
12469:
12470: IF l_bulk_pick_control is null THEN
12471: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;
12472: ELSE
12473: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED ) THEN
12474: IF (l_debug = 1) THEN
12475: print_debug('Consolidating Tasks are not bulk picking enabled',4);
12469:
12470: IF l_bulk_pick_control is null THEN
12471: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;
12472: ELSE
12473: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED ) THEN
12474: IF (l_debug = 1) THEN
12475: print_debug('Consolidating Tasks are not bulk picking enabled',4);
12476: END IF;
12477: return;
12490: ELSE -- calling from the concurrent program, always query
12491: Select DELIVERY_FLAG
12492: Into l_delivery_flag
12493: From WSH_PICK_GROUPING_RULES
12494: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
12495: and user_defined_flag = 'N' -- default rule
12496: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
12497: END IF;
12498:
12500: print_debug('Delivery flag for bulk picking is '||l_delivery_flag,4);
12501: print_debug('Consolidating Tasks, bulk task control '||l_bulk_pick_control,4);
12502: END IF;
12503: /* Bug No.9549752 - Added the following condition (p_move_order_header_id = -1 and g_bulk_pick_control is NULL) */
12504: IF (g_bulk_pick_control <> WMS_GLOBALS.BULK_PICK_DISABLED) or
12505: (p_move_order_header_id = -1 and g_bulk_pick_control is NULL ) THEN -- Bug 7005328
12506:
12507: -- open the non serial controlled items cursor -----------------------
12508: if p_move_order_header_id <> -1 then