DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on DBA_OBJECTS

Line 1608: FROM sys.dba_objects do

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
1611: AND do.object_name = dt.table_NAME);
1612: BEGIN