APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on DBMS_MVIEW

Line 372: DBMS_MVIEW.REFRESH(

368: l_err_msg VARCHAR2(255);
369: BEGIN
370:
371: l_stmt_num := 10;
372: DBMS_MVIEW.REFRESH(
373: list => 'OPI_MTL_VAR_MV_F',
374: method => p_method,
375: parallelism => 0);
376:

Line 4375: DBMS_MVIEW.REFRESH ('OPI_MTL_VAR_ACT_MV_F', '?');

4371: l_stmt_num := 10;
4372: /* Material Details MV Refresh */
4373:
4374: /* VB WHy are we refresing MVs here rather than in RSG */
4375: DBMS_MVIEW.REFRESH ('OPI_MTL_VAR_ACT_MV_F', '?');
4376:
4377: dbms_mview.refresh('OPI_MTL_VAR_SUM_MV',
4378: '?',
4379: '', -- ROLLBACK_SEG

Line 4377: dbms_mview.refresh('OPI_MTL_VAR_SUM_MV',

4373:
4374: /* VB WHy are we refresing MVs here rather than in RSG */
4375: DBMS_MVIEW.REFRESH ('OPI_MTL_VAR_ACT_MV_F', '?');
4376:
4377: dbms_mview.refresh('OPI_MTL_VAR_SUM_MV',
4378: '?',
4379: '', -- ROLLBACK_SEG
4380: TRUE, -- PUSH_DEFERRED_RPC
4381: FALSE, -- REFRESH_AFTER_ERRORS

Line 4394: DBMS_MVIEW.REFRESH ('opi_comp_scr_mv', '?');

4390: l_stmt_num := 20;
4391: /* Scrap MV Refresh */
4392:
4393: -- First Level MV
4394: DBMS_MVIEW.REFRESH ('opi_comp_scr_mv', '?');
4395:
4396: l_stmt_num := 24;
4397: -- Second Level MV
4398: DBMS_MVIEW.REFRESH ('opi_prod_scr_mv', '?');

Line 4398: DBMS_MVIEW.REFRESH ('opi_prod_scr_mv', '?');

4394: DBMS_MVIEW.REFRESH ('opi_comp_scr_mv', '?');
4395:
4396: l_stmt_num := 24;
4397: -- Second Level MV
4398: DBMS_MVIEW.REFRESH ('opi_prod_scr_mv', '?');
4399:
4400: l_stmt_num := 28;
4401: -- Third Level MV
4402: DBMS_MVIEW.REFRESH ('opi_scrap_sum_mv', '?');

Line 4402: DBMS_MVIEW.REFRESH ('opi_scrap_sum_mv', '?');

4398: DBMS_MVIEW.REFRESH ('opi_prod_scr_mv', '?');
4399:
4400: l_stmt_num := 28;
4401: -- Third Level MV
4402: DBMS_MVIEW.REFRESH ('opi_scrap_sum_mv', '?');
4403:
4404: BIS_COLLECTION_UTILITIES.PUT_LINE('Scrap Refresh finished ...');
4405:
4406: l_stmt_num := 32;

Line 4408: dbms_mview.refresh('OPI_ONTIME_PROD_OO1_MV',

4404: BIS_COLLECTION_UTILITIES.PUT_LINE('Scrap Refresh finished ...');
4405:
4406: l_stmt_num := 32;
4407: /* Refresh MV over WIP Completions fact for On Time production */
4408: dbms_mview.refresh('OPI_ONTIME_PROD_OO1_MV',
4409: '?',
4410: '', -- ROLLBACK_SEG
4411: TRUE, -- PUSH_DEFERRED_RPC
4412: FALSE, -- REFRESH_AFTER_ERRORS