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: ONT.OE_ACTION_PRE_REQS

Object Details

Object Name:	OE_ACTION_PRE_REQS
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_ACTION_PRE_REQS
Subobject Name:
Status:	VALID

A temporary table used during the WF upgrade into R11i.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
CYCLE_ACTION_ID	NUMBER		Cycle Action id
ACTION_ID	NUMBER		Action Id
RESULT_ID	NUMBER		Result Id
GROUP_NUMBER	NUMBER		Group Number
INSTANCE_LABEL	VARCHAR2	(30)	Upgrade created instance label 1
INSTANCE_ID	NUMBER		Upgraded created instance id 1
INSTANCE_LABEL2	VARCHAR2	(30)	Upgrade created Instance label 2
INSTANCE_ID2	NUMBER		Upgrade created instance id 2
CYCLE_ID	NUMBER		cycle id
TYPE	VARCHAR2	(30)	Denotes Header or Line level
LINE_TYPE	VARCHAR2	(10)	Denotes Regular / Return / ATO

Query Text

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


SELECT CYCLE_ACTION_ID
,      ACTION_ID
,      RESULT_ID
,      GROUP_NUMBER
,      INSTANCE_LABEL
,      INSTANCE_ID
,      INSTANCE_LABEL2
,      INSTANCE_ID2
,      CYCLE_ID
,      TYPE
,      LINE_TYPE
FROM ONT.OE_ACTION_PRE_REQS;

Dependencies

[top of page]

ONT.OE_ACTION_PRE_REQS does not reference any database object

ONT.OE_ACTION_PRE_REQS is referenced by following:

APPS: OE_ACTION_PRE_REQS