This post will help to get the underlying tables of the views .
create view sample_V as select a.* from user_rep.opb_subject a inner join user_rep.opb_mapping b
on a.subj_id=b.subject_id ;
select Name , type , referenced_name , referenced_type
from USER_dependencies where type = 'VIEW' and
referenced_type = 'TABLE'
Note : SysAdmin Login see the all the base tables of the view by referring
dba_dependencies (By using the filter on the column named owner )
The view 'USER_DEPENDENCIES' will give the dependencies of logged in user.
The view 'DBA_DEPENDENCIES' will give the dependencies of all the users.