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


TABLE: APPLSYS.WF_SMTP_O_1_TABLE

Object Details
Object Name: WF_SMTP_O_1_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_C00233902
  1. ColumnMSGID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00233902 NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnMSGID
SYS_IL0000465216C00029$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000465216C00030$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
AQ$_WF_SMTP_O_1_TABLE_I NORMAL NONUNIQUE TablespaceAPPS_TS_TX_DATA ColumnQ_NAME
ColumnSTATE
ColumnPRIORITY
ColumnENQ_TIME
ColumnSTEP_NO
ColumnCHAIN_NO
ColumnLOCAL_ORDER_NO
AQ$_WF_SMTP_O_1_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 VARCHAR2 (30)
ENQ_TID VARCHAR2 (30)
DEQ_TIME TIMESTAMP(6) (11)
DEQ_UID VARCHAR2 (30)
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 WF_MESSAGE_PAYLOAD_T (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.WF_SMTP_O_1_TABLE;

Dependencies

[top of page]

APPLSYS.WF_SMTP_O_1_TABLE references the following:

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

SchemaAPPLSYS
ViewAQ$WF_SMTP_O_1_TABLE
QueueAQ$_WF_SMTP_O_1_TABLE_E
ViewAQ$_WF_SMTP_O_1_TABLE_F
QueueWF_SMTP_O_1_QUEUE
SchemaAPPS
SynonymWF_SMTP_O_1_TABLE