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: XNP.AQ$_XNP_OUT_MSG_QTAB_H

Object Details

Object Name:	AQ$_XNP_OUT_MSG_QTAB_H
Object Type:	TABLE
Owner:	XNP
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:	0
PCT Used:	0

Primary Key: SYS_IOT_TOP_138072

MSGID
SUBSCRIBER#
NAME
ADDRESS#

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IOT_TOP_138072	IOT - TOP	UNIQUE	APPS_TS_QUEUES	MSGID SUBSCRIBER# NAME ADDRESS#

Columns

Name	Datatype	Length	Mandatory
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 XNP.AQ$_XNP_OUT_MSG_QTAB_H;

Dependencies

[top of page]

XNP.AQ$_XNP_OUT_MSG_QTAB_H does not reference any database object

XNP.AQ$_XNP_OUT_MSG_QTAB_H is referenced by following:

XNP: AQ$XNP_OUT_MSG_QTAB; AQ$_XNP_OUT_MSG_QTAB_E; XNP_OUT_MSG_EXCEPTION_Q; XNP_OUT_MSG_Q