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.OPI_DBI_INV_VALUE_INCR_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 258: mtl_material_transactions mmt3,

254: mta.inventory_item_id,
255: trunc(mta.transaction_date) transaction_date,
256: sum(mta.base_transaction_value) base_transaction_value
257: FROM mtl_transaction_accounts mta,
258: mtl_material_transactions mmt3,
259: opi_dbi_conc_prog_run_log prl,
260: mtl_parameters mp
261: WHERE mta.accounting_line_type = 1
262: AND mta.transaction_id >= prl.from_bound_id

Line 284: SELECT /+ index(mmt, MTL_MATERIAL_TRANSACTIONS_U1) /

280: ) mta1,
281: (
282: -- csheu 3/31/2003. Filter out consigned Inventory transactions
283: -- Added the hint to fix bug #3223207
284: SELECT /*+ index(mmt, MTL_MATERIAL_TRANSACTIONS_U1) */
285: mmt.organization_id,
286: decode(mmt.transaction_action_id,24,nvl(mmt.subinventory_code,-1),mmt.subinventory_code) subinventory_code,
287: mmt.inventory_item_id,
288: trunc(mmt.transaction_date) transaction_date,

Line 290: FROM mtl_material_transactions mmt,

286: decode(mmt.transaction_action_id,24,nvl(mmt.subinventory_code,-1),mmt.subinventory_code) subinventory_code,
287: mmt.inventory_item_id,
288: trunc(mmt.transaction_date) transaction_date,
289: nvl(sum(decode(mmt.transaction_action_id,24,0,mmt.primary_quantity)),0) onhand_qty
290: FROM mtl_material_transactions mmt,
291: mtl_parameters mp,
292: opi_dbi_conc_prog_run_log prl
293: WHERE prl.etl_type = 'INVENTORY'
294: AND prl.load_type = 'INCR'

Line 422: mtl_material_transactions mmt,

418: GROUP BY gtv.transaction_id,
419: nvl(gtv.subinventory_code,-1),
420: gtv.accounted_flag
421: ) gtv,
422: mtl_material_transactions mmt,
423: mtl_system_items msi
424: WHERE mmt.transaction_id = gtv.transaction_id
425: AND mmt.inventory_item_id = msi.inventory_item_id
426: AND mmt.organization_id = msi.organization_id

Line 626: mtl_material_transactions mmt1,

622: DECODE (mip.owning_organization_id, msi_fm.organization_id, msi_fm.primary_uom_code
623: ,msi_to.organization_id, msi_to.primary_uom_code) primary_uom_code,
624: TRUNC (mmt1.transaction_date) trx_date
625: FROM opi_dbi_intr_mip_tmp mip,
626: mtl_material_transactions mmt1,
627: (select
628: transaction_id,
629: sum (base_transaction_value) base_transaction_value
630: from mtl_transaction_accounts

Line 678: FROM mtl_material_transactions mmt1,

674: 0 qty,
675: sum (base_transaction_value) value,
676: msi_fm.primary_uom_code,
677: trunc(mmt1.transaction_date) trx_date
678: FROM mtl_material_transactions mmt1,
679: mtl_transaction_accounts mta,
680: mtl_system_items msi_fm,
681: OPI_DBI_CONC_PROG_RUN_LOG col
682: WHERE mmt1.transaction_action_id = 24

Line 805: mtl_material_transactions mmt1,

801: DECODE (mip.owning_organization_id, msi_fm.organization_id, msi_fm.primary_uom_code
802: ,msi_to.organization_id, msi_to.primary_uom_code) primary_uom_code,
803: TRUNC (mmt1.transaction_date) trx_date
804: FROM opi_dbi_intr_mip_tmp mip,
805: mtl_material_transactions mmt1,
806: (SELECT transaction_id,
807: sum(txn_base_value) base_transaction_value
808: ,accounted_flag
809: FROM gmf_transaction_valuation gtv,