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


VIEW: APPLSYS.AQ$_FND_CP_TM_RET_AQTBL_F

Object Details
Object Name: AQ$_FND_CP_TM_RET_AQTBL_F
Object Type: VIEW
Owner: APPLSYS
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 FND_CP_TM_AQ_PAYLOAD (64)
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)
SUBSCRIBER_ID NUMBER
Yes
SUBSCRIBER_NAME VARCHAR2 (30) Yes
QUEUE_EVTID NUMBER
Yes
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
,      SUBSCRIBER_ID
,      SUBSCRIBER_NAME
,      QUEUE_EVTID
FROM APPLSYS.AQ$_FND_CP_TM_RET_AQTBL_F;

Dependencies

[top of page]

APPLSYS.AQ$_FND_CP_TM_RET_AQTBL_F references the following:

SchemaAPPLSYS
TableAQ$_FND_CP_TM_RET_AQTBL_I
TableFND_CP_TM_RET_AQTBL
SchemaSYS
ViewALL_INT_DEQUEUE_QUEUES
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code
SchemaSYSTEM
TYPEFND_CP_TM_AQ_PAYLOAD

APPLSYS.AQ$_FND_CP_TM_RET_AQTBL_F is not referenced by any database object