[Home] [Help] [Dependency Information]
Object Name: | AK_OBJECT_ATTRIBUTES_TL |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_OBJECT_ATTRIBUTES_TL |
Subobject Name: | |
Status: | VALID |
AK_OBJECT_ATTRIBUTES_TL stores translated information about the object
attribute in AK_OBJECT_ATTRIBUTES. Each row includes the language the
row is translated to, the translated attributes of the object
attribute, and the object attribute identifier which uniquely
identifies the object attribute. You need one row for each object
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_OBJECT_ATTRIBUTES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DATABASE_OBJECT_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID LANGUAGE |
AK_OBJECT_ATTRIBUTES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | Database object identifier |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute identifier of a database object |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application id which the object attribute belong to |
LANGUAGE | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields are translated to |
ATTRIBUTE_LABEL_LONG | VARCHAR2 | (80) | Label/Prompt of object attribute | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | A short label/prompt of object attribute (this column is obsolete, do not use) | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields are translated to |
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 DATABASE_OBJECT_NAME
, ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, LANGUAGE
, ATTRIBUTE_LABEL_LONG
, ATTRIBUTE_LABEL_SHORT
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AK.AK_OBJECT_ATTRIBUTES_TL;
AK.AK_OBJECT_ATTRIBUTES_TL does not reference any database object
AK.AK_OBJECT_ATTRIBUTES_TL is referenced by following:
|
|
|