VIEW: SYS.KU$_QUEUES_VIEW

Source

View Text - Preformatted

select '1','0',
        t.objno,
        q.eventid,
     (select value(o) from sys.ku$_schemaobj_view o where o.obj_num=q.eventid),
     (select value(b) from sys.ku$_schemaobj_view b where b.obj_num=t.objno),
        t.flags,
        q.usage, q.max_retries, q.retry_delay,
        q.enable_flag,
        q.properties, q.ret_time, q.queue_comment
  from system.aq$_queues q, system.aq$_queue_tables t
  where   q.table_objno = t.objno

View Text - HTML Formatted

SELECT '1'
, '0'
, T.OBJNO
, Q.EVENTID
, (SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM=Q.EVENTID)
, (SELECT VALUE(B)
FROM SYS.KU$_SCHEMAOBJ_VIEW B
WHERE B.OBJ_NUM=T.OBJNO)
, T.FLAGS
, Q.USAGE
, Q.MAX_RETRIES
, Q.RETRY_DELAY
, Q.ENABLE_FLAG
, Q.PROPERTIES
, Q.RET_TIME
, Q.QUEUE_COMMENT
FROM SYSTEM.AQ$_QUEUES Q
, SYSTEM.AQ$_QUEUE_TABLES T
WHERE Q.TABLE_OBJNO = T.OBJNO