Somthing like this:

select table_name from user_constraints where constraint_name in
(select r_constraint_name from user_constraints where constraint_type='R')