Monday, October 23, 2017

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

No comments:

Post a Comment

currentAppUi built in variable in VBCS

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...