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


TABLE: APPLSYS.FND_CP_GSM_OPP_AQTBL

Object Details
Object Name: FND_CP_GSM_OPP_AQTBL
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: SYS_C00219681
  1. ColumnMSGID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00219681 NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnMSGID
SYS_IL0000412710C00033$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
Q_NAME VARCHAR2 (30)
MSGID RAW (16) Yes
CORRID VARCHAR2 (128)
PRIORITY NUMBER

STATE NUMBER

DELAY TIMESTAMP(6) (11)
EXPIRATION NUMBER

TIME_MANAGER_INFO TIMESTAMP(6) (11)
LOCAL_ORDER_NO NUMBER

CHAIN_NO NUMBER

CSCN NUMBER

DSCN NUMBER

ENQ_TIME TIMESTAMP(6) (11)
ENQ_UID NUMBER

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

DEQ_TID VARCHAR2 (30)
RETRY_COUNT NUMBER

EXCEPTION_QSCHEMA VARCHAR2 (30)
EXCEPTION_QUEUE VARCHAR2 (30)
STEP_NO NUMBER

RECIPIENT_KEY NUMBER

DEQUEUE_MSGID RAW (16)
SENDER_NAME VARCHAR2 (30)
SENDER_ADDRESS VARCHAR2 (1024)
SENDER_PROTOCOL NUMBER

USER_DATA FND_CP_GSM_OPP_AQ_PAYLOAD (1)
USER_PROP ANYDATA (3752)
Query Text

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


SELECT Q_NAME
,      MSGID
,      CORRID
,      PRIORITY
,      STATE
,      DELAY
,      EXPIRATION
,      TIME_MANAGER_INFO
,      LOCAL_ORDER_NO
,      CHAIN_NO
,      CSCN
,      DSCN
,      ENQ_TIME
,      ENQ_UID
,      ENQ_TID
,      DEQ_TIME
,      DEQ_UID
,      DEQ_TID
,      RETRY_COUNT
,      EXCEPTION_QSCHEMA
,      EXCEPTION_QUEUE
,      STEP_NO
,      RECIPIENT_KEY
,      DEQUEUE_MSGID
,      SENDER_NAME
,      SENDER_ADDRESS
,      SENDER_PROTOCOL
,      USER_DATA
,      USER_PROP
FROM APPLSYS.FND_CP_GSM_OPP_AQTBL;

Dependencies

[top of page]

APPLSYS.FND_CP_GSM_OPP_AQTBL references the following:

SchemaSYS
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code
SchemaSYSTEM
TYPEFND_CP_GSM_OPP_AQ_PAYLOAD
APPLSYS.FND_CP_GSM_OPP_AQTBL is referenced by following:

SchemaAPPLSYS
ViewAQ$FND_CP_GSM_OPP_AQTBL
QueueAQ$_FND_CP_GSM_OPP_AQTBL_E
ViewAQ$_FND_CP_GSM_OPP_AQTBL_F
EVALUATION CONTEXTAQ$_FND_CP_GSM_OPP_AQTBL_V
QueueFND_CP_GSM_OPP_AQ