DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on FND_TABLESPACES

Line 1277: select tablespace into lv_Nologging_tblsp from FND_TABLESPACES where tablespace_type = 'NOLOGGING';

1273: DROP_MVIEW_SYNONYMS(i.mview_owner, i.mview_name);
1274: end loop;
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