DBA_APPLY_INSTANTIATED_OBJECTS

Columns
   ___________________________
 
   SOURCE_DATABASE
      Name of the database where the objects originated
   SOURCE_OBJECT_OWNER
      Owner of the object at the source database
   SOURCE_OBJECT_NAME
      Name of the object at source
   SOURCE_OBJECT_TYPE
      Type of the object at source
   INSTANTIATION_SCN
      Point in time when the object was instantiated at source
   IGNORE_SCN
      SCN lower bound for messages that will be considered for apply
   APPLY_DATABASE_LINK
      For remote objects,the database link pointing to the remote database

Related: