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

TABLE: APPLSYS.AQ$_WF_WS_JMS_IN_I

Object Details
Object Name: AQ$_WF_WS_JMS_IN_I
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_332799
  1. ColumnSUBSCRIBER#
  2. ColumnNAME
  3. ColumnQUEUE#
  4. ColumnMSG_PRIORITY
  5. ColumnMSG_ENQ_TIME
  6. ColumnMSG_STEP_NO
  7. ColumnMSG_CHAIN_NO
  8. ColumnMSG_LOCAL_ORDER_NO
  9. ColumnMSGID
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_332799 IOT - TOP UNIQUE TablespaceAPPS_TS_QUEUES ColumnSUBSCRIBER#
ColumnNAME
ColumnQUEUE#
ColumnMSG_PRIORITY
ColumnMSG_ENQ_TIME
ColumnMSG_STEP_NO
ColumnMSG_CHAIN_NO
ColumnMSG_LOCAL_ORDER_NO
ColumnMSGID
Columns
Name Datatype Length Mandatory Comments
SUBSCRIBER# NUMBER
Yes
NAME VARCHAR2 (30) Yes
QUEUE# NUMBER
Yes
MSG_PRIORITY NUMBER
Yes
MSG_ENQ_TIME TIMESTAMP(6) (11) Yes
MSG_STEP_NO NUMBER
Yes
MSG_CHAIN_NO NUMBER
Yes
MSG_LOCAL_ORDER_NO NUMBER
Yes
MSGID RAW (16) Yes
HINT ROWID (10)
SPARE RAW (16)
Query Text

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


SELECT SUBSCRIBER#
,      NAME
,      QUEUE#
,      MSG_PRIORITY
,      MSG_ENQ_TIME
,      MSG_STEP_NO
,      MSG_CHAIN_NO
,      MSG_LOCAL_ORDER_NO
,      MSGID
,      HINT
,      SPARE
FROM APPLSYS.AQ$_WF_WS_JMS_IN_I;

Dependencies

[top of page]

APPLSYS.AQ$_WF_WS_JMS_IN_I does not reference any database object

APPLSYS.AQ$_WF_WS_JMS_IN_I is referenced by following:

SchemaAPPLSYS
QueueAQ$_WF_WS_JMS_IN_E
ViewAQ$_WF_WS_JMS_IN_F
QueueWF_WS_JMS_IN