DBA Data[Home] [Help]

APPS.FII_MV_REFRESH dependencies on DBMS_MVIEW

Line 52: -- bug 4115002 - changed from dbms_mview.refresh to bis_mv_refresh

48: ---------------------------------*****---
49: --bug 3242732: refresh FII_GL_BASE_MV, this is a temporary fix
50: IF (p_program_type = 'L')
51: THEN
52: -- bug 4115002 - changed from dbms_mview.refresh to bis_mv_refresh
53: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', 'C',l_parallel_degree );
54:
55: --(only) Analyze the MV LOG after full refresh
56: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,

Line 80: ----- dbms_mview.refresh( list => 'FII_GL_MGMT_CCC_MV',

76:
77: ------------------------------------------------------------------------------
78: --Bug 3155474: call BIS wrapper to handle force parallel on MVs
79: -----
80: ----- dbms_mview.refresh( list => 'FII_GL_MGMT_CCC_MV',
81: ----- method => '?',
82: ----- parallelism => l_parallel_degree );
83:
84: IF (p_program_type = 'L') THEN

Line 137: ----- dbms_mview.refresh( list => 'FII_GL_MGMT_SUM_MV',

133:
134: ------------------------------------------------------------------------------
135: --Bug 3155474: call BIS wrapper to handle force parallel on MVs
136: --
137: ----- dbms_mview.refresh( list => 'FII_GL_MGMT_SUM_MV',
138: ----- method => '?',
139: ----- parallelism => l_parallel_degree );
140:
141: IF (p_program_type = 'L') THEN

Line 312: dbms_mview.refresh( list => 'FII_AR_REV_SUM_MV',

308: IF (l_parallel_degree =1) THEN
309: l_parallel_degree := 0;
310: END IF;
311:
312: dbms_mview.refresh( list => 'FII_AR_REV_SUM_MV',
313: method => '?',
314: parallelism => l_parallel_degree );
315:
316: --------------------------------------------------------