DBA Data[Home] [Help]

APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on DBMS_MVIEW

Line 1921: DBMS_MVIEW.REFRESH(

1917: l_err_msg VARCHAR2(255);
1918: BEGIN
1919:
1920: l_stmt_num := 10;
1921: DBMS_MVIEW.REFRESH(
1922: list => 'OPI_MTL_VAR_MV_F',
1923: method => p_method,
1924: parallelism => 0);
1925:

Line 1960: /*dbms_mview.refresh('OPI_MTL_VAR_SUM_MV',

1956:
1957: /*l_stmt_num := 10;*/
1958: /* Material Details MV Refresh */
1959:
1960: /*dbms_mview.refresh('OPI_MTL_VAR_SUM_MV',
1961: '?',
1962: '', -- ROLLBACK_SEG
1963: TRUE, -- PUSH_DEFERRED_RPC
1964: FALSE, -- REFRESH_AFTER_ERRORS

Line 1976: dbms_mview.refresh('OPI_MFG_VAR_SUM_MV',

1972:
1973: l_stmt_num := 20;
1974: /* MFG Cost Variance MV Refresh */
1975:
1976: dbms_mview.refresh('OPI_MFG_VAR_SUM_MV',
1977: '?',
1978: '', -- ROLLBACK_SEG
1979: TRUE, -- PUSH_DEFERRED_RPC
1980: FALSE, -- REFRESH_AFTER_ERRORS