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


VIEW: APPLSYS.AQ$FND_CP_TM_AQTBL

Object Details
Object Name: AQ$FND_CP_TM_AQTBL
Object Type: VIEW
Owner: APPLSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUEUE VARCHAR2 (30)
MSG_ID RAW (16) Yes
CORR_ID VARCHAR2 (128)
MSG_PRIORITY NUMBER

MSG_STATE VARCHAR2 (16)
DELAY DATE

DELAY_TIMESTAMP TIMESTAMP(6) (20)
EXPIRATION NUMBER

ENQ_TIME DATE

ENQ_TIMESTAMP TIMESTAMP(6) (20)
ENQ_USER_ID NUMBER

ENQ_TXN_ID VARCHAR2 (30)
DEQ_TIME DATE

DEQ_TIMESTAMP TIMESTAMP(9) (20)
DEQ_USER_ID NUMBER

DEQ_TXN_ID VARCHAR2 (30)
RETRY_COUNT NUMBER

EXCEPTION_QUEUE_OWNER VARCHAR2 (30)
EXCEPTION_QUEUE VARCHAR2 (30)
USER_DATA FND_CP_TM_AQ_PAYLOAD (64)
PROPAGATED_MSGID RAW (16)
SENDER_NAME VARCHAR2 (30)
SENDER_ADDRESS VARCHAR2 (1024)
SENDER_PROTOCOL NUMBER

ORIGINAL_MSGID RAW (16)
ORIGINAL_QUEUE_NAME VARCHAR2 (30)
ORIGINAL_QUEUE_OWNER VARCHAR2 (30)
EXPIRATION_REASON VARCHAR2 (31)
CONSUMER_NAME VARCHAR2 (30)
ADDRESS VARCHAR2 (1024)
PROTOCOL NUMBER

Query Text

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


SELECT QUEUE
,      MSG_ID
,      CORR_ID
,      MSG_PRIORITY
,      MSG_STATE
,      DELAY
,      DELAY_TIMESTAMP
,      EXPIRATION
,      ENQ_TIME
,      ENQ_TIMESTAMP
,      ENQ_USER_ID
,      ENQ_TXN_ID
,      DEQ_TIME
,      DEQ_TIMESTAMP
,      DEQ_USER_ID
,      DEQ_TXN_ID
,      RETRY_COUNT
,      EXCEPTION_QUEUE_OWNER
,      EXCEPTION_QUEUE
,      USER_DATA
,      PROPAGATED_MSGID
,      SENDER_NAME
,      SENDER_ADDRESS
,      SENDER_PROTOCOL
,      ORIGINAL_MSGID
,      ORIGINAL_QUEUE_NAME
,      ORIGINAL_QUEUE_OWNER
,      EXPIRATION_REASON
,      CONSUMER_NAME
,      ADDRESS
,      PROTOCOL
FROM APPLSYS.AQ$FND_CP_TM_AQTBL;

Dependencies

[top of page]

APPLSYS.AQ$FND_CP_TM_AQTBL references the following:

SchemaAPPLSYS
TableAQ$_FND_CP_TM_AQTBL_H
TableAQ$_FND_CP_TM_AQTBL_L
TableAQ$_FND_CP_TM_AQTBL_S
TableFND_CP_TM_AQTBL
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
SchemaSYSTEM
TYPEFND_CP_TM_AQ_PAYLOAD

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