VIEW: SYS.USER_SUBSCRIPTIONS

Source

View Text - Preformatted

SELECT
   s.handle, s.set_name, s.username, s.created, s.status, s.earliest_scn,
   s.latest_scn, s.description, s.last_purged, s.last_extended,
   s.subscription_name
  FROM sys.cdc_subscribers$ s, sys.user$ u
  WHERE s.username= u.name AND
        u.user#   = USERENV('SCHEMAID')

View Text - HTML Formatted

SELECT S.HANDLE
, S.SET_NAME
, S.USERNAME
, S.CREATED
, S.STATUS
, S.EARLIEST_SCN
, S.LATEST_SCN
, S.DESCRIPTION
, S.LAST_PURGED
, S.LAST_EXTENDED
, S.SUBSCRIPTION_NAME
FROM SYS.CDC_SUBSCRIBERS$ S
, SYS.USER$ U
WHERE S.USERNAME= U.NAME AND U.USER# = USERENV('SCHEMAID')