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

Line 927: IF p_txn_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)

923: ELSE
924: l_inventory_item_id := p_inventory_item_id;
925: END IF;
926:
927: IF p_txn_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
928: THEN
929: OPEN x_lot_num_lov FOR
930: SELECT mln.lot_number lot_number
931: , mln.inventory_item_id

Line 966: IF p_txn_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83

962: AND msik.lot_split_enabled = 'Y'
963: AND mln.lot_number LIKE (p_lot_number)
964: ORDER BY lot_number, concatenated_segments;
965: ELSE
966: IF p_txn_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
967: THEN
968: IF (p_project_id IS NOT NULL) THEN
969: OPEN x_lot_num_lov FOR
970: SELECT DISTINCT moq.lot_number

Line 1069: ELSIF p_txn_type_id = inv_globals.G_TYPE_INV_LOT_TRANSLATE THEN -- for Lot Translate

1065: ORDER BY lot_number, concatenated_segments;
1066: END IF;
1067: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.
1068: -- SQL st will allow only those rows that are Lot Translate enabled.
1069: ELSIF p_txn_type_id = inv_globals.G_TYPE_INV_LOT_TRANSLATE THEN -- for Lot Translate
1070: OPEN x_lot_num_lov FOR -- Lot Translate 84
1071: SELECT mln.lot_number lot_number
1072: , mln.inventory_item_id
1073: , msik.concatenated_segments concatenated_segments

Line 1202: IF p_txn_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)

1198: ELSE
1199: l_status_id := '%';
1200: END IF;
1201:
1202: IF p_txn_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1203: THEN
1204: OPEN x_lot_num_lov FOR
1205: SELECT mln.lot_number lot_number
1206: , mln.inventory_item_id

Line 1240: IF p_txn_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83

1236: AND msik.lot_split_enabled = 'Y'
1237: AND mln.lot_number LIKE (p_lot_number)
1238: ORDER BY lot_number, concatenated_segments;
1239: ELSE
1240: IF p_txn_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
1241: THEN
1242: IF (p_project_id IS NOT NULL) THEN
1243: OPEN x_lot_num_lov FOR
1244: SELECT DISTINCT moq.lot_number

Line 1345: ELSIF p_txn_type_id = inv_globals.G_TYPE_INV_LOT_TRANSLATE THEN -- for Lot Translate

1341: ORDER BY lot_number, concatenated_segments;
1342: END IF;
1343: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.
1344: -- SQL st will allow only those rows that are Lot Translate enabled.
1345: ELSIF p_txn_type_id = inv_globals.G_TYPE_INV_LOT_TRANSLATE THEN -- for Lot Translate
1346: OPEN x_lot_num_lov FOR -- Lot Translate 84
1347: SELECT mln.lot_number lot_number
1348: , mln.inventory_item_id
1349: , msik.concatenated_segments concatenated_segments

Line 2286: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

2282: AND mmst.language (+) = userenv('LANG')
2283: AND wlc.lot_number LIKE (p_lot_number)
2284: AND inv_material_status_grp.is_status_applicable('TRUE',
2285: NULL,
2286: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2287: NULL,
2288: NULL,
2289: p_organization_id,
2290: p_item_id,