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


TABLE: APPLSYS.ECX_IN_OAG_Q_TABLE

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: SYS_C00219661
  1. ColumnMSGID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00219661 NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnMSGID
SYS_IL0000412611C00031$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
AQ$_ECX_IN_OAG_Q_TABLE_I NORMAL NONUNIQUE TablespaceAPPS_TS_TX_DATA ColumnQ_NAME
ColumnSTATE
ColumnENQ_TIME
ColumnSTEP_NO
ColumnCHAIN_NO
ColumnLOCAL_ORDER_NO
AQ$_ECX_IN_OAG_Q_TABLE_T NORMAL NONUNIQUE TablespaceAPPS_TS_TX_DATA ColumnTIME_MANAGER_INFO
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 ECX_INENGOBJ (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.ECX_IN_OAG_Q_TABLE;

Dependencies

[top of page]

APPLSYS.ECX_IN_OAG_Q_TABLE references the following:

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

SchemaAPPLSYS
ViewAQ$ECX_IN_OAG_Q_TABLE
QueueAQ$_ECX_IN_OAG_Q_TABLE_E
ViewAQ$_ECX_IN_OAG_Q_TABLE_F
QueueECX_IN_OAG_Q
SchemaAPPS
SynonymECX_IN_OAG_Q_TABLE