SELECT o.object_name, o.status, o.last_ddl_time
FROM SYS.dba_objects o
WHERE o.object_type = 'VIEW'
AND EXISTS
(SELECT 'x'
FROM SYS.dba_dependencies d
WHERE d.referenced_type = 'TABLE'
AND d.TYPE = 'VIEW'
AND d.owner = 'APPS'
AND d.NAME = o.object_name
AND d.referenced_name LIKE '<TABLE_NAME>');
FROM SYS.dba_objects o
WHERE o.object_type = 'VIEW'
AND EXISTS
(SELECT 'x'
FROM SYS.dba_dependencies d
WHERE d.referenced_type = 'TABLE'
AND d.TYPE = 'VIEW'
AND d.owner = 'APPS'
AND d.NAME = o.object_name
AND d.referenced_name LIKE '<TABLE_NAME>');
No comments:
Post a Comment