DBA Data[Home] [Help]

APPS.EDW_GL_ACCT_M_T dependencies on DBMS_MVIEW

Line 1801: dbms_mview.refresh (l_mview_name,'C');

1797:
1798: --- if the mv exists refresh all the levels mv
1799: if(l_tmp_name is not null) then
1800: edw_log.put_line( 'Refreshing MV'||l_mview_name);
1801: dbms_mview.refresh (l_mview_name,'C');
1802: else -- if mv does not exist creat MV's
1803: l_stmt_mvcrt := 'CREATE MATERIALIZED VIEW '|| l_mview_name||' TABLESPACE '||l_tspace_name || ' ENABLE QUERY REWRITE AS SELECT DISTINCT '|| 'H'||l_lvl_num||'_NAME'||' FROM '||g_dimension_name;
1804: edw_log.put_line(l_stmt_mvcrt);
1805: execute immediate l_stmt_mvcrt;