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_UNIT_TRANSACTIONS

Line 1201: FROM mtl_unit_transactions mut

1197: SELECT mut.serial_number serial_number,
1198: mut.inventory_item_id item_id,
1199: mut.organization_id organization_id,
1200: to_char(null) lot_number
1201: FROM mtl_unit_transactions mut
1202: WHERE mut.transaction_id = p_txn_id
1203: UNION
1204: SELECT mut.serial_number serial_number,
1205: mut.inventory_item_id item_id,

Line 1209: mtl_unit_transactions mut

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;
1213:

Line 1297: FROM mtl_unit_transactions mut,

1293: p_item_id in number)
1294: IS
1295: SELECT mmt.creation_date mtl_creation_date,
1296: mmt.transaction_id mtl_txn_id
1297: FROM mtl_unit_transactions mut,
1298: mtl_material_transactions mmt
1299: WHERE mut.serial_number = p_serial_number
1300: AND mut.inventory_item_id = p_item_id
1301: AND mmt.transaction_id = mut.transaction_id

Line 1305: FROM mtl_unit_transactions mut,

1301: AND mmt.transaction_id = mut.transaction_id
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