Search This Blog

Friday, 19 April 2013

Find Oracle ERP object name

SELECT NAME, TYPE, REFERENCED_NAME, REFERENCED_TYPE
  FROM USER_DEPENDENCIES
 WHERE NAME = UPPER('ap_invoices')
 --WHERE NAME LIKE UPPER('%AP_INVOICE%')
 AND (TYPE = 'VIEW' OR REFERENCED_TYPE = 'TABLE')

No comments:

Post a Comment