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


TABLE: APPLSYS.WF_WS_JMS_IN

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

Storage Details
Tablespace: TablespaceAPPS_TS_QUEUES
PCT Free: 10
PCT Used:
Primary Key: SYS_C00169350
  1. ColumnMSGID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00169350 NORMAL UNIQUE TablespaceAPPS_TS_QUEUES ColumnMSGID
SYS_IL0000332751C00037$$ LOB UNIQUE TablespaceAPPS_TS_QUEUES
SYS_IL0000332751C00040$$ LOB UNIQUE TablespaceAPPS_TS_QUEUES
SYS_IL0000332751C00041$$ LOB UNIQUE TablespaceAPPS_TS_QUEUES
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 AQ$_JMS_TEXT_MESSAGE (1)
USER_PROP ANYDATA (3748)
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_WS_JMS_IN;

Dependencies

[top of page]

APPLSYS.WF_WS_JMS_IN references the following:

SchemaSYS
TYPEANYDATA
TYPEAQ$_JMS_TEXT_MESSAGE
TYPEAQ$_JMS_USERPROPARRAY
TYPEAQ$_JMS_USERPROPERTY
PL/SQL PackageSTANDARD - show dependent code
APPLSYS.WF_WS_JMS_IN is referenced by following:

SchemaAPPLSYS
ViewAQ$WF_WS_JMS_IN
QueueAQ$_WF_WS_JMS_IN_E
ViewAQ$_WF_WS_JMS_IN_F
EVALUATION CONTEXTAQ$_WF_WS_JMS_IN_V
QueueWF_WS_JMS_IN
RULEWF_WS_JMS_IN$1
SchemaAPPS
SynonymWF_WS_JMS_IN