VIEW: SYS.ALL_REPFLAVOR_OBJECTS

Source

View Text - Preformatted

SELECT UNIQUE fo.fname, fo.gname, fo.sname, fo.oname,
       fo.type, fo.group_owner
from dba_repflavor_objects fo, all_objects o
where fo.sname = o.owner
  and fo.oname = o.object_name
  and (fo.type = o.object_type OR
       fo.type = 'SNAPSHOT' and o.object_type IN ('VIEW', 'TABLE'))

View Text - HTML Formatted

SELECT UNIQUE FO.FNAME
, FO.GNAME
, FO.SNAME
, FO.ONAME
, FO.TYPE
, FO.GROUP_OWNER FROM DBA_REPFLAVOR_OBJECTS FO
, ALL_OBJECTS O WHERE FO.SNAME = O.OWNER
AND FO.ONAME = O.OBJECT_NAME
AND (FO.TYPE = O.OBJECT_TYPE OR FO.TYPE = 'SNAPSHOT'
AND O.OBJECT_TYPE IN ('VIEW'
, 'TABLE'))