APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on OPI_DBI_JOB_MTL_DTL_STD_F

Line 2199: INTO OPI_DBI_JOB_MTL_DTL_STD_F

2195:
2196: /* ODM Standards insert into fact table */
2197: l_stmt_num := 30;
2198: INSERT
2199: INTO OPI_DBI_JOB_MTL_DTL_STD_F
2200: (
2201: organization_id,
2202: job_id,
2203: job_type,

Line 2423: INTO OPI_DBI_JOB_MTL_DTL_STD_F fact using

2419:
2420: /* ODM Standards merge into fact table */
2421: l_stmt_num := 30;
2422: MERGE
2423: INTO OPI_DBI_JOB_MTL_DTL_STD_F fact using
2424: (
2425: select
2426: actuals.organization_id organization_id,
2427: actuals.job_id job_id,

Line 2596: INTO OPI_DBI_JOB_MTL_DTL_STD_F

2592: /* Actuals fact which is at transaction date level is summarised and joined with the
2593: scaled mtl table, standard value is calculated as actual-value* std_qty/actual_qty */
2594: l_stmt_num := 40;
2595: INSERT
2596: INTO OPI_DBI_JOB_MTL_DTL_STD_F
2597: (
2598: organization_id,
2599: job_id,
2600: job_type,

Line 2730: INTO OPI_DBI_JOB_MTL_DTL_STD_F fact using

2726:
2727: /* OPM Standards insert into fact table */
2728: l_stmt_num := 40;
2729: MERGE
2730: INTO OPI_DBI_JOB_MTL_DTL_STD_F fact using
2731: (
2732: select
2733: tmp.organization_id organization_id,
2734: tmp.batch_id job_id,

Line 4060: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DTL_STD_F';

4056: l_stmt_num := 10;
4057: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
4058: --{
4059: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DETAILS_F';
4060: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DTL_STD_F';
4061: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_COMP_F';
4062: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_SCRAP_F';
4063:
4064: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DETAILS_F PURGE MATERIALIZED VIEW LOG';

Line 4065: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DTL_STD_F PURGE MATERIALIZED VIEW LOG';

4061: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_COMP_F';
4062: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_SCRAP_F';
4063:
4064: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DETAILS_F PURGE MATERIALIZED VIEW LOG';
4065: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_DTL_STD_F PURGE MATERIALIZED VIEW LOG';
4066: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_COMP_F PURGE MATERIALIZED VIEW LOG';
4067: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_SCRAP_F PURGE MATERIALIZED VIEW LOG';
4068: --}
4069: END IF;

Line 4205: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DTL_STD_F') = false then

4201: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DETAILS_F') = false then
4202: RAISE_APPLICATION_ERROR(-20000, errbuf);
4203: END IF;
4204:
4205: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DTL_STD_F') = false then
4206: RAISE_APPLICATION_ERROR(-20000, errbuf);
4207: END IF;
4208:
4209: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_COMP_F') = false then