VIEW: SYS.USER_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, user_objects o, sys.user$ u
where fo.sname = u.name
  and u.user#  = userenv('SCHEMAID')
  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
, USER_OBJECTS O
, SYS.USER$ U WHERE FO.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND FO.ONAME = O.OBJECT_NAME
AND (FO.TYPE = O.OBJECT_TYPE OR FO.TYPE = 'SNAPSHOT'
AND O.OBJECT_TYPE IN ('VIEW'
, 'TABLE'))