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]

TABLE: OKC.OKC_ACTION_ATTRIBUTES_B

Object Details

Object Name:	OKC_ACTION_ATTRIBUTES_B
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_ACTION_ATTRIBUTES_B
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_ACTION_ATTRIBUTES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	ID
OKC_ACTION_ATTRIBUTES_B_U3	NORMAL	UNIQUE	APPS_TS_SEED	ACN_ID ELEMENT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	System generated Unique Identifier.
AAL_ID	NUMBER			Unique identifier of the lookup for action attribute. Refers to ID in OKC_ACTION_ATT_LOOKUPS table.
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.
DATA_TYPE	VARCHAR2	(90)	Yes	Action attribute data type. Valid values Number, Date, Varchar2.
NAME	VARCHAR2	(150)
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.
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.
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.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
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.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
APPLICATION_ID	NUMBER			Owning Application Identifier
SEEDED_FLAG	VARCHAR2	(3)		Indicates whether a record is seeded data. Valid values are Y and N.
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 a list of values 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 the column NAME_COLUMN.
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. Valid values Y or N.

Query Text

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


SELECT ID
,      AAL_ID
,      ACN_ID
,      ELEMENT_NAME
,      DATA_TYPE
,      NAME
,      LIST_YN
,      VISIBLE_YN
,      DATE_OF_INTEREST_YN
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      FORMAT_MASK
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      APPLICATION_ID
,      SEEDED_FLAG
,      JTOT_OBJECT_CODE
,      NAME_COLUMN
,      DESCRIPTION_COLUMN
,      SOURCE_DOC_NUMBER_YN
FROM OKC.OKC_ACTION_ATTRIBUTES_B;

Dependencies

[top of page]

OKC.OKC_ACTION_ATTRIBUTES_B does not reference any database object

OKC.OKC_ACTION_ATTRIBUTES_B is referenced by following:

APPS: OKC_ACTION_ATTRIBUTES_B