VIEW: SYS.USER_REPFLAVOR_COLUMNS

Source

View Text - Preformatted

SELECT fc.fname, fc.gname, fc.sname, fc.oname, fc.cname, fc.type, fc.pos,
         fc.group_owner, fc.type_toid, fc.type_owner,
         fc.type_hashcode, fc.type_mod, fc.top
    FROM user_tab_columns tc, dba_repflavor_columns fc, sys.user$ u
    WHERE fc.sname = u.name
      AND u.user#  = userenv('SCHEMAID')
      AND fc.oname = tc.table_name
      AND ((fc.top IS NOT NULL AND fc.top = tc.column_name) OR
           (fc.top IS NULL AND fc.cname = tc.column_name))
UNION
  SELECT fc.fname, fc.gname, fc.sname, fc.oname, fc.cname, fc.type, fc.pos,
         fc.group_owner, fc.type_toid, fc.type_owner,
         fc.type_hashcode, fc.type_mod, fc.top
    FROM "_USER_REPL_NESTED_TABLE_NAMES" nt, dba_repflavor_columns fc,
          sys.user$ u
    WHERE fc.sname = u.name
      AND  u.user#  = userenv('SCHEMAID')
      AND fc.oname = nt.table_name

View Text - HTML Formatted

SELECT FC.FNAME
, FC.GNAME
, FC.SNAME
, FC.ONAME
, FC.CNAME
, FC.TYPE
, FC.POS
, FC.GROUP_OWNER
, FC.TYPE_TOID
, FC.TYPE_OWNER
, FC.TYPE_HASHCODE
, FC.TYPE_MOD
, FC.TOP
FROM USER_TAB_COLUMNS TC
, DBA_REPFLAVOR_COLUMNS FC
, SYS.USER$ U
WHERE FC.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND FC.ONAME = TC.TABLE_NAME
AND ((FC.TOP IS NOT NULL
AND FC.TOP = TC.COLUMN_NAME) OR (FC.TOP IS NULL
AND FC.CNAME = TC.COLUMN_NAME)) UNION SELECT FC.FNAME
, FC.GNAME
, FC.SNAME
, FC.ONAME
, FC.CNAME
, FC.TYPE
, FC.POS
, FC.GROUP_OWNER
, FC.TYPE_TOID
, FC.TYPE_OWNER
, FC.TYPE_HASHCODE
, FC.TYPE_MOD
, FC.TOP
FROM "_USER_REPL_NESTED_TABLE_NAMES" NT
, DBA_REPFLAVOR_COLUMNS FC
, SYS.USER$ U
WHERE FC.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND FC.ONAME = NT.TABLE_NAME