DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WMS_GLOBALS

Line 11717: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE

11713: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11714: AND mmtt.cartonization_id is null -- only bulk non_cartoned lines
11715: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
11716: or mmtt.serial_allocated_flag is null)
11717: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
11718: -- 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
11719: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
11720: FROM mtl_secondary_inventories msi
11721: WHERE msi.secondary_inventory_name = mmtt.subinventory_code

Line 11789: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE

11785: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11786: AND mmtt.cartonization_id is null -- only bulk non_cartoned lines
11787: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
11788: or mmtt.serial_allocated_flag is null)
11789: AND(l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
11790: -- 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
11791: OR EXISTS(SELECT 1 -- sub is bulk picking enabled
11792: FROM mtl_secondary_inventories msi
11793: WHERE msi.secondary_inventory_name = mmtt.subinventory_code

Line 11980: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK

11976:
11977: Select DELIVERY_FLAG
11978: Into l_delivery_flag
11979: From WSH_PICK_GROUPING_RULES
11980: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
11981: and user_defined_flag = 'N' -- bulk picking default rule
11982: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
11983:
11984: -- check to see if the picking methodology is bulk picking disabled (including order picking)---

Line 11995: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;

11991: g_delivery_flag := l_delivery_flag;
11992: g_bulk_pick_control := l_bulk_pick_control;
11993:
11994: IF l_bulk_pick_control is null THEN
11995: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;
11996: ELSE
11997: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED ) THEN
11998: IF (l_debug = 1) THEN
11999: print_debug('Consolidating Tasks are not bulk picking enabled',4);

Line 11997: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED ) THEN

11993:
11994: IF l_bulk_pick_control is null THEN
11995: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;
11996: ELSE
11997: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED ) THEN
11998: IF (l_debug = 1) THEN
11999: print_debug('Consolidating Tasks are not bulk picking enabled',4);
12000: END IF;
12001: return;

Line 12018: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK

12014: ELSE -- calling from the concurrent program, always query
12015: Select DELIVERY_FLAG
12016: Into l_delivery_flag
12017: From WSH_PICK_GROUPING_RULES
12018: Where pick_method=WMS_GLOBALS.PICK_METHOD_BULK
12019: and user_defined_flag = 'N' -- default rule
12020: and rownum <2; -- in case of psudo translation, multiple records are inserted for the seeded rule
12021: END IF;
12022: