[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | 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 |
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;
ONT.OE_ACTION_PRE_REQS does not reference any database object
ONT.OE_ACTION_PRE_REQS is referenced by following:
|
|
|