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

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...