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.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 5134: mtl_transaction_lot_numbers mtln,

5130: mmt.transaction_source_id,
5131: mmt.trx_source_line_id,
5132: mtln.lot_number
5133: FROM mtl_unit_transactions mut,
5134: mtl_transaction_lot_numbers mtln,
5135: mtl_material_transactions mmt,
5136: mtl_system_items msi
5137: WHERE mut.serial_number = p_serial_number
5138: AND mut.inventory_item_id = p_inventory_item_id

Line 6230: mtl_transaction_lot_numbers mtln,

6226: AND ROWNUM = 1
6227: UNION --uncommented code for 6965008
6228: select '1'
6229: FROM mtl_unit_transactions mut,
6230: mtl_transaction_lot_numbers mtln,
6231: mtl_material_transactions mmt
6232: WHERE mut.inventory_item_id = p_item_id
6233: AND mut.serial_number = p_srl_num
6234: AND mtln.organization_id = mut.organization_id

Line 6477: FROM mtl_transaction_lot_numbers

6473: SELECT transaction_id,
6474: lot_number
6475: INTO l_mtl_txn_id,
6476: l_lot_number
6477: FROM mtl_transaction_lot_numbers
6478: WHERE serial_transaction_id = unit_txn_rec.transaction_id;
6479: EXCEPTION
6480: WHEN no_data_found THEN
6481: l_mtl_txn_id := unit_txn_rec.transaction_id;