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

Line 3694: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln

3690: );
3691: /* BUG 5361705 - raise opm qm event for every distinct lot */
3692: Cursor cr_get_distinct_lots(l_txn_id NUMBER) IS
3693: select distinct mtln.product_transaction_id,mln.gen_object_id
3694: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln
3695: where transaction_id = l_txn_id
3696: and mln.lot_number = mtln.lot_number
3697: and mln.inventory_item_id = mtln.inventory_item_id
3698: and mln.organization_id = mtln.organization_id;