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_NOTIFICATION_IN_H

Object Details

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

Storage Details

Tablespace:
PCT Free:	0
PCT Used:	0

Primary Key: SYS_IOT_TOP_245597

MSGID
SUBSCRIBER#
NAME
ADDRESS#

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IOT_TOP_245597	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 APPLSYS.AQ$_WF_NOTIFICATION_IN_H;

Dependencies

[top of page]

APPLSYS.AQ$_WF_NOTIFICATION_IN_H does not reference any database object

APPLSYS.AQ$_WF_NOTIFICATION_IN_H is referenced by following:

APPLSYS: AQ$WF_NOTIFICATION_IN; AQ$_WF_NOTIFICATION_IN_E; WF_NOTIFICATION_IN