DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AQ$_JTF_FM_RAPID_ER_QTBL_F

Object Details
Object Name: AQ$_JTF_FM_RAPID_ER_QTBL_F
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
Q_NAME VARCHAR2 (30)
ROW_ID ROWID (10)
MSGID RAW (16) Yes
CORRID VARCHAR2 (128)
PRIORITY NUMBER

STATE NUMBER

DELAY TIMESTAMP(6) (20)
EXPIRATION NUMBER

ENQ_TIME TIMESTAMP(6) (20)
ENQ_UID NUMBER

ENQ_TID VARCHAR2 (30)
DEQ_TIME TIMESTAMP(6) (20)
DEQ_UID NUMBER

DEQ_TID VARCHAR2 (30)
RETRY_COUNT NUMBER

EXCEPTION_QSCHEMA VARCHAR2 (30)
EXCEPTION_QUEUE VARCHAR2 (30)
CSCN NUMBER

DSCN NUMBER

CHAIN_NO NUMBER

LOCAL_ORDER_NO NUMBER

TIME_MANAGER_INFO TIMESTAMP(6) (20)
STEP_NO NUMBER

USER_DATA BLOB (4000)
SENDER_NAME VARCHAR2 (30)
SENDER_ADDRESS VARCHAR2 (1024)
SENDER_PROTOCOL NUMBER

DEQUEUE_MSGID RAW (16)
DELIVERY_MODE CHAR (10)
SEQUENCE_NUM NUMBER

MSG_NUM NUMBER

QUEUE_ID NUMBER
Yes
USER_PROP ANYDATA (4392)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT Q_NAME
,      ROW_ID
,      MSGID
,      CORRID
,      PRIORITY
,      STATE
,      DELAY
,      EXPIRATION
,      ENQ_TIME
,      ENQ_UID
,      ENQ_TID
,      DEQ_TIME
,      DEQ_UID
,      DEQ_TID
,      RETRY_COUNT
,      EXCEPTION_QSCHEMA
,      EXCEPTION_QUEUE
,      CSCN
,      DSCN
,      CHAIN_NO
,      LOCAL_ORDER_NO
,      TIME_MANAGER_INFO
,      STEP_NO
,      USER_DATA
,      SENDER_NAME
,      SENDER_ADDRESS
,      SENDER_PROTOCOL
,      DEQUEUE_MSGID
,      DELIVERY_MODE
,      SEQUENCE_NUM
,      MSG_NUM
,      QUEUE_ID
,      USER_PROP
FROM APPS.AQ$_JTF_FM_RAPID_ER_QTBL_F;

Dependencies

[top of page]

APPS.AQ$_JTF_FM_RAPID_ER_QTBL_F references the following:

SchemaAPPS
TableJTF_FM_RAPID_ER_QTBL
SchemaSYS
ViewALL_INT_DEQUEUE_QUEUES
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code

APPS.AQ$_JTF_FM_RAPID_ER_QTBL_F is not referenced by any database object