Relation between tables in oracle

Here is the query to find how tables are related in oracle..

select distinct
  src_cc.table_name as TABLE_NAME,
  src_cc.column_name as FOREIGN_KEY,
  dest_cc.table_name as REFERENCED_TABLE,
dest_cc.column_name as PRIMARY_KEY_COLUMN,
 c.r_constraint_name as P_KEY_NAME
from
  all_constraints c
inner join all_cons_columns dest_cc on
  c.r_constraint_name = dest_cc.constraint_name
inner join all_cons_columns src_cc on
  c.constraint_name = src_cc.constraint_name
where
  c.constraint_type = 'R'
  and dest_cc.owner = 'PRATIK'
    order by src_cc.table_name asc