VIEW: SYS._DBA_APPLY_OBJECTS

Source

View Text - Preformatted

select
u.name, o.name, do.property, do.dblink, do.spare1, do.spare2,
do.spare3, do.spare4
from sys.streams$_dest_objs do, sys.obj$ o, sys.user$ u
  where o.obj# = do.object_number
   and o.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, DO.PROPERTY
, DO.DBLINK
, DO.SPARE1
, DO.SPARE2
, DO.SPARE3
, DO.SPARE4 FROM SYS.STREAMS$_DEST_OBJS DO
, SYS.OBJ$ O
, SYS.USER$ U
WHERE O.OBJ# = DO.OBJECT_NUMBER
AND O.OWNER# = U.USER#