VIEW: SYS.KU$_FIND_HIDDEN_CONS_VIEW

Source

View Text - Preformatted

select  cd.con#, cn.name, u.name, o.name, cc.intcol#
  from    sys.obj$ o, sys.user$ u, sys.con$ cn, sys.ccol$ cc,
          sys.cdef$ cd, sys.col$ c
  where   cd.type#=3
          and cd.intcols=1
          and cn.con#=cd.con#
          and cc.con#=cd.con#
          and c.obj#=cd.obj#
          and c.intcol#=cc.intcol#
          and BITAND(c.property,1026)!=0
          and o.obj#=cd.obj#
          and u.user# = cn.owner#
          and (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (u.user#, 0) OR
                 EXISTS ( SELECT * FROM sys.session_roles
                          WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT CD.CON#
, CN.NAME
, U.NAME
, O.NAME
, CC.INTCOL#
FROM SYS.OBJ$ O
, SYS.USER$ U
, SYS.CON$ CN
, SYS.CCOL$ CC
, SYS.CDEF$ CD
, SYS.COL$ C
WHERE CD.TYPE#=3
AND CD.INTCOLS=1
AND CN.CON#=CD.CON#
AND CC.CON#=CD.CON#
AND C.OBJ#=CD.OBJ#
AND C.INTCOL#=CC.INTCOL#
AND BITAND(C.PROPERTY
, 1026)!=0
AND O.OBJ#=CD.OBJ#
AND U.USER# = CN.OWNER#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (U.USER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))