DBA Data[Home] [Help]

APPS.OPI_DBI_INV_CCA_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1112: mtl_transaction_accounts mta,

1108: mmt.subinventory_code),
1109: mmt.subinventory_code) subinventory_code,
1110: sum (mta.base_transaction_value) base_transaction_value
1111: FROM opi_dbi_mmt_cca_stg mmt,
1112: mtl_transaction_accounts mta,
1113: opi_dbi_conc_prog_run_log log
1114: WHERE log.etl_type = C_ETL_TYPE
1115: AND log.driving_table_code = C_LOG_MMT_DRV_TBL
1116: AND log.load_type = C_LOAD_INIT

Line 2907: mtl_transaction_accounts mta,

2903: mmt.subinventory_code),
2904: mmt.subinventory_code) subinventory_code,
2905: sum (mta.base_transaction_value) base_transaction_value
2906: FROM mtl_material_transactions mmt,
2907: mtl_transaction_accounts mta,
2908: opi_dbi_conc_prog_run_log log
2909: WHERE log.etl_type = C_ETL_TYPE
2910: AND log.driving_table_code = C_LOG_MMT_DRV_TBL
2911: AND log.load_type = C_LOAD_INCR