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_UTILITY_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 145: FROM MTL_MATERIAL_TRANSACTIONS mmt, MTL_TRANSACTION_LOT_NUMBERS mtln

141: BEGIN
142:
143: SELECT MIN(mmt.transaction_id)
144: INTO l_transaction_id
145: FROM MTL_MATERIAL_TRANSACTIONS mmt, MTL_TRANSACTION_LOT_NUMBERS mtln
146: WHERE mmt.transaction_id = mtln.transaction_id (+)
147: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
148: AND NVL(mmt.revision, '@') = NVL(p_revision, '@')
149: AND NVL(mtln.lot_number, '@') = NVL(p_lot_number, '@')

Line 186: FROM MTL_MATERIAL_TRANSACTIONS mmt, MTL_TRANSACTION_LOT_NUMBERS mtln

182: BEGIN
183:
184: SELECT MAX(mmt.transaction_id)
185: INTO l_transaction_id
186: FROM MTL_MATERIAL_TRANSACTIONS mmt, MTL_TRANSACTION_LOT_NUMBERS mtln
187: WHERE mmt.transaction_id = mtln.transaction_id (+)
188: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
189: AND NVL(mmt.revision, '@') = NVL(p_revision, '@')
190: AND NVL(mtln.lot_number, '@') = NVL(p_lot_number, '@')