[Home] [Help] [Dependency Information]
Object Name: | AK_REGIONS_TL |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_REGIONS_TL |
Subobject Name: | |
Status: | VALID |
AK_REGIONS_TL stores translated information about the regions in
AK_REGIONS. Each row includes the language the row is translated to,
the translated attributes of the region, and the region identifier
which uniquely identifies the region. You need one row for each region
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_REGIONS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REGION_CODE
REGION_APPLICATION_ID LANGUAGE |
AK_REGIONS_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
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 |
LANGUAGE | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields are translated to |
NAME | VARCHAR2 | (80) | Yes | Friendly user name of region |
DESCRIPTION | VARCHAR2 | (2000) | Description of region | |
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 REGION_CODE
, REGION_APPLICATION_ID
, LANGUAGE
, NAME
, DESCRIPTION
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AK.AK_REGIONS_TL;
AK.AK_REGIONS_TL does not reference any database object
AK.AK_REGIONS_TL is referenced by following:
|
|
|