eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.AQ$_WF_JMS_IN_I

Object Details

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

Storage Details

Tablespace:
PCT Free:	0
PCT Used:	0

Primary Key: SYS_IOT_TOP_245532

SUBSCRIBER#
NAME
QUEUE#
MSG_PRIORITY
MSG_ENQ_TIME
MSG_STEP_NO
MSG_CHAIN_NO
MSG_LOCAL_ORDER_NO
MSGID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IOT_TOP_245532	IOT - TOP	UNIQUE	APPS_TS_QUEUES	SUBSCRIBER# NAME QUEUE# MSG_PRIORITY MSG_ENQ_TIME MSG_STEP_NO MSG_CHAIN_NO MSG_LOCAL_ORDER_NO MSGID

Columns

Name	Datatype	Length	Mandatory
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_JMS_IN_I;

Dependencies

[top of page]

APPLSYS.AQ$_WF_JMS_IN_I does not reference any database object

APPLSYS.AQ$_WF_JMS_IN_I is referenced by following:

APPLSYS: AQ$_WF_JMS_IN_E; AQ$_WF_JMS_IN_F; WF_JMS_IN