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 117: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;

113: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_CARTNZN_PUB';
114: g_current_release_level CONSTANT NUMBER := WMS_CONTROL.G_CURRENT_RELEASE_LEVEL;
115: g_j_release_level CONSTANT NUMBER := INV_RELEASE.G_J_RELEASE_LEVEL;
116: g_k_release_level CONSTANT NUMBER := INV_RELEASE.G_K_RELEASE_LEVEL; -- ER : 6682436
117: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;
118: g_cartonize_pick_slip VARCHAR2(1) := 'N';
119:
120: -- Sets the table on which we want to perform the operations insert,
121: -- delete, update etc

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

559: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
560: AND mmtt.move_order_header_id = moh.header_id
561: AND spg.pick_grouping_rule_id = moh.grouping_rule_id
562: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
563: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
564: -- following is the logic for the input parameters
565: AND (mmtt.serial_allocated_flag <> 'Y' OR
566: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those childs Bug3628747
567: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)

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

591: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
592: AND (mmtt.serial_allocated_flag <> 'Y' OR
593: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
594: -- Bug3628747
595: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
596: -- following is the logic for the input parameters
597: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
598: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
599: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and

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

637: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
638: AND (mmtt.serial_allocated_flag <> 'Y' OR
639: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
640: --Bug3628747
641: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
642: -- following is the logic for the input parameters
643: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
644: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
645: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and

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

673: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
674: AND (mmtt.serial_allocated_flag <> 'Y' OR
675: mmtt.serial_allocated_flag IS NULL ) -- should not bulk those lines
676: --Bug3628747
677: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
678: -- following is the logic for the input parameters
679: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
680: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
681: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and

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

745: from mtl_txn_request_headers moh,
746: wsh_pick_grouping_rules spg
747: where spg.pick_grouping_rule_id = moh.grouping_rule_id
748: AND spg.pick_method <>WMS_GLOBALS.PICK_METHOD_ORDER -- not order pciking
749: AND moh.move_order_type = INV_GLOBALS.g_move_order_pick_wave -- pick wave move order only
750: AND moh.request_number between nvl(p_input_for_bulk.start_mo_request_number,moh.request_number) and
751: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
752: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
753: nvl(p_input_for_bulk.end_release_date,moh.creation_date);

Line 3558: AND move_order_type = inv_globals.G_MOVE_ORDER_PICK_WAVE);

3554: WHERE batch_id =
3555: (SELECT request_number
3556: FROM mtl_txn_request_headers
3557: WHERE header_id = p_move_order_header_id
3558: AND move_order_type = inv_globals.G_MOVE_ORDER_PICK_WAVE);
3559:
3560: IF l_auto_pick_confirm_flag = 'Y' THEN
3561: IF (g_trace_on = 1) THEN log_event('Auto pick confirm is ON for this batch'); END IF;
3562: END IF;

Line 3647: l_move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;

3643:
3644: IF (g_trace_on = 1) THEN log_event(' move order header id '||p_move_order_header_id); END IF;
3645: IF (p_move_order_header_id = -1 ) THEN -- this is called from concurrent program
3646: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING '); end if;
3647: l_move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
3648: if (g_trace_on = 1) then log_event('This is called from concurrent program'); end if;
3649: ELSE
3650: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING '); end if;
3651: SELECT move_order_type