Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME AQ$DEF$_AQCALL
TEXT_LENGTH 2362
TEXT SELECT q_name QUEUE, msgid MSG_ID, corrid CORR_ID, priority MSG_PRIORITY, decode(state, 0, 'READY', 1, 'WAIT', 2, 'PROCESSED', 3, 'EXPIRED', 10, 'BUFFERED_EXPIRED') MSG_STATE, cast(FROM_TZ(delay, '00:00') at time zone sessiontimezone as date) DELAY, cast(FROM_TZ(delay, '00:00') at time zone sessiontimezone as timestamp) DELAY_TIMESTAMP, expiration, cast(FROM_TZ(enq_time, '00:00') at time zone sessiontimezone as date) ENQ_TIME, cast(FROM_TZ(enq_time, '00:00') at time zone sessiontimezone as timestamp) ENQ_TIMESTAMP, enq_uid ENQ_USER_ID, enq_tid ENQ_TXN_ID, cast(FROM_TZ(deq_time, '00:00') at time zone sessiontimezone as date) DEQ_TIME, cast(FROM_TZ(deq_time, '00:00') at time zone sessiontimezone as timestamp) DEQ_TIMESTAMP, deq_uid DEQ_USER_ID, deq_tid DEQ_TXN_ID, retry_count, decode (state, 0, exception_qschema, 1, exception_qschema, 2, exception_qschema, NULL) EXCEPTION_QUEUE_OWNER, decode (state, 0, exception_queue, 1, exception_queue, 2, exception_queue, NULL) EXCEPTION_QUEUE, user_data, decode (state, 3, decode (deq_tid, 'INVALID_TRANSACTION', NULL, exception_queue), NULL) ORIGINAL_QUEUE_NAME, decode (state, 3, decode (deq_tid, 'INVALID_TRANSACTION', NULL, exception_qschema), NULL) ORIGINAL_QUEUE_OWNER, decode(state, 3, decode(deq_time, NULL, decode(deq_tid, NULL, decode (expiration , NULL , 'MAX_RETRY_EXCEEDED', 'TIME_EXPIRATION'), 'INVALID_TRANSACTION', NULL, 'MAX_RETRY_EXCEEDED'), NULL), NULL) EXPIRATION_REASON FROM "DEF$_AQCALL" WHERE state != 7 AND state != 9 WITH READ ONLY
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY Y