APPS.FII_MV_REFRESH dependencies on FND_STATS

Line 56: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,

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,
57: tabname=>'MLOG$_FII_GL_BASE_MV');
58: ELSE
59: BIS_MV_REFRESH.refresh_wrapper ( 'FII_GL_BASE_MV', '?',l_parallel_degree );
60: END IF;

Line 106: g_phase := 'Calling FND_STATS API to gather table statstics';

102: END IF;
103: END IF;
104:
105: -- Gather statistics for FII_GL_MGMT_CCC_MV
106: g_phase := 'Calling FND_STATS API to gather table statstics';
107: IF g_debug_flag = 'Y' THEN
108: FII_UTIL.put_line(g_phase ||' for FII_GL_MGMT_CCC_MV' );
109: FII_UTIL.put_line('');
110: END IF;

Line 112: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,

108: FII_UTIL.put_line(g_phase ||' for FII_GL_MGMT_CCC_MV' );
109: FII_UTIL.put_line('');
110: END IF;
111:
112: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,
113: tabname=>'FII_GL_MGMT_CCC_MV');
114:
115: --(only) Analyze the MV LOG after full refresh
116: IF (p_program_type = 'L') THEN

Line 117: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,

113: tabname=>'FII_GL_MGMT_CCC_MV');
114:
115: --(only) Analyze the MV LOG after full refresh
116: IF (p_program_type = 'L') THEN
117: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,
118: tabname=>'MLOG$_FII_GL_MGMT_CCC_MV');
119: END IF;
120:
121: -- Drop index for FII_GL_MGMT_SUM_MV in Initial Mode

Line 319: g_phase := 'Calling FND_STATS API to gather table statstics';

315:
316: --------------------------------------------------------
317: -- Gather statistics for the use of cost-based optimizer
318: --------------------------------------------------------
319: g_phase := 'Calling FND_STATS API to gather table statstics';
320: if g_debug_flag = 'Y' then
321: FII_UTIL.put_line(g_phase);
322: FII_UTIL.put_line('');
323: end if;

Line 325: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name, tabname=>'FII_AR_REV_SUM_MV');

321: FII_UTIL.put_line(g_phase);
322: FII_UTIL.put_line('');
323: end if;
324:
325: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name, tabname=>'FII_AR_REV_SUM_MV');
326:
327: END IF; -- l_count
328:
329: EXCEPTION