APPS.MSC_UTIL dependencies on ALL_MVIEWS

Line 1387: from all_mviews

1383: lv_exists number;
1384: begin
1385: EXECUTE IMMEDIATE
1386: ' select 1
1387: from all_mviews
1388: where mview_name =:p1
1389: and owner = :p2 '
1390: into lv_exists using p_MV_name, p_schema_name;
1391:

Line 1555: from MSC_COLL_SNAPSHOTS_V a, ALL_MVIEWS b,ALL_TABLES c

1551:
1552: -- drop MVs which are not in NOLLOGING tblspc
1553: select tablespace into lv_Nologging_tblsp from FND_TABLESPACES where tablespace_type = 'NOLOGGING';
1554: FOR j IN(select a.mview_name,c.table_name,c.TABLESPACE_NAME
1555: from MSC_COLL_SNAPSHOTS_V a, ALL_MVIEWS b,ALL_TABLES c
1556: where a.mview_name = b.mview_name
1557: AND b.OWNER = G_APPS_SCHEMA
1558: AND b.CONTAINER_NAME = c.table_name
1559: AND c.owner = G_APPS_SCHEMA