APPS.OPI_DBI_INV_CCA_PKG dependencies on OPI_DBI_MMT_CCA_STG

Line 436: 'opi_dbi_mmt_cca_stg');

432: -- Truncate the MMT staging table, commit the data to the fact table
433: -- and update the CCA related bounds in one database transaction
434: -- for consistency.
435: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
436: 'opi_dbi_mmt_cca_stg');
437:
438:
439: -- return successfully
440: retcode := C_SUCCESS;

Line 681: 'opi_dbi_mmt_cca_stg');

677:
678: l_stmt_id := 130;
679: -- Staging table
680: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
681: 'opi_dbi_mmt_cca_stg');
682:
683: l_stmt_id := 140;
684: -- Conversion rates table
685: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||

Line 815: Insert /*+ append parallel (opi_dbi_mmt_cca_stg) */

811:
812: l_stmt_id :=0 ;
813:
814:
815: Insert /*+ append parallel (opi_dbi_mmt_cca_stg) */
816: into OPI_DBI_MMT_CCA_STG
817: (TRANSACTION_ID,
818: ORGANIZATION_ID,
819: INVENTORY_ITEM_ID,

Line 816: into OPI_DBI_MMT_CCA_STG

812: l_stmt_id :=0 ;
813:
814:
815: Insert /*+ append parallel (opi_dbi_mmt_cca_stg) */
816: into OPI_DBI_MMT_CCA_STG
817: (TRANSACTION_ID,
818: ORGANIZATION_ID,
819: INVENTORY_ITEM_ID,
820: CYCLE_COUNT_ID,

Line 1111: FROM opi_dbi_mmt_cca_stg mmt,

1107: 1, mmt.transfer_subinventory,
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