How to find what table is the view based on?
I tried dba_views, but that doesn't have table_name column. I also tried dba_dependencies, it returns the following, but those are not what I was looking for. Please advise. Thank you very much.
SQL> select referenced_owner, referenced_name, referenced_type, referenced_link_name from dba_dependencies where owner='APPS' and name='ORG_ORGANIZATION_DEFINITIONS' and type='VIEW';
REFERENCED_OWNER
------------------------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
------------------
REFERENCED_LINK_NAME