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

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)