[Home] [Help] [Dependency Information]
Object Name: | AK_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
AK_ATTRIBUTES contains information about the attributes you define.
You need one row for each attribute.
Each attribute has a name, an application that owns the attribute,
formatting properties, a default value, a prompt, and a data type
(i.e., Number, Varchar2, Date, etc.).
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AK_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
AK_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application ID which the attribute belongs to |
ATTRIBUTE_LABEL_LENGTH | NUMBER | (15) | Number of characters to be displayed for the attribute label | |
ATTRIBUTE_VALUE_LENGTH | NUMBER | (15) | Number of characters to be displayed for the attribute value | |
BOLD | VARCHAR2 | (1) | Yes | Bold flag ('Y' - Bold the attribute value, 'N' - Do not bold the attribute value) |
ITALIC | VARCHAR2 | (1) | Yes | Italic flag ('Y' - Italicize the attribute value, 'N' - Do not italicize the attribute value) |
VERTICAL_ALIGNMENT | VARCHAR2 | (30) | Yes | Vertical Alignment for attribute |
HORIZONTAL_ALIGNMENT | VARCHAR2 | (30) | Yes | Horizontal alignment for attribute |
DATA_TYPE | VARCHAR2 | (30) | Yes | Data type of attribute |
UPPER_CASE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the attribute should be in upper case ('Y' - upper case, 'N' - not upper case) | |
DEFAULT_VALUE_VARCHAR2 | VARCHAR2 | (240) | Default value of attribute when the data type of the attribute is VARCHAR | |
DEFAULT_VALUE_NUMBER | NUMBER | (15) | Default value of attribute when the data type of the attribute is NUMBER | |
DEFAULT_VALUE_DATE | DATE | Default value of attribute when the data type of the attribute is DATE or DATETIME | ||
LOV_REGION_CODE | VARCHAR2 | (30) | LOV Region identifier | |
LOV_REGION_APPLICATION_ID | NUMBER | (15) | Product team's application ID which the LOV Region belongs to | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
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) | Yes | Standard Who Column |
ITEM_STYLE | VARCHAR2 | (30) | Yes | Type of HTML User Interface object that will be use to represent this data. |
DISPLAY_HEIGHT | NUMBER | If this item is a text area then this property defines the vertical number of lines for that text. | ||
CSS_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet class name to apply to the label of a data item or the static text that will be displayed on a page. | |
POPLIST_VIEWOBJECT | VARCHAR2 | (240) | If this attribute is of item style poplist then this property defines the view object source for the list of possible values for the poplist. | |
POPLIST_DISPLAY_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object source for the list of possible display values for the poplist that user can choose from. | |
POPLIST_VALUE_ATTRIBUTE | VARCHAR2 | (80) | If this attribute is of item style poplist then this property defines the view object source for the list of possible returned values for the poplist that user can choose from. | |
CSS_LABEL_CLASS_NAME | VARCHAR2 | (80) | The cascading style sheet label class name to apply to the value of a data item that will be displayed on a page. | |
EXPANSION | NUMBER | (15) | EXPANSION | |
ALS_MAX_LENGTH | NUMBER | (15) | Maximum length of Short Label | |
PRECISION | NUMBER | (15) | precision of data column when the data type is a number. |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_LABEL_LENGTH
, ATTRIBUTE_VALUE_LENGTH
, BOLD
, ITALIC
, VERTICAL_ALIGNMENT
, HORIZONTAL_ALIGNMENT
, DATA_TYPE
, UPPER_CASE_FLAG
, DEFAULT_VALUE_VARCHAR2
, DEFAULT_VALUE_NUMBER
, DEFAULT_VALUE_DATE
, LOV_REGION_CODE
, LOV_REGION_APPLICATION_ID
, 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
, ITEM_STYLE
, DISPLAY_HEIGHT
, CSS_CLASS_NAME
, POPLIST_VIEWOBJECT
, POPLIST_DISPLAY_ATTRIBUTE
, POPLIST_VALUE_ATTRIBUTE
, CSS_LABEL_CLASS_NAME
, EXPANSION
, ALS_MAX_LENGTH
, PRECISION
FROM AK.AK_ATTRIBUTES;
AK.AK_ATTRIBUTES does not reference any database object
AK.AK_ATTRIBUTES is referenced by following:
|
|
|