VIEW: SYS.DBA_SUBSCRIBED_TABLES

Source

View Text - Preformatted

SELECT
   st.handle, t.source_schema_name, t.source_table_name, st.view_name,
   t.change_set_name, s.subscription_name
  FROM sys.cdc_subscribed_tables$ st, sys.cdc_change_tables$ t,
       sys.cdc_subscribers$ s
  WHERE st.change_table_obj#=t.obj# AND
        s.handle = st.handle

View Text - HTML Formatted

SELECT ST.HANDLE
, T.SOURCE_SCHEMA_NAME
, T.SOURCE_TABLE_NAME
, ST.VIEW_NAME
, T.CHANGE_SET_NAME
, S.SUBSCRIPTION_NAME
FROM SYS.CDC_SUBSCRIBED_TABLES$ ST
, SYS.CDC_CHANGE_TABLES$ T
, SYS.CDC_SUBSCRIBERS$ S
WHERE ST.CHANGE_TABLE_OBJ#=T.OBJ# AND S.HANDLE = ST.HANDLE