[Home] [Help] [Dependency Information]
Object Name: | BSC_KPI_DIM_LEVELS_TL |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_KPI_DIM_LEVELS_TL |
Subobject Name: | |
Status: | VALID |
BSC_KPI_DIM_LEVELS_TL stores translated information about dimension levesl.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_KPI_DIM_LEVELS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INDICATOR
DIM_SET_ID DIM_LEVEL_INDEX LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDICATOR | NUMBER | (5) | Yes | Indicator code |
DIM_SET_ID | NUMBER | (3) | Yes | Dimension set identifier |
DIM_LEVEL_INDEX | NUMBER | (3) | Yes | Dimension level index |
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 (max 30 chars) |
HELP | VARCHAR2 | (1024) | Yes | Dimension level help (max 80 chars) |
TOTAL_DISP_NAME | VARCHAR2 | (45) | Caption for TOTAL item (max 15 chars) | |
COMP_DISP_NAME | VARCHAR2 | (45) | Caption for COMPARISON item (max 15 chars) |
Cut, paste (and edit) the following text to query this object:
SELECT INDICATOR
, DIM_SET_ID
, DIM_LEVEL_INDEX
, LANGUAGE
, SOURCE_LANG
, NAME
, HELP
, TOTAL_DISP_NAME
, COMP_DISP_NAME
FROM BSC.BSC_KPI_DIM_LEVELS_TL;
BSC.BSC_KPI_DIM_LEVELS_TL does not reference any database object
BSC.BSC_KPI_DIM_LEVELS_TL is referenced by following:
|
|
|