eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPLSYS.AQ$_FND_CP_GSM_IPC_AQTBL_F

Source

View Text - Preformatted


SELECT  /*+ NO_MERGE (qo) USE_NL(iot) */ qt.q_name Q_NAME, qt.rowid ROW_ID, qt.msgid MSGID, qt.corrid CORRID, qt.priority PRIORITY, qt.state STATE, cast(FROM_TZ(qt.delay, '-08:00') at time zone sessiontimezone as timestamp) DELAY, qt.expiration EXPIRATION, cast(FROM_TZ(qt.enq_time, '-08:00') at time zone sessiontimezone as timestamp) ENQ_TIME, qt.enq_uid ENQ_UID, qt.enq_tid ENQ_TID, cast(FROM_TZ(qt.deq_time, '-08:00') at time zone sessiontimezone as timestamp) DEQ_TIME, qt.deq_uid DEQ_UID, qt.deq_tid DEQ_TID, qt.retry_count RETRY_COUNT, qt.exception_qschema EXCEPTION_QSCHEMA, qt.exception_queue EXCEPTION_QUEUE, qt.cscn CSCN, qt.dscn DSCN, qt.chain_no CHAIN_NO, qt.local_order_no LOCAL_ORDER_NO, cast(FROM_TZ(qt.time_manager_info, '-08:00') at time zone sessiontimezone as timestamp)   TIME_MANAGER_INFO, qt.step_no STEP_NO, qt.user_data USER_DATA, qt.sender_name SENDER_NAME, qt.sender_address SENDER_ADDRESS, qt.sender_protocol SENDER_PROTOCOL, qt.dequeue_msgid DEQUEUE_MSGID, 'PERSISTENT' DELIVERY_MODE, 0 SEQUENCE_NUM, 0 MSG_NUM, qo.qid QUEUE_ID, qt.user_prop USER_PROP, iot.subscriber# SUBSCRIBER_ID, iot.name SUBSCRIBER_NAME, iot.queue# QUEUE_EVTID FROM "FND_CP_GSM_IPC_AQTBL" qt, "AQ$_FND_CP_GSM_IPC_AQTBL_I" iot, SYS.ALL_INT_DEQUEUE_QUEUES qo WHERE qt.msgid=iot.msgid  and qt.q_name = qo.name  AND qo.owner = 'APPLSYS' AND iot.msg_priority = qt.priority AND  iot.msg_enq_time = qt.enq_time AND  iot.msg_step_no = qt.step_no  AND iot.msg_local_order_no = qt.local_order_no AND   iot.msg_chain_no = qt.chain_no  WITH READ ONLY

View Text - HTML Formatted

SELECT /*+ NO_MERGE (QO) USE_NL(IOT) */ QT.Q_NAME Q_NAME
, QT.ROWID ROW_ID
, QT.MSGID MSGID
, QT.CORRID CORRID
, QT.PRIORITY PRIORITY
, QT.STATE STATE
, CAST(FROM_TZ(QT.DELAY
, '-08:00') AT TIME ZONE SESSIONTIMEZONE AS TIMESTAMP) DELAY
, QT.EXPIRATION EXPIRATION
, CAST(FROM_TZ(QT.ENQ_TIME
, '-08:00') AT TIME ZONE SESSIONTIMEZONE AS TIMESTAMP) ENQ_TIME
, QT.ENQ_UID ENQ_UID
, QT.ENQ_TID ENQ_TID
, CAST(FROM_TZ(QT.DEQ_TIME
, '-08:00') AT TIME ZONE SESSIONTIMEZONE AS TIMESTAMP) DEQ_TIME
, QT.DEQ_UID DEQ_UID
, QT.DEQ_TID DEQ_TID
, QT.RETRY_COUNT RETRY_COUNT
, QT.EXCEPTION_QSCHEMA EXCEPTION_QSCHEMA
, QT.EXCEPTION_QUEUE EXCEPTION_QUEUE
, QT.CSCN CSCN
, QT.DSCN DSCN
, QT.CHAIN_NO CHAIN_NO
, QT.LOCAL_ORDER_NO LOCAL_ORDER_NO
, CAST(FROM_TZ(QT.TIME_MANAGER_INFO
, '-08:00') AT TIME ZONE SESSIONTIMEZONE AS TIMESTAMP) TIME_MANAGER_INFO
, QT.STEP_NO STEP_NO
, QT.USER_DATA USER_DATA
, QT.SENDER_NAME SENDER_NAME
, QT.SENDER_ADDRESS SENDER_ADDRESS
, QT.SENDER_PROTOCOL SENDER_PROTOCOL
, QT.DEQUEUE_MSGID DEQUEUE_MSGID
, 'PERSISTENT' DELIVERY_MODE
, 0 SEQUENCE_NUM
, 0 MSG_NUM
, QO.QID QUEUE_ID
, QT.USER_PROP USER_PROP
, IOT.SUBSCRIBER# SUBSCRIBER_ID
, IOT.NAME SUBSCRIBER_NAME
, IOT.QUEUE# QUEUE_EVTID
FROM "FND_CP_GSM_IPC_AQTBL" QT
, "AQ$_FND_CP_GSM_IPC_AQTBL_I" IOT
, SYS.ALL_INT_DEQUEUE_QUEUES QO
WHERE QT.MSGID=IOT.MSGID
AND QT.Q_NAME = QO.NAME
AND QO.OWNER = 'APPLSYS'
AND IOT.MSG_PRIORITY = QT.PRIORITY
AND IOT.MSG_ENQ_TIME = QT.ENQ_TIME
AND IOT.MSG_STEP_NO = QT.STEP_NO
AND IOT.MSG_LOCAL_ORDER_NO = QT.LOCAL_ORDER_NO
AND IOT.MSG_CHAIN_NO = QT.CHAIN_NO WITH READ ONLY