VIEW: SYS.ALL_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 dba_repflavor_columns fc, all_tab_columns tc
    WHERE fc.sname = tc.owner
      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 dba_repflavor_columns fc, "_ALL_REPL_NESTED_TABLE_NAMES" nt
    WHERE fc.sname = nt.owner
      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 DBA_REPFLAVOR_COLUMNS FC
, ALL_TAB_COLUMNS TC
WHERE FC.SNAME = TC.OWNER
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 DBA_REPFLAVOR_COLUMNS FC
, "_ALL_REPL_NESTED_TABLE_NAMES" NT
WHERE FC.SNAME = NT.OWNER
AND FC.ONAME = NT.TABLE_NAME