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: ASO.AQ$_ASO_ORDER_FEEDBACK_T_I

Object Details

Object Name:	AQ$_ASO_ORDER_FEEDBACK_T_I
Object Type:	TABLE
Owner:	ASO
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:	0
PCT Used:	0

Primary Key: SYS_IOT_TOP_81805

SUBSCRIBER#
NAME
QUEUE#
MSG_ENQ_TIME
MSG_STEP_NO
MSG_CHAIN_NO
MSG_LOCAL_ORDER_NO
MSGID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IOT_TOP_81805	IOT - TOP	UNIQUE	APPS_TS_QUEUES	SUBSCRIBER# NAME QUEUE# 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_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_ENQ_TIME
,      MSG_STEP_NO
,      MSG_CHAIN_NO
,      MSG_LOCAL_ORDER_NO
,      MSGID
,      HINT
,      SPARE
FROM ASO.AQ$_ASO_ORDER_FEEDBACK_T_I;

Dependencies

[top of page]

ASO.AQ$_ASO_ORDER_FEEDBACK_T_I does not reference any database object

ASO.AQ$_ASO_ORDER_FEEDBACK_T_I is referenced by following:

APPS: AQ$_ASO_ORDER_FEEDBACK_T_I
ASO: AQ$_ASO_ORDER_FEEDBACK_T_E; AQ$_ASO_ORDER_FEEDBACK_T_F; ASO_OF_EXCP_Q; ASO_OF_EXCP_Q_E; ASO_OF_Q; ASO_OF_Q_E