VIEW: SYS.ALL_APPLY_INSTANTIATED_SCHEMAS

Source

View Text - Preformatted

select ais."SOURCE_DATABASE",ais."SOURCE_SCHEMA",ais."INSTANTIATION_SCN",ais."APPLY_DATABASE_LINK",ais."SOURCE_ROOT_NAME"
  from DBA_APPLY_INSTANTIATED_SCHEMAS ais, ALL_APPLY aa
  where aa.apply_database_link = ais.apply_database_link

View Text - HTML Formatted

SELECT AIS."SOURCE_DATABASE"
, AIS."SOURCE_SCHEMA"
, AIS."INSTANTIATION_SCN"
, AIS."APPLY_DATABASE_LINK"
, AIS."SOURCE_ROOT_NAME"
FROM DBA_APPLY_INSTANTIATED_SCHEMAS AIS
, ALL_APPLY AA
WHERE AA.APPLY_DATABASE_LINK = AIS.APPLY_DATABASE_LINK