Query to find Reference key with Table name & column

 

       
select ab.*--,do.created 
from (

SELECT a.constraint_name, 
a.table_name, 
a.column_name, 
c.owner, 
c_pk.table_name 
r_table_name,
b.column_name r_column_name,
C.constraint_type,
 c.LAST_CHANGE ,
 c.INDEX_NAME
 
   FROM DBA_cons_columns a
  JOIN DBA_constraints c ON a.owner = c.owner
       AND a.constraint_name = c.constraint_name
  JOIN DBA_constraints c_pk ON c.r_owner = c_pk.owner
       AND c.r_constraint_name = c_pk.constraint_name
  JOIN DBA_cons_columns b ON C_PK.owner = b.owner
       AND  C_PK.CONSTRAINT_NAME = b.constraint_name AND b.POSITION = a.POSITION     
 WHERE c.constraint_type = 'R'
)ab--,DBA_OBJECTS do
where 1=1-- DO.OBJECT_NAME=constraint_name
and table_name='VVS_TABLE'
;