VIEW: SYS.USER_SUBSCRIBED_TABLES

Source

View Text - Preformatted

SELECT
   s.handle, t.source_schema_name, t.source_table_name, s.view_name,
   t.change_set_name, u.subscription_name
  FROM sys.cdc_subscribed_tables$ s, sys.cdc_change_tables$ t,
       sys.cdc_subscribers$ u, sys.user$ su
  WHERE s.change_table_obj#=t.obj# AND
        s.handle=u.handle AND
        u.username= su.name AND
        su.user#= USERENV('SCHEMAID')

View Text - HTML Formatted

SELECT S.HANDLE
, T.SOURCE_SCHEMA_NAME
, T.SOURCE_TABLE_NAME
, S.VIEW_NAME
, T.CHANGE_SET_NAME
, U.SUBSCRIPTION_NAME
FROM SYS.CDC_SUBSCRIBED_TABLES$ S
, SYS.CDC_CHANGE_TABLES$ T
, SYS.CDC_SUBSCRIBERS$ U
, SYS.USER$ SU
WHERE S.CHANGE_TABLE_OBJ#=T.OBJ# AND S.HANDLE=U.HANDLE AND U.USERNAME= SU.NAME AND SU.USER#= USERENV('SCHEMAID')