APPS.AD_ZD_PREP dependencies on AD_ZD_MVIEW

Line 1881: and v.view_name = ad_zd_mview.get_mvq_name(m.mview_name) )

1877: and not exists
1878: ( select 'X'
1879: from dba_views v
1880: where v.owner = m.owner
1881: and v.view_name = ad_zd_mview.get_mvq_name(m.mview_name) )
1882: union
1883: select v.owner owner,
1884: ad_zd_mview.get_mv_name(v.view_name) name
1885: from dba_views v

Line 1884: ad_zd_mview.get_mv_name(v.view_name) name

1880: where v.owner = m.owner
1881: and v.view_name = ad_zd_mview.get_mvq_name(m.mview_name) )
1882: union
1883: select v.owner owner,
1884: ad_zd_mview.get_mv_name(v.view_name) name
1885: from dba_views v
1886: where v.view_name like '%'||'#'
1887: and v.editioning_view = 'N'
1888: and v.owner =x_user

Line 1892: and m.object_name = ad_zd_mview.get_mv_name(v.view_name)

1888: and v.owner =x_user
1889: and not exists
1890: ( select 'X' from dba_objects m
1891: where m.owner = v.owner
1892: and m.object_name = ad_zd_mview.get_mv_name(v.view_name)
1893: and m.object_type = 'MATERIALIZED VIEW'
1894: and m.status = 'VALID' );
1895:
1896:

Line 1956: ad_zd_mview.upgrade(l_mv.owner, l_mv.name);

1952: -- Expand MVs
1953: -- TODO: This ideally should be done after upgrading Tables of this user
1954: for l_mv in C_MVS loop
1955: log(l_module, 'STATEMENT', 'Fix MV: ' || l_mv.owner || '.' || l_mv.name);
1956: ad_zd_mview.upgrade(l_mv.owner, l_mv.name);
1957: end loop;
1958: end case;
1959: end loop;
1960:

Line 2191: log(c_module, 'STATEMENT', 'Invoking ad_zd_mview.upgrade_db API.' );

2187: enable_editions;
2188: commit;
2189:
2190: -- STEP#2) Materialized Views
2191: log(c_module, 'STATEMENT', 'Invoking ad_zd_mview.upgrade_db API.' );
2192: ad_zd_mview.upgrade_db(0);
2193: commit; --
2194:
2195: log(c_module, 'STATEMENT', 'Invoking ad_zd_table.upgrade_db API.' );

Line 2192: ad_zd_mview.upgrade_db(0);

2188: commit;
2189:
2190: -- STEP#2) Materialized Views
2191: log(c_module, 'STATEMENT', 'Invoking ad_zd_mview.upgrade_db API.' );
2192: ad_zd_mview.upgrade_db(0);
2193: commit; --
2194:
2195: log(c_module, 'STATEMENT', 'Invoking ad_zd_table.upgrade_db API.' );
2196: ad_zd_table.upgrade_db;