DBA_CONS_COLUMNS

Information about accessible columns in constraint definitions

Columns
   ___________________________
 
   OWNER
      Owner of the constraint definition
   CONSTRAINT_NAME
      Name associated with the constraint definition
   TABLE_NAME
      Name associated with table with constraint definition
   COLUMN_NAME
      Name associated with column or attribute of object column specified in the constraint definition
   POSITION
      Original position of column or attribute in definition

Related:

Simon Sheppard
SS64.com