[Home] [Help] [Dependency Information]
Object Name: | AK_ATTRIBUTES_TL |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_ATTRIBUTES_TL |
Subobject Name: | |
Status: | VALID |
AK_ATTRIBUTES_TL stores translated information about the attributes
in AK_ATTRIBUTES. Each row includes the language the row is
translated to, the name, description, and label of the attribute, and
the attribute identifier which uniquely identifies the attribute. You
need one row for each attribute in each of the installed languages.
Each row includes a language and SOURCE_LANG column which can be used
to determine if a value has been translated or defaulted.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AK_ATTRIBUTES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID LANGUAGE |
AK_ATTRIBUTES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_LABEL_LONG |
AK_ATTRIBUTES_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_LABEL_SHORT |
AK_ATTRIBUTES_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
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 |
LANGUAGE | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (80) | Yes | Name of the attribute |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | Label/Prompt of attribute | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (40) | A short label/prompt of attribute (this column is obsolete, do not use) | |
DESCRIPTION | VARCHAR2 | (2000) | Description of attribute | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the language which the values of the translatable columns were originally entered |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, LANGUAGE
, NAME
, ATTRIBUTE_LABEL_LONG
, ATTRIBUTE_LABEL_SHORT
, DESCRIPTION
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AK.AK_ATTRIBUTES_TL;
AK.AK_ATTRIBUTES_TL does not reference any database object
AK.AK_ATTRIBUTES_TL is referenced by following:
|
|
|