[Home] [Help] [Dependency Information]
Object Name: | FND_FLEX_HIERARCHIES_TL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_FLEX_HIERARCHIES_TL |
Subobject Name: | |
Status: | VALID |
FND_FLEX_HIERARCHIES_TL stores translated information about
flexfield hierarchies. Each row includes a value set identifier,
a hierarchy identifier, and a hierarchy name. Each row also
includes a language code indicating what language the information
is in. You need one row for each flexfield hierarchy in each of
the installed languages.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_FLEX_HIERARCHIES_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
FLEX_VALUE_SET_ID
HIERARCHY_ID LANGUAGE |
FND_FLEX_HIERARCHIES_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
FLEX_VALUE_SET_ID
HIERARCHY_NAME LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FLEX_VALUE_SET_ID | NUMBER | (10) | Yes | Flexfield value set identifier |
HIERARCHY_ID | NUMBER | (10) | Yes | Hierarchy identifier |
HIERARCHY_NAME | VARCHAR2 | (30) | Yes | Hierarchy name |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (10) | Standard Who column | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
Cut, paste (and edit) the following text to query this object:
SELECT FLEX_VALUE_SET_ID
, HIERARCHY_ID
, HIERARCHY_NAME
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTION
, SOURCE_LANG
FROM APPLSYS.FND_FLEX_HIERARCHIES_TL;
APPLSYS.FND_FLEX_HIERARCHIES_TL does not reference any database object
APPLSYS.FND_FLEX_HIERARCHIES_TL is referenced by following:
|
|
|