DBA_SUBSCRIPTIONS

DBA_SUBSCRIPTIONS enables publishers to see all subscriptions. You must have the SELECT_CATALOG_ROLE privilege to access this view. Except for the USERNAME column, which identifies the user name of the subscriber, DBA_SUBSCRIPTIONS has the same columns as those in "ALL_SUBSCRIPTIONS" .