Query to get all the views that refer a particular table

Download Query

Query to get all the views that refer a particular table

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 '');

Download Query