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_INVLTATT_XMLP_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 225: from mtl_material_transactions_temp mmtt,

221: and mln1.lot_number = mln.lot_number
222: and mln1.inventory_item_id = mln.inventory_item_id)
223: /*Skip the lot if pending transaction exists */
224: AND not exists(select 'x'
225: from mtl_material_transactions_temp mmtt,
226: mtl_transaction_lots_temp mtlt
227: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
228: and mmtt.organization_id = mln.organization_id
229: and mmtt.inventory_item_id = mln.inventory_item_id

Line 406: from mtl_material_transactions_temp mmtt,

402: and mln1.lot_number = mln.lot_number
403: and mln1.inventory_item_id = mln.inventory_item_id)
404: /*Skip the lot if pending transaction exists */
405: AND not exists(select 'x'
406: from mtl_material_transactions_temp mmtt,
407: mtl_transaction_lots_temp mtlt
408: where mmtt.transaction_temp_id = mtlt.transaction_temp_id
409: and mmtt.organization_id = mln.organization_id
410: and mmtt.inventory_item_id = mln.inventory_item_id