select cols.owner, cols.table_name, cols.column_name, fk.constraint_name, fk.r_owner, pk.table_name as pk_table_name, pk.constraint_name as pk_constraint_name from all_constraints pk join all_constraints fk on fk.r_owner = pk.owner and fk.r_constraint_name = pk.constraint_name join all_cons_columns cols on cols.owner = fk.owner and cols.constraint_name = fk.constraint_name where pk.table_name= 'TARGET TABLE NAME HERE' and fk.constraint_type = 'R';