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

TABLE: APPLSYS.AQ$_WF_DEFERRED_H

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

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_173327
  1. ColumnMSGID
  2. ColumnSUBSCRIBER#
  3. ColumnNAME
  4. ColumnADDRESS#
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_173327 IOT - TOP UNIQUE TablespaceAPPS_TS_QUEUES ColumnMSGID
ColumnSUBSCRIBER#
ColumnNAME
ColumnADDRESS#
Columns
Name Datatype Length Mandatory Comments
MSGID RAW (16) Yes
SUBSCRIBER# NUMBER
Yes
NAME VARCHAR2 (30) Yes
ADDRESS# NUMBER
Yes
DEQUEUE_TIME TIMESTAMP(6) (11)
TRANSACTION_ID VARCHAR2 (30)
DEQUEUE_USER NUMBER

PROPAGATED_MSGID RAW (16)
RETRY_COUNT NUMBER

HINT ROWID (10)
SPARE RAW (16)
Query Text

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


SELECT MSGID
,      SUBSCRIBER#
,      NAME
,      ADDRESS#
,      DEQUEUE_TIME
,      TRANSACTION_ID
,      DEQUEUE_USER
,      PROPAGATED_MSGID
,      RETRY_COUNT
,      HINT
,      SPARE
FROM APPLSYS.AQ$_WF_DEFERRED_H;

Dependencies

[top of page]

APPLSYS.AQ$_WF_DEFERRED_H does not reference any database object

APPLSYS.AQ$_WF_DEFERRED_H is referenced by following:

SchemaAPPLSYS
ViewAQ$WF_DEFERRED
QueueAQ$_WF_DEFERRED_E
QueueWF_DEFERRED