APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_RES_ACTUAL_F

Line 2255: || '.opi_dbi_res_actual_f PURGE MATERIALIZED VIEW LOG ';

2251: execute immediate 'truncate table ' || l_opi_schema
2252: || '.opi_dbi_res_avail_f PURGE MATERIALIZED VIEW LOG ';
2253:
2254: execute immediate 'truncate table ' || l_opi_schema
2255: || '.opi_dbi_res_actual_f PURGE MATERIALIZED VIEW LOG ';
2256: --}
2257: ELSE
2258: --{
2259: RAISE SCHEMA_INFO_NOT_FOUND;

Line 2413: INTO opi_dbi_res_actual_f c (

2409:
2410: bis_collection_utilities.put_line('Initially load actual data from staging to actual fact ...');
2411:
2412: INSERT /*+ append parallel(c) */
2413: INTO opi_dbi_res_actual_f c (
2414: resource_id,
2415: department_id,
2416: organization_id,
2417: uom,

Line 3153: MERGE INTO opi_dbi_res_actual_f f

3149: --{
3150: bis_collection_utilities.put_line('Merge res actual from staging to actual fact ...');
3151: l_stmt_num := 120;
3152:
3153: MERGE INTO opi_dbi_res_actual_f f
3154: USING (
3155: SELECT
3156: stg.resource_id,
3157: stg.department_id,