DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on WMS_GLOBALS

Line 3722: AND ( l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE

3718: AND mmtt.cartonization_id IS NULL -- only bulk non_cartonized lines
3719: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
3720: OR mmtt.serial_allocated_flag IS NULL )
3721: AND NVL(mmtt.fulfillment_base,'P') = 'P'
3722: AND ( l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
3723: -- If bulk picking is not disabled and not pick entire wave only the honor sub/item is left,
3724: -- so no need to check l_bulk_pick_control, only need to check the sub/item flag
3725: OR EXISTS( SELECT 1 -- sub is bulk picking enabled
3726: FROM mtl_secondary_inventories msi

Line 3799: AND ( l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE

3795: AND mmtt.move_order_header_id = p_move_order_header_id
3796: AND ( mmtt.serial_allocated_flag = 'N' -- do not bulk serial allocated lines
3797: or mmtt.serial_allocated_flag IS NULL )
3798: AND NVL(mmtt.fulfillment_base,'P') = 'P'
3799: AND ( l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_ENTIRE_WAVE
3800: -- if bulk picking is not disabled and not pick entire wave only the honor sub/item is left,
3801: -- so no need to check l_bulk_pick_control, only need to check the sub/item flag
3802: OR EXISTS( SELECT 1 -- sub is bulk picking enabled
3803: FROM mtl_secondary_inventories msi

Line 3863: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;

3859: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
3860:
3861: -- If bulk picking is not enabled then RETURN
3862: IF l_bulk_pick_control IS NULL THEN
3863: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;
3864: ELSE
3865: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED) THEN
3866: IF (g_debug = 1) THEN
3867: print_debug( 'Bulk picking is not enabled', l_api_name );

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

3861: -- If bulk picking is not enabled then RETURN
3862: IF l_bulk_pick_control IS NULL THEN
3863: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;
3864: ELSE
3865: IF (l_bulk_pick_control = WMS_GLOBALS.BULK_PICK_DISABLED) THEN
3866: IF (g_debug = 1) THEN
3867: print_debug( 'Bulk picking is not enabled', l_api_name );
3868: END IF;
3869: RETURN;

Line 3885: WHERE pick_method=WMS_GLOBALS.PICK_METHOD_BULK

3881:
3882: SELECT DELIVERY_FLAG
3883: INTO l_delivery_flag
3884: FROM WSH_PICK_GROUPING_RULES
3885: WHERE pick_method=WMS_GLOBALS.PICK_METHOD_BULK
3886: AND user_defined_flag = 'N' -- bulk picking default rule
3887: AND ROWNUM < 2; -- In case of pseudo translation, multiple records are inserted for the seeded rule
3888:
3889: IF g_debug = 1 THEN