Reference Manual
   CHAPTER 16. System Views     

SYSSUBSCRIPTIONS system view

CREATE VIEW SYS.SYSSUBSCRIPTIONS
AS
SELECT(select publication_name 
      FROM SYS.SYSPUBLICATION AS p
      WHERE p.publication_id=s.publication_id) AS 
      publication_name,
      (select user_name FROM SYS.SYSUSERPERM AS u
      WHERE u.user_id=s.user_id) AS user_name,
      subscribe_by,created,started 
FROM SYS.SYSSUBSCRIPTION AS s

Presents subscription information, such as the publication name, creation time, and start time from the SYSPUBLICATION table in a more readable format.