VIEW: SYS.REPCAT_REPOBJECT

Source

View Text - Preformatted

SELECT sname, oname, type, status, generation_status, id, object_comment,
       gowner, gname, trigflag, min_communication, internal_package_exists,
       receiver_tracing_enabled, nested_table, hashcode
  FROM repcat_repobject_base
 WHERE gowner IS NOT NULL AND gname IS NOT NULL
UNION
SELECT o.sname, o.oname, o.type, o.status, o.generation_status, o.id,
       o.object_comment, bo.gowner, bo.gname, o.trigflag, o.min_communication,
       o.internal_package_exists, o.receiver_tracing_enabled,
       o.nested_table, o.hashcode
  FROM repcat_repobject_base o, repcat_generated g, repcat_repobject_base bo
 WHERE (o.gowner IS NULL AND o.gname IS NULL)
   AND (o.sname = g.sname AND o.oname = g.oname AND o.type = g.type)
   AND (bo.sname = g.base_sname AND bo.oname = g.base_oname AND
        bo.type = g.base_type)
   AND (bo.gowner IS NOT NULL AND bo.gname IS NOT NULL)
UNION
SELECT o.sname, o.oname, o.type, o.status, o.generation_status, o.id,
       o.object_comment, bo.gowner, bo.gname, o.trigflag, o.min_communication,
       o.internal_package_exists, o.receiver_tracing_enabled,
       o.nested_table, o.hashcode
  FROM repcat_repobject_base o, repcat_repobject_base bo, sys.snap$ s
 WHERE (o.gowner IS NULL AND o.gname IS NULL AND o.type = 'INTERNAL PACKAGE')
   AND o.sname = s.mowner AND o.oname = s.master
   AND (bo.sname = s.sowner AND bo.oname = s.vname AND bo.type = 'SNAPSHOT')
   AND (s.mlink IS NOT NULL AND
        SUBSTR(s.mlink, 2) NOT IN (SELECT global_name from global_name))
   AND s.instsite = 0

View Text - HTML Formatted

SELECT SNAME
, ONAME
, TYPE
, STATUS
, GENERATION_STATUS
, ID
, OBJECT_COMMENT
, GOWNER
, GNAME
, TRIGFLAG
, MIN_COMMUNICATION
, INTERNAL_PACKAGE_EXISTS
, RECEIVER_TRACING_ENABLED
, NESTED_TABLE
, HASHCODE
FROM REPCAT_REPOBJECT_BASE
WHERE GOWNER IS NOT NULL
AND GNAME IS NOT NULL UNION SELECT O.SNAME
, O.ONAME
, O.TYPE
, O.STATUS
, O.GENERATION_STATUS
, O.ID
, O.OBJECT_COMMENT
, BO.GOWNER
, BO.GNAME
, O.TRIGFLAG
, O.MIN_COMMUNICATION
, O.INTERNAL_PACKAGE_EXISTS
, O.RECEIVER_TRACING_ENABLED
, O.NESTED_TABLE
, O.HASHCODE
FROM REPCAT_REPOBJECT_BASE O
, REPCAT_GENERATED G
, REPCAT_REPOBJECT_BASE BO
WHERE (O.GOWNER IS NULL
AND O.GNAME IS NULL)
AND (O.SNAME = G.SNAME
AND O.ONAME = G.ONAME
AND O.TYPE = G.TYPE)
AND (BO.SNAME = G.BASE_SNAME
AND BO.ONAME = G.BASE_ONAME AND BO.TYPE = G.BASE_TYPE)
AND (BO.GOWNER IS NOT NULL
AND BO.GNAME IS NOT NULL) UNION SELECT O.SNAME
, O.ONAME
, O.TYPE
, O.STATUS
, O.GENERATION_STATUS
, O.ID
, O.OBJECT_COMMENT
, BO.GOWNER
, BO.GNAME
, O.TRIGFLAG
, O.MIN_COMMUNICATION
, O.INTERNAL_PACKAGE_EXISTS
, O.RECEIVER_TRACING_ENABLED
, O.NESTED_TABLE
, O.HASHCODE
FROM REPCAT_REPOBJECT_BASE O
, REPCAT_REPOBJECT_BASE BO
, SYS.SNAP$ S
WHERE (O.GOWNER IS NULL
AND O.GNAME IS NULL
AND O.TYPE = 'INTERNAL PACKAGE')
AND O.SNAME = S.MOWNER
AND O.ONAME = S.MASTER
AND (BO.SNAME = S.SOWNER
AND BO.ONAME = S.VNAME
AND BO.TYPE = 'SNAPSHOT')
AND (S.MLINK IS NOT NULL AND SUBSTR(S.MLINK
, 2) NOT IN (SELECT GLOBAL_NAME
FROM GLOBAL_NAME))
AND S.INSTSITE = 0