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.WMS_CARTNZN_PUB dependencies on INV_GLOBALS

Line 64: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;

60: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_CARTNZN_PUB';
61: g_current_release_level CONSTANT NUMBER := WMS_CONTROL.G_CURRENT_RELEASE_LEVEL;
62: g_j_release_level CONSTANT NUMBER := INV_RELEASE.G_J_RELEASE_LEVEL;
63: g_k_release_level CONSTANT NUMBER := INV_RELEASE.G_K_RELEASE_LEVEL; -- ER : 6682436
64: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;
65:
66:
67: CURR_HEADER_ID_FOR_MIXED NUMBER;
68: PREV_HEADER_ID_FOR_MIXED NUMBER;

Line 465: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

461: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
462: AND mmtt.move_order_header_id = moh.header_id
463: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
464: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
465: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
466: -- following is the logic for the input parameters
467: AND (mmtt.serial_allocated_flag <> 'Y' OR
468: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those childs Bug3628747
469: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)

Line 498: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

494: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
495: AND (mmtt.serial_allocated_flag <> 'Y' OR
496: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
497: -- Bug3628747
498: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
499: -- following is the logic for the input parameters
500: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
501: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
502: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and

Line 545: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

541: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
542: AND (mmtt.serial_allocated_flag <> 'Y' OR
543: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
544: --Bug3628747
545: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
546: -- following is the logic for the input parameters
547: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
548: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
549: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and

Line 582: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

578: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
579: AND (mmtt.serial_allocated_flag <> 'Y' OR
580: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
581: --Bug3628747
582: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
583: -- following is the logic for the input parameters
584: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
585: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
586: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and

Line 654: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only

650: from mtl_txn_request_headers moh,
651: wsh_pick_grouping_rules spg
652: where spg.pick_grouping_rule_id = moh.grouping_rule_id
653: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
654: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
655: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and
656: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
657: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
658: nvl(p_input_for_bulk.end_release_date,moh.creation_date);

Line 3540: AND move_order_type = inv_globals.G_MOVE_ORDER_PICK_WAVE);

3536: WHERE batch_id =
3537: (SELECT request_number
3538: FROM mtl_txn_request_headers
3539: WHERE header_id = p_move_order_header_id
3540: AND move_order_type = inv_globals.G_MOVE_ORDER_PICK_WAVE);
3541:
3542: IF l_auto_pick_confirm_flag = 'Y' THEN
3543: IF (g_trace_on = 1) THEN log_event('Auto pick confirm is ON for this batch'); END IF;
3544: END IF;

Line 3629: l_move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;

3625:
3626: IF (g_trace_on = 1) THEN log_event(' move order header id '||p_move_order_header_id); END IF;
3627: IF (p_move_order_header_id = -1 ) THEN -- this is called from concurrent program
3628: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING '); end if;
3629: l_move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
3630: if (g_trace_on = 1) then log_event('This is called from concurrent program'); end if;
3631: ELSE
3632: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING '); end if;
3633: SELECT move_order_type