DBA Data[Home] [Help] [Dependency Information]

TABLE: OE.SO_ACTION_PRE_REQS

Object Details
Object Name: SO_ACTION_PRE_REQS
Object Type: TABLE
Owner: OE
FND Design Data: TableOE.SO_ACTION_PRE_REQS
Subobject Name:
Status: VALID


SO_ACTION_PRE_REQS stores the action/result prerequisites that must
occur before a cycle action can take place. The column
GROUP_NUMBER stores user-assigned numbers for your action/result
prerequisites; prerequisites sharing the same number must all be met
(that is, these prerequisites are AND'ed), while those with different
numbers can be optionally met (that is, these prerequisites are
OR'ed).


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SO_ACTION_PRE_REQS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCYCLE_ACTION_ID
ColumnRESULT_ID
ColumnACTION_ID
ColumnGROUP_NUMBER
Columns
Name Datatype Length Mandatory Comments
CYCLE_ACTION_ID NUMBER
Yes Cycle action combination to which this pre-requisite corresponds
RESULT_ID NUMBER
Yes System-generated identifier of cycle result
ACTION_ID NUMBER
Yes System-generated identifier of cycle action
GROUP_NUMBER NUMBER
Yes Identifies this pre-requisites relationship to other pre-requisites for the same cycle action
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT CYCLE_ACTION_ID
,      RESULT_ID
,      ACTION_ID
,      GROUP_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OE.SO_ACTION_PRE_REQS;

Dependencies

[top of page]

OE.SO_ACTION_PRE_REQS does not reference any database object

OE.SO_ACTION_PRE_REQS is referenced by following:

SchemaAPPS
SynonymSO_ACTION_PRE_REQS