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

TABLE: OKC.OKC_OUTCOME_ARGUMENTS

Object Details
Object Name: OKC_OUTCOME_ARGUMENTS
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_OUTCOME_ARGUMENTS
Subobject Name:
Status: VALID


The values to pass to a PROCESS DEFINITION PARAMETER when a CONDITION evaluates to true.
The value to pass may be hardcoded by the user when the CONDITION is defined, e.g. always set the priority of the service request to "Medium". O r the value may be supplied by a specified ACTION ATTRIBUTE, e.g. party_id.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_OUTCOME_ARGUMENTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
ColumnZD_EDITION_NAME
OKC_OUTCOME_ARGUMENTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOCE_ID
ColumnPDP_ID
ColumnZD_EDITION_NAME
OKC_OUTCOME_ARGUMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDNZ_CHR_ID
OKC_OUTCOME_ARGUMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPDP_ID
OKC_OUTCOME_ARGUMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAAE_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes System generated Unique Identifier.
OCE_ID NUMBER
Yes Unique identifier of Outcome. Refers to ID in OKC_OUTCOMES_B.
PDP_ID NUMBER
Yes Unique identifier of Process Definition Parameter. Refers to ID in OKC_PROCESS_DEF_PARMS_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.
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.
VALUE VARCHAR2 (2000)
Parameter value
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
APPLICATION_ID NUMBER

Application Identifier
SEEDED_FLAG VARCHAR2 (3)
Indicates whether a record is seeded data
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT ID
,      OCE_ID
,      PDP_ID
,      AAE_ID
,      DNZ_CHR_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      VALUE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      APPLICATION_ID
,      SEEDED_FLAG
,      ZD_EDITION_NAME
FROM OKC.OKC_OUTCOME_ARGUMENTS;

Dependencies

[top of page]

OKC.OKC_OUTCOME_ARGUMENTS does not reference any database object

OKC.OKC_OUTCOME_ARGUMENTS is referenced by following:

SchemaOKC
ViewOKC_OUTCOME_ARGUMENTS#