VIEW: SYS.DBA_SUBSCRIBED_COLUMNS

Source

View Text - Preformatted

SELECT
   sc.handle, t.source_schema_name, t.source_table_name, sc.column_name,
   s.subscription_name, y.source_database
  FROM sys.cdc_subscribed_columns$ sc, sys.cdc_change_tables$ t,
       sys.cdc_subscribers$ s, sys.cdc_change_sets$ x,
       sys.cdc_change_sources$ y
  WHERE sc.change_table_obj#=t.obj# AND
        s.handle = sc.handle AND
        t.change_set_name=x.set_name AND
        x.change_source_name = y.source_name

View Text - HTML Formatted

SELECT SC.HANDLE
, T.SOURCE_SCHEMA_NAME
, T.SOURCE_TABLE_NAME
, SC.COLUMN_NAME
, S.SUBSCRIPTION_NAME
, Y.SOURCE_DATABASE
FROM SYS.CDC_SUBSCRIBED_COLUMNS$ SC
, SYS.CDC_CHANGE_TABLES$ T
, SYS.CDC_SUBSCRIBERS$ S
, SYS.CDC_CHANGE_SETS$ X
, SYS.CDC_CHANGE_SOURCES$ Y
WHERE SC.CHANGE_TABLE_OBJ#=T.OBJ# AND S.HANDLE = SC.HANDLE AND T.CHANGE_SET_NAME=X.SET_NAME AND X.CHANGE_SOURCE_NAME = Y.SOURCE_NAME