DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1643: from mtl_transaction_accounts

1639: opi_dbi_intr_mmt_tmp mmt1,
1640: (select
1641: transaction_id,
1642: sum (base_transaction_value) base_transaction_value
1643: from mtl_transaction_accounts
1644: where accounting_line_type = 14 -- Accounting line for Inransit in MTA
1645: group by transaction_id) mta,
1646: mtl_system_items msi_fm,
1647: mtl_system_items msi_to,

Line 1690: mtl_transaction_accounts mta,

1686: msi_fm.primary_uom_code,
1687: trunc(mmt1.transaction_date) trx_date,
1688: 'N' process_flag -- Bug fix: 5362465, source is only discrete here
1689: FROM opi_dbi_intr_mmt_tmp mmt1,
1690: mtl_transaction_accounts mta,
1691: mtl_system_items msi_fm,
1692: OPI_DBI_CONC_PROG_RUN_LOG col
1693: WHERE mmt1.transaction_action_id = 24
1694: AND mta.transaction_id = mmt1.transaction_id

Line 2150: FROM mtl_transaction_accounts mta

2146: case when mta.transaction_id < prl.to_bound_id then 'Y'
2147: else 'N'
2148: end push_to_fact_flag,
2149: 'MTA' transaction_source
2150: FROM mtl_transaction_accounts mta
2151: ,mtl_material_transactions mmt
2152: ,wip_entities we
2153: ,opi_dbi_conc_prog_run_log prl
2154: WHERE prl.driving_table_code = 'MMT'