[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_DIM_LEVELS_TL |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_DIM_LEVELS_TL |
Subobject Name: | |
Status: | VALID |
BSC_SYS_DIM_LEVELS_TL stores translated information about the dimension levels such as dimension level identifier and dimension level name.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_DIM_LEVELS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DIM_LEVEL_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIM_LEVEL_ID | NUMBER | (5) | Yes | Dimension level identifier |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
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. |
NAME | VARCHAR2 | (255) | Yes | Dimension level name |
HELP | VARCHAR2 | (1024) | Yes | Dimension level help |
TOTAL_DISP_NAME | VARCHAR2 | (45) | Caption for TOTAL item | |
COMP_DISP_NAME | VARCHAR2 | (45) | Caption for COMPARISON item |
Cut, paste (and edit) the following text to query this object:
SELECT DIM_LEVEL_ID
, LANGUAGE
, SOURCE_LANG
, NAME
, HELP
, TOTAL_DISP_NAME
, COMP_DISP_NAME
FROM BSC.BSC_SYS_DIM_LEVELS_TL;
BSC.BSC_SYS_DIM_LEVELS_TL does not reference any database object
BSC.BSC_SYS_DIM_LEVELS_TL is referenced by following:
|
|
|