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

Line 724: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)

720: l_cross_ref varchar2(204);
721: BEGIN
722:
723: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
724: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
725: THEN
726: OPEN x_items FOR
727: SELECT msik.concatenated_segments concatenated_segments
728: , msik.inventory_item_id

Line 853: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83

849: AND is_allowed = 2))
850: ORDER BY concatenated_segments;
851:
852: ELSE
853: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
854: THEN
855: OPEN x_items FOR
856: SELECT msik.concatenated_segments concatenated_segments
857: , msik.inventory_item_id

Line 982: IF p_transaction_type_id = inv_globals.g_type_inv_lot_translate THEN

978: AND is_allowed = 2))
979: ORDER BY concatenated_segments;
980:
981: ELSE
982: IF p_transaction_type_id = inv_globals.g_type_inv_lot_translate THEN
983: IF (p_lot_number IS NOT NULL) THEN
984: OPEN x_items FOR
985: SELECT msik.concatenated_segments concatenated_segments
986: , msik.inventory_item_id

Line 1357: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)

1353: BEGIN
1354: x_return_status := fnd_api.g_ret_sts_success;
1355: x_msg_data := '';
1356:
1357: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1358: THEN
1359: SELECT NVL(msik.revision_qty_control_code, 1)
1360: , NVL(msik.serial_number_control_code, 1)
1361: , NVL(msik.restrict_subinventories_code, 2)

Line 1386: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83

1382: WHERE msik.lot_split_enabled = 'Y'
1383: AND msik.organization_id = p_organization_id
1384: AND msik.inventory_item_id = p_inventory_item_id;
1385: ELSE
1386: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
1387: THEN
1388: SELECT NVL(msik.revision_qty_control_code, 1)
1389: , NVL(msik.serial_number_control_code, 1)
1390: , NVL(msik.restrict_subinventories_code, 2)

Line 1414: ELSIF p_transaction_type_id = inv_globals.g_type_inv_lot_translate -- Lot Translate 84 Added bug4096035

1410: FROM mtl_system_items_vl msik /* Bug 5581528 */
1411: WHERE msik.lot_merge_enabled = 'Y'
1412: AND msik.organization_id = p_organization_id
1413: AND msik.inventory_item_id = p_inventory_item_id;
1414: ELSIF p_transaction_type_id = inv_globals.g_type_inv_lot_translate -- Lot Translate 84 Added bug4096035
1415: THEN
1416: SELECT NVL(msik.revision_qty_control_code, 1)
1417: , NVL(msik.serial_number_control_code, 1)
1418: , NVL(msik.restrict_subinventories_code, 2)

Line 1519: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)

1515: BEGIN
1516: x_return_status := fnd_api.g_ret_sts_success;
1517: x_msg_data := '';
1518:
1519: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1520: THEN
1521: SELECT NVL(msik.revision_qty_control_code, 1)
1522: , NVL(msik.serial_number_control_code, 1)
1523: , NVL(msik.restrict_subinventories_code, 2)

Line 1582: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83

1578: WHERE msik.lot_split_enabled = 'Y'
1579: AND msik.organization_id = p_organization_id
1580: AND msik.inventory_item_id = p_inventory_item_id;
1581: ELSE
1582: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
1583: THEN
1584: SELECT NVL(msik.revision_qty_control_code, 1)
1585: , NVL(msik.serial_number_control_code, 1)
1586: , NVL(msik.restrict_subinventories_code, 2)

Line 1644: ELSIF p_transaction_type_id = inv_globals.g_type_inv_lot_translate -- Lot Translate 84 Added bug4096035

1640: FROM mtl_system_items_vl msik /* Bug 5581528 */
1641: WHERE msik.lot_merge_enabled = 'Y'
1642: AND msik.organization_id = p_organization_id
1643: AND msik.inventory_item_id = p_inventory_item_id;
1644: ELSIF p_transaction_type_id = inv_globals.g_type_inv_lot_translate -- Lot Translate 84 Added bug4096035
1645: THEN
1646: SELECT NVL(msik.revision_qty_control_code, 1)
1647: , NVL(msik.serial_number_control_code, 1)
1648: , NVL(msik.restrict_subinventories_code, 2)