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 831: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)

827:
828: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
829: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
830:
831: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
832: THEN
833: OPEN x_items FOR
834: SELECT msik.concatenated_segments concatenated_segments
835: , msik.inventory_item_id

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

958: AND is_allowed = 2))
959: ORDER BY concatenated_segments;
960:
961: ELSE
962: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
963: THEN
964: OPEN x_items FOR
965: SELECT msik.concatenated_segments concatenated_segments
966: , msik.inventory_item_id

Line 1093: IF p_transaction_type_id = inv_globals.g_type_inv_lot_translate THEN

1089: AND is_allowed = 2))
1090: ORDER BY concatenated_segments;
1091:
1092: ELSE
1093: IF p_transaction_type_id = inv_globals.g_type_inv_lot_translate THEN
1094: IF (p_lot_number IS NOT NULL) THEN
1095: OPEN x_items FOR
1096: SELECT msik.concatenated_segments concatenated_segments
1097: , msik.inventory_item_id

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

1470: BEGIN
1471: x_return_status := fnd_api.g_ret_sts_success;
1472: x_msg_data := '';
1473:
1474: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1475: THEN
1476: SELECT NVL(msik.revision_qty_control_code, 1)
1477: , NVL(msik.serial_number_control_code, 1)
1478: , NVL(msik.restrict_subinventories_code, 2)

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

1499: WHERE msik.lot_split_enabled = 'Y'
1500: AND msik.organization_id = p_organization_id
1501: AND msik.inventory_item_id = p_inventory_item_id;
1502: ELSE
1503: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
1504: THEN
1505: SELECT NVL(msik.revision_qty_control_code, 1)
1506: , NVL(msik.serial_number_control_code, 1)
1507: , NVL(msik.restrict_subinventories_code, 2)

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

1527: FROM mtl_system_items_vl msik /* Bug 5581528 */
1528: WHERE msik.lot_merge_enabled = 'Y'
1529: AND msik.organization_id = p_organization_id
1530: AND msik.inventory_item_id = p_inventory_item_id;
1531: ELSIF p_transaction_type_id = inv_globals.g_type_inv_lot_translate -- Lot Translate 84 Added bug4096035
1532: THEN
1533: SELECT NVL(msik.revision_qty_control_code, 1)
1534: , NVL(msik.serial_number_control_code, 1)
1535: , NVL(msik.restrict_subinventories_code, 2)

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

1632: BEGIN
1633: x_return_status := fnd_api.g_ret_sts_success;
1634: x_msg_data := '';
1635:
1636: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1637: THEN
1638: SELECT NVL(msik.revision_qty_control_code, 1)
1639: , NVL(msik.serial_number_control_code, 1)
1640: , NVL(msik.restrict_subinventories_code, 2)

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

1695: WHERE msik.lot_split_enabled = 'Y'
1696: AND msik.organization_id = p_organization_id
1697: AND msik.inventory_item_id = p_inventory_item_id;
1698: ELSE
1699: IF p_transaction_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
1700: THEN
1701: SELECT NVL(msik.revision_qty_control_code, 1)
1702: , NVL(msik.serial_number_control_code, 1)
1703: , NVL(msik.restrict_subinventories_code, 2)

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

1757: FROM mtl_system_items_vl msik /* Bug 5581528 */
1758: WHERE msik.lot_merge_enabled = 'Y'
1759: AND msik.organization_id = p_organization_id
1760: AND msik.inventory_item_id = p_inventory_item_id;
1761: ELSIF p_transaction_type_id = inv_globals.g_type_inv_lot_translate -- Lot Translate 84 Added bug4096035
1762: THEN
1763: SELECT NVL(msik.revision_qty_control_code, 1)
1764: , NVL(msik.serial_number_control_code, 1)
1765: , NVL(msik.restrict_subinventories_code, 2)