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

Line 306: MTL_MATERIAL_TRANSACTIONS mmt

302: Begin
303: Select Count(*)
304: Into l_error_count
305: From CSI_TXN_ERRORS csi,
306: MTL_MATERIAL_TRANSACTIONS mmt
307: Where csi.inv_material_transaction_id Is Not Null
308: And csi.inv_material_transaction_id = mmt.transaction_id
309: And csi.processed_flag IN ('E','R')
310: And mmt.inventory_item_id = inventory_item_id_mig(i)

Line 329: MTL_MATERIAL_TRANSACTIONS mmt

325: Begin
326: Select Count(*)
327: Into l_error_count
328: From CSI_XNP_MSGS_TEMP xnp,
329: MTL_MATERIAL_TRANSACTIONS mmt
330: Where xnp.source_id = mmt.transaction_id
331: And xnp.source_type = 'MTL_TRANSACTION_ID'
332: And mmt.inventory_item_id = inventory_item_id_mig(i)
333: And mmt.organization_id = organization_id_mig(i)

Line 624: mtl_material_transactions mmt,

620: mmt.transfer_transaction_id mtl_xfer_txn_id,
621: to_char(null) lot_number,
622: to_char(mmt.transaction_date,'dd-mm-yy hh24:mi:ss') mtl_txn_char_date
623: FROM mtl_unit_transactions mut,
624: mtl_material_transactions mmt,
625: mtl_transaction_types mtt
626: WHERE p_lot_code = g_no_lot
627: AND mut.serial_number = p_serial_number
628: AND mut.inventory_item_id = p_item_id

Line 650: mtl_material_transactions mmt,

646: mtln.lot_number lot_number,
647: to_char(mmt.transaction_date,'dd-mm-yy hh24:mi:ss') mtl_txn_char_date
648: FROM mtl_unit_transactions mut,
649: mtl_transaction_lot_numbers mtln,
650: mtl_material_transactions mmt,
651: mtl_transaction_types mtt
652: WHERE p_lot_code = g_lot
653: AND mut.serial_number = p_serial_number
654: AND mut.inventory_item_id = p_item_id