All Oracle Constraint

 select  c1.owner, c1.table_name, c1.constraint_name, c2.owner, c2.table_name, c2.column_name

from dba_constraints c1

JOIN dba_cons_columns c2

ON c1.R_CONSTRAINT_NAME=C2.CONSTRAINT_NAME and c1.r_owner=c2.owner

where C1.constraint_type = 'R' and c2.table_name='C_BPARTNER'

order by c1.owner, c1.table_name, c1.constraint_name, c2.position