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

Line 1208: FROM mtl_transaction_lot_numbers mtln,

1204: SELECT mut.serial_number serial_number,
1205: mut.inventory_item_id item_id,
1206: mut.organization_id organization_id,
1207: mtln.lot_number lot_number
1208: FROM mtl_transaction_lot_numbers mtln,
1209: mtl_unit_transactions mut
1210: WHERE mtln.transaction_id = p_txn_id
1211: AND mut.transaction_id = mtln.serial_transaction_id
1212: ORDER BY 1;

Line 1306: mtl_transaction_lot_numbers mtln,

1302: UNION ALL
1303: SELECT mmt.creation_date mtl_creation_date,
1304: mmt.transaction_id mtl_txn_id
1305: FROM mtl_unit_transactions mut,
1306: mtl_transaction_lot_numbers mtln,
1307: mtl_material_transactions mmt
1308: WHERE mut.serial_number = p_serial_number
1309: AND mut.inventory_item_id = p_item_id
1310: AND mtln.organization_id = mut.organization_id