APPS.MSC_UTIL dependencies on MSC_COLL_SNAPSHOTS_V

Line 1257: FROM msc_coll_snapshots_v

1253: lv_sql varchar2(1000);
1254: lv_Nologging_tblsp varchar2(30);
1255: begin
1256: for i in (SELECT mview_name,msc_util.GET_SCHEMA_NAME(erp_product_code) mview_owner
1257: FROM msc_coll_snapshots_v
1258: WHERE mview_name <> 'ALL SNAPSHOTS')
1259: loop
1260: BEGIN
1261: lv_sql:='DROP MATERIALIZED VIEW '||I.mview_owner||'.'||i.mview_name;

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