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_INTERFACE_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2737: FROM mtl_material_transactions

2733: IF l_line_rec.source_type_code = 'EXTERNAL' THEN
2734: BEGIN
2735: SELECT transaction_date
2736: INTO x_source_line_rec.fulfilled_date
2737: FROM mtl_material_transactions
2738: WHERE transaction_type_id = l_drop_ship_txn_type_id
2739: AND trx_source_line_id = l_line_rec.line_id
2740: AND rownum = 1;
2741: EXCEPTION

Line 5154: mtl_material_transactions mmt

5150: mmt.transaction_type_id transaction_type_id,
5151: mmt.transaction_action_id transaction_action_id
5152: FROM mtl_system_items msi,
5153: mtl_unit_transactions mut,
5154: mtl_material_transactions mmt
5155: WHERE mmt.transaction_id = p_txn_id
5156: AND mmt.transaction_id = mut.transaction_id(+)
5157: AND msi.organization_id = mmt.organization_id
5158: AND msi.inventory_item_id = mmt.inventory_item_id

Line 5181: mtl_material_transactions mmt

5177: mmt.transaction_action_id transaction_action_id
5178: FROM mtl_system_items msi,
5179: mtl_unit_transactions mut,
5180: mtl_transaction_lot_numbers mtln,
5181: mtl_material_transactions mmt
5182: WHERE mmt.transaction_id = p_txn_id
5183: AND mmt.transaction_id = mtln.transaction_id(+)
5184: AND mtln.serial_transaction_id = mut.transaction_id(+)
5185: AND msi.organization_id = mmt.organization_id