VIEW: SYS.KU$_INC_TYPE_VIEW

Source

View Text - Preformatted

select value (oo)
  from sys.ku$_edition_schemaobj_view oo, sys.obj$ o, sys.obj$ do,
       sys.dependency$ d, sys.type$ ty
  where o.oid$ = ty.toid
    and oo.obj_num = o.obj#
    and o.owner# != 0                   /* not owned by SYS */
    and bitand(o.flags,16)!=16          /* not secondary object */
    and o.obj# = d.p_obj#
    and do.obj# = d.d_obj#
    and bitand(d.property,2)=2          /* only REF dependency */
    and do.type# = 13
    and bitand(ty.properties,8388608)=0 /* exclude transient types */
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT VALUE (OO)
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW OO
, SYS.OBJ$ O
, SYS.OBJ$ DO
, SYS.DEPENDENCY$ D
, SYS.TYPE$ TY
WHERE O.OID$ = TY.TOID
AND OO.OBJ_NUM = O.OBJ#
AND O.OWNER# != 0 /* NOT OWNED BY SYS */
AND BITAND(O.FLAGS
, 16)!=16 /* NOT SECONDARY OBJECT */
AND O.OBJ# = D.P_OBJ#
AND DO.OBJ# = D.D_OBJ#
AND BITAND(D.PROPERTY
, 2)=2 /* ONLY REF DEPENDENCY */
AND DO.TYPE# = 13
AND BITAND(TY.PROPERTIES
, 8388608)=0 /* EXCLUDE TRANSIENT TYPES */
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))