APPS.MSC_UTIL dependencies on ALL_MVIEWS

Line 1131: from all_mviews

1127: lv_exists number;
1128: begin
1129: EXECUTE IMMEDIATE
1130: ' select 1
1131: from all_mviews
1132: where mview_name =:p1
1133: and owner = :p2 '
1134: into lv_exists using p_MV_name, p_schema_name;
1135:

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

1275:
1276: -- drop MVs which are not in NOLLOGING tblspc
1277: select tablespace into lv_Nologging_tblsp from FND_TABLESPACES where tablespace_type = 'NOLOGGING';
1278: FOR j IN(select a.mview_name,c.table_name,c.TABLESPACE_NAME
1279: from MSC_COLL_SNAPSHOTS_V a, ALL_MVIEWS b,ALL_TABLES c
1280: where a.mview_name = b.mview_name
1281: AND b.OWNER = G_APPS_SCHEMA
1282: AND b.CONTAINER_NAME = c.table_name
1283: AND c.owner = G_APPS_SCHEMA