VIEW: SYS.ALL_APPLY_TABLE_COLUMNS

Source

View Text - Preformatted

select do."OBJECT_OWNER",do."OBJECT_NAME",do."COLUMN_NAME",do."COMPARE_OLD_ON_DELETE",do."COMPARE_OLD_ON_UPDATE",do."APPLY_DATABASE_LINK"
  from all_tab_columns a, dba_apply_table_columns do
 where do.object_owner = a.owner
   and do.object_name = a.table_name
   and do.column_name = a.column_name

View Text - HTML Formatted

SELECT DO."OBJECT_OWNER"
, DO."OBJECT_NAME"
, DO."COLUMN_NAME"
, DO."COMPARE_OLD_ON_DELETE"
, DO."COMPARE_OLD_ON_UPDATE"
, DO."APPLY_DATABASE_LINK"
FROM ALL_TAB_COLUMNS A
, DBA_APPLY_TABLE_COLUMNS DO
WHERE DO.OBJECT_OWNER = A.OWNER
AND DO.OBJECT_NAME = A.TABLE_NAME
AND DO.COLUMN_NAME = A.COLUMN_NAME