DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_SCRAP_INIT_PKG dependencies on DBMS_MVIEW

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

1230: l_stmt_id := 0;
1231:
1232: -- refresh the first level MV: opi_comp_scr_mv
1233: l_stmt_id := 10;
1234: DBMS_MVIEW.REFRESH ('opi_comp_scr_mv', '?');
1235: commit;
1236:
1237: -- refresh the second level MV: opi_prod_scr_mv
1238: l_stmt_id := 20;

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

1235: commit;
1236:
1237: -- refresh the second level MV: opi_prod_scr_mv
1238: l_stmt_id := 20;
1239: DBMS_MVIEW.REFRESH ('opi_prod_scr_mv', '?');
1240: commit;
1241:
1242: -- refresh the third and nested level MV: opi_scrap_sum_mv
1243: l_stmt_id := 30;

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

1240: commit;
1241:
1242: -- refresh the third and nested level MV: opi_scrap_sum_mv
1243: l_stmt_id := 30;
1244: DBMS_MVIEW.REFRESH ('opi_scrap_sum_mv', '?');
1245: commit;
1246:
1247: -- return successfully
1248: BIS_COLLECTION_UTILITIES.PUT_LINE