[Home] [Help] [Dependency Information]
Object Name: | AQ$_FND_CP_GSM_OPP_AQTBL_F |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
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_GSM_OPP_AQ_PAYLOAD | (2328) | ||
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 |
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_GSM_OPP_AQTBL_F;
APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_F is not referenced by any database object
|
|
|