VIEW: SYS._ALL_REPFLAVOR_OBJECTS

Source

View Text - Preformatted

SELECT fo.flavor_id, fo.gname, fo.sname, fo.oname, fo.type, fo.columns_present,
       fl.published, ro.flag, fo.gowner, fo.version#, fo.hashcode
from system.repcat$_flavor_objects fo, all_objects o,
     system.repcat$_flavors fl, system.repcat$_repobject ro
where fo.gname     = fl.gname
  and fo.gowner    = fl.gowner
  and fo.flavor_id = fl.flavor_id
  and fo.sname     = ro.sname
  and fo.oname     = ro.oname
  and fo.type      = ro.type
  and fo.sname     = o.owner
  and fo.oname     = o.object_name
  and ro.id        = o.object_id
  and ((fo.type = -1 and o.object_type in ('VIEW', 'TABLE'))
       or
       (fo.type > 0 and o.object_type =
       DECODE (fo.type,
        1, 'INDEX',
        2, 'TABLE',
        4, 'VIEW',
        5, 'SYNONYM',
        6, 'SEQUENCE',
        7, 'PROCEDURE',
        8, 'FUNCTION',
        9, 'PACKAGE',
       11, 'PACKAGE BODY',
       12, 'TRIGGER',
       13, 'TYPE',
       14, 'TYPE BODY',
       32, 'INDEXTYPE',
       33, 'OPERATOR',
           'UNDEFINED')))

View Text - HTML Formatted

SELECT FO.FLAVOR_ID
, FO.GNAME
, FO.SNAME
, FO.ONAME
, FO.TYPE
, FO.COLUMNS_PRESENT
, FL.PUBLISHED
, RO.FLAG
, FO.GOWNER
, FO.VERSION#
, FO.HASHCODE FROM SYSTEM.REPCAT$_FLAVOR_OBJECTS FO
, ALL_OBJECTS O
, SYSTEM.REPCAT$_FLAVORS FL
, SYSTEM.REPCAT$_REPOBJECT RO WHERE FO.GNAME = FL.GNAME
AND FO.GOWNER = FL.GOWNER
AND FO.FLAVOR_ID = FL.FLAVOR_ID
AND FO.SNAME = RO.SNAME
AND FO.ONAME = RO.ONAME
AND FO.TYPE = RO.TYPE
AND FO.SNAME = O.OWNER
AND FO.ONAME = O.OBJECT_NAME
AND RO.ID = O.OBJECT_ID
AND ((FO.TYPE = -1
AND O.OBJECT_TYPE IN ('VIEW'
, 'TABLE')) OR (FO.TYPE > 0
AND O.OBJECT_TYPE = DECODE (FO.TYPE
, 1
, 'INDEX'
, 2
, 'TABLE'
, 4
, 'VIEW'
, 5
, 'SYNONYM'
, 6
, 'SEQUENCE'
, 7
, 'PROCEDURE'
, 8
, 'FUNCTION'
, 9
, 'PACKAGE'
, 11
, 'PACKAGE BODY'
, 12
, 'TRIGGER'
, 13
, 'TYPE'
, 14
, 'TYPE BODY'
, 32
, 'INDEXTYPE'
, 33
, 'OPERATOR'
, 'UNDEFINED')))