eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKC_ACTION_ATTRIBUTES_V

Object Details

Object Name:	OKC_ACTION_ATTRIBUTES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_ACTION_ATTRIBUTES_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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.

Query Text

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;

Dependencies

[top of page]

APPS.OKC_ACTION_ATTRIBUTES_V references the following:

APPS: OKC_ACTION_ATTRIBUTES_B; OKC_ACTION_ATTRIBUTES_TL

APPS.OKC_ACTION_ATTRIBUTES_V is referenced by following:

APPS: CSC_CONDITION_EXPRESSION_V; CSC_CONDITION_LINE_DETAILS_V; OKC_AAE_PVT - show dependent code; OKC_AAE_PVT - show dependent code; OKC_AAV_PVT - show dependent code; OKC_ACTIONS_PVT - show dependent code; OKC_AQ_PVT - show dependent code; OKC_CEVT_ASMBLR_PVT - show dependent code; OKC_CNL_PVT - show dependent code; OKC_CONDITIONS_PVT - show dependent code; OKC_EXP_DATE_ASMBLR_PVT - show dependent code; OKC_FEP_PVT - show dependent code; OKC_OAT_PVT - show dependent code; OKC_QUERY - show dependent code; OKC_SCHR_AD_ASMBLR_PVT - show dependent code; OKC_SCHR_PD_ASMBLR_PVT - show dependent code