[Home] [Help] [Dependency Information]
Object Name: | OKC_ACTION_ATTRIBUTES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_ACTION_ATTRIBUTES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Action Attributes are data items describing an Action (OKC_ACTIONS_B). Please see OKC_ACTIONS_B for a description of the ACTION -> CONDITION -> OUTCOME process.
These Attributes can be used as left operands in Condition Lines (OKC_CO NDITION_LINES_B). They may be used to represent parameter values to be passed to an Outcome (OKC_OUTCOME_ARGUMENTS) when that Outcome is initiated due to a Condition based on the Action evaluating to true.
The Action Attributes for a contract signing Action might include the contract id, contract number, contract number modifier, and contract signing date while those for a counter update Action might include the counter id, current reading, etc.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id from the base table OKC_ACTION_ATTRIBUTES_B. | |
ID | NUMBER | Yes | Primary key column. | |
AAL_ID | NUMBER | Unique identifier of the lookup for action attribute. Refers to ID in OKC_ACTION_ATT_LOOKUPS table. | ||
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. |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Indicates a value was changed in another language. Not fully implemented in 11i |
ACN_ID | NUMBER | Yes | Unique identifier of action for action attribute. Refers to ID in OKC_ACTIONS_B table. | |
ELEMENT_NAME | VARCHAR2 | (150) | Yes | Action attribute code. Unique for a given action. |
NAME | VARCHAR2 | (150) | Yes | Action attribute name. |
DESCRIPTION | VARCHAR2 | (1995) | Action attribute description. | |
DATA_TYPE | VARCHAR2 | (90) | Yes | Action attribute data type. |
LIST_YN | VARCHAR2 | (3) | Yes | Indicates that the attribute will have a List of Values when used in Conditions Form. Valid values Y or N. |
VISIBLE_YN | VARCHAR2 | (3) | Yes | Indicates that the action attribute will be visible in the Conditions Form or is being used for internal processing. Valid values Y or N. |
DATE_OF_INTEREST_YN | VARCHAR2 | (3) | Yes | Applicable for date datatype action attributes. Indicates that this date attribute is nominated as the key date for the given action. For example in contract signed action, the contract signed date is the �date of interest�. This date will be stored as the �last occurrence date� for all conditions that are based on �contract signed� action. Valid values Y or N. |
FORMAT_MASK | VARCHAR2 | (60) | The standard Format masks for attributes of date and numeric data-types. | |
MINIMUM_VALUE | VARCHAR2 | (150) | Minimum allowable value of the attribute. | |
MAXIMUM_VALUE | VARCHAR2 | (150) | Maximum allowable value of the attribute. | |
APPLICATION_ID | NUMBER | Application Identifier | ||
SEEDED_FLAG | VARCHAR2 | (3) | Indicates whether a record is seeded data. Valid values are Y and N. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
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. | |
JTOT_OBJECT_CODE | VARCHAR2 | (30) | Indicates the source from which the value for the action attribute is obtained. Used in conjunction with column_name and description columns to build an lov to provide database values for the attribute. Refers to OBJECT_CODE in JTF_OBJECTS_B. | |
NAME_COLUMN | VARCHAR2 | (30) | Column used to build list of values based on source object column JTOT_OBJECT_CODE | |
DESCRIPTION_COLUMN | VARCHAR2 | (30) | Column used in list of values to help identify value of column column_name. | |
SOURCE_DOC_NUMBER_YN | VARCHAR2 | (3) | Indicates whether the column indicated by the NAME_COLUMN will be used as the source document when the associated task is displayed in Task Manager. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, AAL_ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, ACN_ID
, ELEMENT_NAME
, NAME
, DESCRIPTION
, DATA_TYPE
, LIST_YN
, VISIBLE_YN
, DATE_OF_INTEREST_YN
, FORMAT_MASK
, MINIMUM_VALUE
, MAXIMUM_VALUE
, APPLICATION_ID
, SEEDED_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, JTOT_OBJECT_CODE
, NAME_COLUMN
, DESCRIPTION_COLUMN
, SOURCE_DOC_NUMBER_YN
FROM APPS.OKC_ACTION_ATTRIBUTES_V;
|
|
|