APPS.MSC_UTIL dependencies on MSC_COLL_SNAPSHOTS_V

Line 1530: FROM msc_coll_snapshots_v

1526: lv_sql varchar2(1000);
1527: lv_Nologging_tblsp varchar2(30);
1528: begin
1529: for i in (SELECT mview_name,msc_util.GET_SCHEMA_NAME(erp_product_code) mview_owner
1530: FROM msc_coll_snapshots_v
1531: WHERE mview_name <> 'ALL SNAPSHOTS'
1532: UNION /*Old Mviews that need to be dropped*/
1533: Select 'BOM_CTO_ORDER_DMD_SN',msc_util.G_BOM_SCHEMA
1534: FROM Dual)

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

Line 1606: FROM msc_coll_snapshots_v)

1602: CURSOR tabWithoutMV IS
1603: SELECT table_name,owner
1604: FROM sys.dba_tables dt
1605: WHERE table_name IN (SELECT mview_name
1606: FROM msc_coll_snapshots_v)
1607: AND NOT EXISTS (SELECT 1
1608: FROM sys.dba_objects do
1609: WHERE do.object_type='MATERIALIZED VIEW'
1610: AND do.owner=dt.owner