[Home] [Help] [Dependency Information]
Object Name: | HR_KI_HIERARCHIES_TL |
---|---|
Object Type: | TABLE |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
The hierarchy will be labeled with a name / description, which is translatable, this table will hold the these tranlatable values.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_KI_HIERARCHIES_TL_PK | NORMAL | UNIQUE | APPS_TS_SEED |
HIERARCHY_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_ID | NUMBER | (15) | Yes | Hierarchy identifier |
NAME | VARCHAR2 | (80) | Yes | Name of Hierarchy |
DESCRIPTION | VARCHAR2 | (240) | Description of Hierarchy | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
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 |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_ID
, NAME
, DESCRIPTION
, LANGUAGE
, SOURCE_LANG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.HR_KI_HIERARCHIES_TL;
HR.HR_KI_HIERARCHIES_TL does not reference any database object
HR.HR_KI_HIERARCHIES_TL is referenced by following:
|
|
|