[Home] [Help] [Dependency Information]
Object Name: | OKC_OUTCOME_ARGUMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_OUTCOME_ARGUMENTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
ARGUMENT, actual values, supplied to an parameters for an invocation of an OUTCOME_DEF
may be supplied
a) in a hardcoded fashion, where a set number of values of ARGUMENT are supplied to any
invoked OUTCOME DEF by code
b) flexibly by user, where OUTCOME DEF PARAMETER may be defined by user and values of ARGUMENT as
i) literals
ii) rowid "looked up" (parameter would have to know table and column
(and perhaps filtering criteria) and the user looks up rowid
iii) a tokenised, named value which encodes a table and column, and the rowid (or at least
the filtering criteria) are known implicitly by the system (eg. "CONTRACT NUMBER"
means "this" or "current" contract number
a) is the current intended solution
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Primary key column. | |
PDP_ID | NUMBER | Yes | Foreign key to OKC_PROCESS_DEF_PARMS_B. | |
OCE_ID | NUMBER | Yes | Unique identifier of Outcome. Refers to ID in OKC_OUTCOMES_B. | |
AAE_ID | NUMBER | Unique identifier of Action Attribute. Refers to ID in OKC_ACTION_ATTRIBUTES_B. | ||
DNZ_CHR_ID | NUMBER | Contract ID. Denormalized for performance. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
VALUE | VARCHAR2 | (2000) | Parameter value. | |
APPLICATION_ID | NUMBER | Application Identifier | ||
SEEDED_FLAG | VARCHAR2 | (3) | Indicates whether a record is seeded. Valid values are Y or N. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, PDP_ID
, OCE_ID
, AAE_ID
, DNZ_CHR_ID
, OBJECT_VERSION_NUMBER
, VALUE
, APPLICATION_ID
, SEEDED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_OUTCOME_ARGUMENTS_V;
|
|
|