VIEW: SYS.DBA_REPKEY_COLUMNS

Source

View Text - Preformatted

select rk.sname, rk.oname, rc.lcname
from system.repcat$_key_columns rk, system.repcat$_repcolumn rc
where rk.sname   = rc.sname
  and rk.oname   = rc.oname
  and rk.col     = rc.cname  -- SYS column name

View Text - HTML Formatted

SELECT RK.SNAME
, RK.ONAME
, RC.LCNAME FROM SYSTEM.REPCAT$_KEY_COLUMNS RK
, SYSTEM.REPCAT$_REPCOLUMN RC WHERE RK.SNAME = RC.SNAME
AND RK.ONAME = RC.ONAME
AND RK.COL = RC.CNAME -- SYS COLUMN NAME