select Owner,
Constraint_Name,
Constraint_Type,
Table_Name,
R_Owner,
R_Constraint_Name
from ALL_CONSTRAINTS
where Constraint_Type = 'R'
and
R_Constraint_Name in (
select Constraint_Name
from ALL_CONSTRAINTS
where Constraint_Type in ('P','U')
and
Table_Name = <table_name>
)
;