[Home] [Help] [Dependency Information]
Object Name: | SO_ACTION_PRE_REQS |
---|---|
Object Type: | TABLE |
Owner: | OE |
FND Design Data: | OE.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).
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SO_ACTION_PRE_REQS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
CYCLE_ACTION_ID
RESULT_ID ACTION_ID GROUP_NUMBER |
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 |
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;
OE.SO_ACTION_PRE_REQS does not reference any database object
OE.SO_ACTION_PRE_REQS is referenced by following:
|
|
|