VIEW: SYS.KU$_ZM_VIEW_FH_VIEW

Source

View Text - Preformatted

select '2','0',
         mvv.sowner,
         mvv.vname,
         value(mvv),
         value(fhtv),
         cast(multiset(select value(iv) from sys.ku$_all_index_view iv, sys.ind$ i
                       where i.bo# = ot.obj# and
                             bitand(i.property,8192) = 8192 and
                             iv.obj_num = i.obj#) as ku$_index_list_t)
  from   sys.obj$ ot, sys.user$ u, sys.ku$_fhtable_view fhtv,
         sys.ku$_zm_view_view mvv
  where  ot.name     = mvv.tname
     and ot.owner#   = u.user#
     and u.name      = mvv.sowner
     and ot.type#    = 2
     and fhtv.obj_num = ot.obj#
     and BITAND(mvv.flag,33554432) != 33554432
     and (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (ot.owner#, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '2'
, '0'
, MVV.SOWNER
, MVV.VNAME
, VALUE(MVV)
, VALUE(FHTV)
, CAST(MULTISET(SELECT VALUE(IV)
FROM SYS.KU$_ALL_INDEX_VIEW IV
, SYS.IND$ I
WHERE I.BO# = OT.OBJ# AND BITAND(I.PROPERTY
, 8192) = 8192 AND IV.OBJ_NUM = I.OBJ#) AS KU$_INDEX_LIST_T)
FROM SYS.OBJ$ OT
, SYS.USER$ U
, SYS.KU$_FHTABLE_VIEW FHTV
, SYS.KU$_ZM_VIEW_VIEW MVV
WHERE OT.NAME = MVV.TNAME
AND OT.OWNER# = U.USER#
AND U.NAME = MVV.SOWNER
AND OT.TYPE# = 2
AND FHTV.OBJ_NUM = OT.OBJ#
AND BITAND(MVV.FLAG
, 33554432) != 33554432
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (OT.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))