[Home] [Help] [Dependency Information]
Object Name: | AK_REGION_ITEMS_TL |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_REGION_ITEMS_TL |
Subobject Name: | |
Status: | VALID |
AK_REGION_ITEMS_TL stores translated information about the region
items in AK_REGION_ITEMS. Each row includes the language the row is
translated to, the translated attributes of the region item, the
region identifier which uniquely identifies the region item and the
region items label. You need one row for each region item 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_REGION_ITEMS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID LANGUAGE ZD_EDITION_NAME |
AK_REGION_ITEMS_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REGION_CODE | VARCHAR2 | (30) | Yes | Region identifier |
REGION_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application id which the region belong to |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute identifier |
ATTRIBUTE_APPLICATION_ID | NUMBER | (15) | Yes | Product team's application ID which the 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 for this region item | |
ATTRIBUTE_LABEL_SHORT | VARCHAR2 | (30) | A short label/prompt for this region item (this column is obsolete, do not use) | |
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 |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT REGION_CODE
, REGION_APPLICATION_ID
, 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
, DESCRIPTION
, ZD_EDITION_NAME
FROM AK.AK_REGION_ITEMS_TL;
AK.AK_REGION_ITEMS_TL does not reference any database object
AK.AK_REGION_ITEMS_TL is referenced by following:
|
|
|