APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 257: FROM mtl_transaction_accounts mta,

253: 24,nvl(mmt3.subinventory_code,'-1'),mmt3.subinventory_code) subinventory_code,
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

Line 630: from mtl_transaction_accounts

626: mtl_material_transactions mmt1,
627: (select
628: transaction_id,
629: sum (base_transaction_value) base_transaction_value
630: from mtl_transaction_accounts
631: where accounting_line_type = 14
632: AND transaction_id >= from_mta_id --BOUNDS COLLECTED ABOVE
633: ANd transaction_id < to_mta_id
634: group by transaction_id) mta,

Line 679: mtl_transaction_accounts mta,

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
683: AND mta.transaction_id = mmt1.transaction_id

Line 956: SELECT /*+ index(mta, mtl_transaction_accounts_n1) */

952: g_user_id,
953: g_login_id
954: FROM
955: (-- Added the hint to fix bug #3223207
956: SELECT /*+ index(mta, mtl_transaction_accounts_n1) */
957: mta.organization_id organization_id,
958: we.primary_item_id inventory_item_id,
959: trunc (mta.transaction_date) transaction_date,
960: sum (nvl (mta.base_transaction_value,0)) wip_value

Line 962: mtl_transaction_accounts mta,

958: we.primary_item_id inventory_item_id,
959: trunc (mta.transaction_date) transaction_date,
960: sum (nvl (mta.base_transaction_value,0)) wip_value
961: FROM
962: mtl_transaction_accounts mta,
963: Opi_dbi_conc_prog_run_log prl,
964: wip_entities we
965: WHERE
966: prl.driving_table_code = 'MMT'