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

947: ELSE
948: l_inventory_item_id := p_inventory_item_id;
949: END IF;
950:
951: IF p_txn_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
952: THEN
953: OPEN x_lot_num_lov FOR
954: SELECT mln.lot_number lot_number
955: , mln.inventory_item_id

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

986: AND msik.lot_split_enabled = 'Y'
987: AND mln.lot_number LIKE (p_lot_number)
988: ORDER BY lot_number, concatenated_segments;
989: ELSE
990: IF p_txn_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
991: THEN
992: IF (p_project_id IS NOT NULL) THEN
993: OPEN x_lot_num_lov FOR
994: SELECT DISTINCT moq.lot_number

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

1089: ORDER BY lot_number, concatenated_segments;
1090: END IF;
1091: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.
1092: -- SQL st will allow only those rows that are Lot Translate enabled.
1093: ELSIF p_txn_type_id = inv_globals.G_TYPE_INV_LOT_TRANSLATE THEN -- for Lot Translate
1094: OPEN x_lot_num_lov FOR -- Lot Translate 84
1095: SELECT mln.lot_number lot_number
1096: , mln.inventory_item_id
1097: , msik.concatenated_segments concatenated_segments

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

1222: ELSE
1223: l_status_id := '%';
1224: END IF;
1225:
1226: IF p_txn_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
1227: THEN
1228: OPEN x_lot_num_lov FOR
1229: SELECT mln.lot_number lot_number
1230: , mln.inventory_item_id

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

1260: AND msik.lot_split_enabled = 'Y'
1261: AND mln.lot_number LIKE (p_lot_number)
1262: ORDER BY lot_number, concatenated_segments;
1263: ELSE
1264: IF p_txn_type_id = inv_globals.g_type_inv_lot_merge -- Lot Merge 83
1265: THEN
1266: IF (p_project_id IS NOT NULL) THEN
1267: OPEN x_lot_num_lov FOR
1268: SELECT DISTINCT moq.lot_number

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

1365: ORDER BY lot_number, concatenated_segments;
1366: END IF;
1367: -- For bug 4306954: Added ELSIF condtion for Lot Translate case.
1368: -- SQL st will allow only those rows that are Lot Translate enabled.
1369: ELSIF p_txn_type_id = inv_globals.G_TYPE_INV_LOT_TRANSLATE THEN -- for Lot Translate
1370: OPEN x_lot_num_lov FOR -- Lot Translate 84
1371: SELECT mln.lot_number lot_number
1372: , mln.inventory_item_id
1373: , msik.concatenated_segments concatenated_segments

Line 2316: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,

2312: AND mmst.language (+) = userenv('LANG')
2313: AND wlc.lot_number LIKE (p_lot_number)
2314: AND inv_material_status_grp.is_status_applicable('TRUE',
2315: NULL,
2316: INV_GLOBALS.G_TYPE_CONTAINER_UNPACK,
2317: NULL,
2318: NULL,
2319: p_organization_id,
2320: p_item_id,