VIEW: SYS.KU$_QUEUE_TABLE_VIEW

Source

View Text - Preformatted

select '1','1',
          t.objno,
          (select value(qo) from  sys.ku$_schemaobj_view qo where
             qo.obj_num=t.objno),
          (select value(s) from sys.ku$_qtab_storage_view s where
             s.obj_num = t.objno),
          t.udata_type,
         (select u.name || '.' || o.name
            from sys.ku$_schemaobj_view o, sys.user$ u,
                 sys.col$ c, sys.coltype$ ct
             where c.intcol# = ct.intcol#
                and c.obj# = ct.obj#
                and c.name = 'USER_DATA'
                and t.objno = c.obj#
                and o.oid = ct.toid
                and o.type_num = 13
                and o.owner_num = u.user#),
         t.sort_cols,
         t.flags,
         t.table_comment,
         aft.primary_instance,
         aft.secondary_instance,
         aft.owner_instance
  from   system.aq$_queue_tables t,
         sys.aq$_queue_table_affinities aft
  where  t.objno = aft.table_objno

View Text - HTML Formatted

SELECT '1'
, '1'
, T.OBJNO
, (SELECT VALUE(QO)
FROM SYS.KU$_SCHEMAOBJ_VIEW QO WHERE QO.OBJ_NUM=T.OBJNO)
, (SELECT VALUE(S)
FROM SYS.KU$_QTAB_STORAGE_VIEW S WHERE S.OBJ_NUM = T.OBJNO)
, T.UDATA_TYPE
, (SELECT U.NAME || '.' || O.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.USER$ U
, SYS.COL$ C
, SYS.COLTYPE$ CT
WHERE C.INTCOL# = CT.INTCOL#
AND C.OBJ# = CT.OBJ#
AND C.NAME = 'USER_DATA'
AND T.OBJNO = C.OBJ#
AND O.OID = CT.TOID
AND O.TYPE_NUM = 13
AND O.OWNER_NUM = U.USER#)
, T.SORT_COLS
, T.FLAGS
, T.TABLE_COMMENT
, AFT.PRIMARY_INSTANCE
, AFT.SECONDARY_INSTANCE
, AFT.OWNER_INSTANCE
FROM SYSTEM.AQ$_QUEUE_TABLES T
, SYS.AQ$_QUEUE_TABLE_AFFINITIES AFT
WHERE T.OBJNO = AFT.TABLE_OBJNO