Oracle EBS SolutionsTalk
An Oracle Applications Knowledge Repository and Solution Center.
Tool Bar
Home
General Scripts
Live EBS Inst.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment