VIEW: SYS.ALL_APPLY_KEY_COLUMNS

Source

View Text - Preformatted

select k.object_owner, k.object_name, k.column_name, k.apply_database_link
  from all_tab_columns a, dba_apply_key_columns k
 where k.object_owner = a.owner
   and k.object_name = a.table_name
   and k.column_name = a.column_name

View Text - HTML Formatted

SELECT K.OBJECT_OWNER
, K.OBJECT_NAME
, K.COLUMN_NAME
, K.APPLY_DATABASE_LINK
FROM ALL_TAB_COLUMNS A
, DBA_APPLY_KEY_COLUMNS K
WHERE K.OBJECT_OWNER = A.OWNER
AND K.OBJECT_NAME = A.TABLE_NAME
AND K.COLUMN_NAME = A.COLUMN_NAME