[Home] [Help] [Dependency Information]
Object Name: | AK_FOREIGN_KEYS_TL |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_FOREIGN_KEYS_TL |
Subobject Name: | |
Status: | VALID |
AK_FOREIGN_KEYS_TL stores translated information about the foreign
keys in AK_FOREIGN_KEYS. Each row includes the language the row is
translated to, the attributes for the foreign key and the foreign key
identifier which uniquely identifies the foreign key. You need one row
for each foreign key in 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_FOREIGN_KEYS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FOREIGN_KEY_NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Yes | Unique identifier for this foreign key relationship |
LANGUAGE | VARCHAR2 | (4) | Yes | The language code of the language which the translatable fields are translated to |
FROM_TO_NAME | VARCHAR2 | (45) | A user friendly name for the foreign key relationship | |
FROM_TO_DESCRIPTION | VARCHAR2 | (1500) | Description of the foreign key relationship | |
TO_FROM_NAME | VARCHAR2 | (45) | A user friendly name of the reverse foreign key relationship | |
TO_FROM_DESCRIPTION | VARCHAR2 | (1500) | Description of the reverse foreign key relationship | |
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 FOREIGN_KEY_NAME
, LANGUAGE
, FROM_TO_NAME
, FROM_TO_DESCRIPTION
, TO_FROM_NAME
, TO_FROM_DESCRIPTION
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM AK.AK_FOREIGN_KEYS_TL;
AK.AK_FOREIGN_KEYS_TL does not reference any database object
AK.AK_FOREIGN_KEYS_TL is referenced by following:
|
|
|