How To Get All The View That Are Referring To A Particular Table

Use the following script to find out the views which are referring to 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 '<TABLE_NAME>');

Most Frequently Used PLSQL Scripts In Oracle Apps:

1. How To Add Any Responsibility To A User From Back End
2. How To Call A Standard Interface Program From Sql or pl/sql Code
3. How To Copy Files Using a PL/SQL Script
4. How To Delete A Concurrent Program And Executable From Back End In Oracle Apps
5. How To Dump Data From Pl/SQL Block To Flat Files
6. How To Get RESPONSIBILITY_ID, APPLICATION_ID & USER_ID
7. How To Send An SMS Using PL/SQL Code/Script
8. PL/SQL Script To Change/Reset The Oracle Applications Password From Back End
9. PL/SQL Script To Create A User In Oracle Applications
10. PL/SQL Script To Remove End Date From Responsibilities Assigned To A User