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_PICKING_PKG dependencies on INV_GLOBALS

Line 1145: (inv_globals.g_move_order_replenishment,

1141: END IF;
1142:
1143: --If the MO is of type replenishment / requisition
1144: IF (l_move_order_type IN
1145: (inv_globals.g_move_order_replenishment,
1146: inv_globals.g_move_order_requisition)
1147: ) THEN
1148:
1149: SELECT OVPK_TRANSFER_ORDERS_ENABLED

Line 1146: inv_globals.g_move_order_requisition)

1142:
1143: --If the MO is of type replenishment / requisition
1144: IF (l_move_order_type IN
1145: (inv_globals.g_move_order_replenishment,
1146: inv_globals.g_move_order_requisition)
1147: ) THEN
1148:
1149: SELECT OVPK_TRANSFER_ORDERS_ENABLED
1150: INTO l_temp

Line 1160: ELSIF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN

1156: mydebug('OVPK: l_temp for replenishment/requisition MO = '||l_temp, l_api_name);
1157: mydebug('OVPK: l_check_overpick_passed for replenishment/requisition MO = '||l_check_overpick_passed, l_api_name);
1158: END IF;
1159:
1160: ELSIF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
1161:
1162: SELECT wip_overpick_enabled
1163: INTO l_temp
1164: FROM mtl_parameters

Line 1173: ELSIF (l_move_order_type = inv_globals.g_move_order_pick_wave) THEN

1169: mydebug('OVPK: l_temp for WIP MO = '||l_temp, l_api_name);
1170: mydebug('OVPK: l_check_overpick_passed for WIP MO = '||l_check_overpick_passed, l_api_name);
1171: END IF;
1172:
1173: ELSIF (l_move_order_type = inv_globals.g_move_order_pick_wave) THEN
1174:
1175: l_check_overpick_passed := NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N');
1176:
1177: IF l_debug = 1 THEN

Line 1621: , inv_globals.g_move_order_mfg_pick, 'MFG'

1617: l_message VARCHAR2(400);
1618:
1619: CURSOR c_det_pick_type(p_org_id IN NUMBER, p_lpn_id IN NUMBER) IS
1620: SELECT DECODE (mtrh.move_order_type
1621: , inv_globals.g_move_order_mfg_pick, 'MFG'
1622: , 'OTHERS')
1623: FROM mtl_material_transactions_temp mmtt
1624: , mtl_txn_request_lines mtrl
1625: , mtl_txn_request_headers mtrh

Line 1688: IF ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

1684: LOOP
1685: FETCH c_get_mfg_drop_details INTO mfg_drop_rec;
1686: EXIT WHEN c_get_mfg_drop_details%NOTFOUND;
1687:
1688: IF ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1689: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1690: AND(( mfg_drop_rec.txn_source_id <> mfg_orig_drop_rec.txn_source_id)
1691: OR ( mfg_drop_rec.txn_source_line_id <> mfg_orig_drop_rec.txn_source_line_id)
1692: OR ( mfg_drop_rec.reference_id <> mfg_orig_drop_rec.reference_id)))

Line 1689: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

1685: FETCH c_get_mfg_drop_details INTO mfg_drop_rec;
1686: EXIT WHEN c_get_mfg_drop_details%NOTFOUND;
1687:
1688: IF ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1689: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1690: AND(( mfg_drop_rec.txn_source_id <> mfg_orig_drop_rec.txn_source_id)
1691: OR ( mfg_drop_rec.txn_source_line_id <> mfg_orig_drop_rec.txn_source_line_id)
1692: OR ( mfg_drop_rec.reference_id <> mfg_orig_drop_rec.reference_id)))
1693: OR ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR

Line 1693: OR ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR

1689: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1690: AND(( mfg_drop_rec.txn_source_id <> mfg_orig_drop_rec.txn_source_id)
1691: OR ( mfg_drop_rec.txn_source_line_id <> mfg_orig_drop_rec.txn_source_line_id)
1692: OR ( mfg_drop_rec.reference_id <> mfg_orig_drop_rec.reference_id)))
1693: OR ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR
1694: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR
1695: AND (( mfg_drop_rec.transfer_subinventory <> mfg_orig_drop_rec.transfer_subinventory)
1696: OR ( mfg_drop_rec.transfer_to_location <> mfg_orig_drop_rec.transfer_to_location)))
1697: OR ( mfg_drop_rec.transaction_type_id <> mfg_orig_drop_rec.transaction_type_id)

Line 1694: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR

1690: AND(( mfg_drop_rec.txn_source_id <> mfg_orig_drop_rec.txn_source_id)
1691: OR ( mfg_drop_rec.txn_source_line_id <> mfg_orig_drop_rec.txn_source_line_id)
1692: OR ( mfg_drop_rec.reference_id <> mfg_orig_drop_rec.reference_id)))
1693: OR ( mfg_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR
1694: AND mfg_orig_drop_rec.transaction_type_id = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR
1695: AND (( mfg_drop_rec.transfer_subinventory <> mfg_orig_drop_rec.transfer_subinventory)
1696: OR ( mfg_drop_rec.transfer_to_location <> mfg_orig_drop_rec.transfer_to_location)))
1697: OR ( mfg_drop_rec.transaction_type_id <> mfg_orig_drop_rec.transaction_type_id)
1698: THEN

Line 1755: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory

1751: , wms_dispatched_tasks wdt
1752: , mtl_system_items_vl msik /* Bug 5581528 */
1753: WHERE mmtt.organization_id = p_organization_id
1754: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1755: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
1756: AND mmtt.transaction_action_id = inv_globals.g_action_subxfr
1757: AND msi.organization_id = mmtt.organization_id
1758: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
1759: AND mmtt.organization_id = mil.organization_id

Line 1756: AND mmtt.transaction_action_id = inv_globals.g_action_subxfr

1752: , mtl_system_items_vl msik /* Bug 5581528 */
1753: WHERE mmtt.organization_id = p_organization_id
1754: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1755: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
1756: AND mmtt.transaction_action_id = inv_globals.g_action_subxfr
1757: AND msi.organization_id = mmtt.organization_id
1758: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
1759: AND mmtt.organization_id = mil.organization_id
1760: AND mmtt.transfer_subinventory = mil.subinventory_code

Line 1804: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_wip

1800: , wms_dispatched_tasks wdt
1801: , mtl_system_items_vl msik /* Bug 5581528 */
1802: WHERE mmtt.organization_id = p_organization_id
1803: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1804: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_wip
1805: AND mmtt.transaction_action_id = inv_globals.g_action_issue
1806: AND mtrl.line_id = mmtt.move_order_line_id
1807: AND wdt.organization_id = mmtt.organization_id
1808: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 1805: AND mmtt.transaction_action_id = inv_globals.g_action_issue

1801: , mtl_system_items_vl msik /* Bug 5581528 */
1802: WHERE mmtt.organization_id = p_organization_id
1803: AND mmtt.transfer_lpn_id = p_transfer_lpn_id
1804: AND mmtt.transaction_source_type_id = inv_globals.g_sourcetype_wip
1805: AND mmtt.transaction_action_id = inv_globals.g_action_issue
1806: AND mtrl.line_id = mmtt.move_order_line_id
1807: AND wdt.organization_id = mmtt.organization_id
1808: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1809: AND wdt.status IN (3, 4)

Line 1899: l_temp_lot_num_tbl inv_globals.varchar_tbl_type;

1895: , x_display_serials OUT NOCOPY VARCHAR2
1896: , p_txn_temp_id_list IN VARCHAR2
1897: ) IS
1898: l_api_name VARCHAR2(30) := 'GET_LOT_NUMBER_INFO';
1899: l_temp_lot_num_tbl inv_globals.varchar_tbl_type;
1900: l_temp_lot_qty_tbl inv_globals.number_tbl_type;
1901: l_lot_num_tbl inv_globals.varchar_tbl_type;
1902: l_lot_qty_tbl inv_globals.number_tbl_type;
1903: l_start NUMBER;

Line 1900: l_temp_lot_qty_tbl inv_globals.number_tbl_type;

1896: , p_txn_temp_id_list IN VARCHAR2
1897: ) IS
1898: l_api_name VARCHAR2(30) := 'GET_LOT_NUMBER_INFO';
1899: l_temp_lot_num_tbl inv_globals.varchar_tbl_type;
1900: l_temp_lot_qty_tbl inv_globals.number_tbl_type;
1901: l_lot_num_tbl inv_globals.varchar_tbl_type;
1902: l_lot_qty_tbl inv_globals.number_tbl_type;
1903: l_start NUMBER;
1904: l_end NUMBER;

Line 1901: l_lot_num_tbl inv_globals.varchar_tbl_type;

1897: ) IS
1898: l_api_name VARCHAR2(30) := 'GET_LOT_NUMBER_INFO';
1899: l_temp_lot_num_tbl inv_globals.varchar_tbl_type;
1900: l_temp_lot_qty_tbl inv_globals.number_tbl_type;
1901: l_lot_num_tbl inv_globals.varchar_tbl_type;
1902: l_lot_qty_tbl inv_globals.number_tbl_type;
1903: l_start NUMBER;
1904: l_end NUMBER;
1905: l_txn_temp_id NUMBER;

Line 1902: l_lot_qty_tbl inv_globals.number_tbl_type;

1898: l_api_name VARCHAR2(30) := 'GET_LOT_NUMBER_INFO';
1899: l_temp_lot_num_tbl inv_globals.varchar_tbl_type;
1900: l_temp_lot_qty_tbl inv_globals.number_tbl_type;
1901: l_lot_num_tbl inv_globals.varchar_tbl_type;
1902: l_lot_qty_tbl inv_globals.number_tbl_type;
1903: l_start NUMBER;
1904: l_end NUMBER;
1905: l_txn_temp_id NUMBER;
1906: l_found BOOLEAN;

Line 2025: l_temp_serial_list inv_globals.varchar_tbl_type;

2021: , p_txn_temp_id_list IN VARCHAR2
2022: , p_lot_number IN VARCHAR2
2023: ) IS
2024: l_api_name VARCHAR2(30) := 'GET_SERIAL_NUMBERS';
2025: l_temp_serial_list inv_globals.varchar_tbl_type;
2026: l_start NUMBER;
2027: l_end NUMBER;
2028: l_txn_temp_id NUMBER;
2029: