[Home] [Help] [Dependency Information]
Object Name: | BSC_KPI_DEFAULTS_TL |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_KPI_DEFAULTS_TL |
Subobject Name: | |
Status: | VALID |
BSC_KPI_DEFAULTS_B stores translated information about indicator for information box.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_KPI_DEFAULTS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TAB_ID
INDICATOR LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAB_ID | NUMBER | (5) | Yes | Tab identifier |
INDICATOR | NUMBER | (5) | Yes | Indicator code |
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. |
ANALYSIS_OPTION0_NAME | VARCHAR2 | (255) | Default option name for analysis group 0 (max 30 chars) | |
ANALYSIS_OPTION1_NAME | VARCHAR2 | (255) | Default option name for analysis group 1 (max 30 chars) | |
ANALYSIS_OPTION2_NAME | VARCHAR2 | (255) | Default option name for analysis group 2 (max 30 chars) | |
PERIOD_NAME | VARCHAR2 | (90) | Actual period name | |
SERIES_NAME | VARCHAR2 | (255) | Default series name | |
DIM_LEVEL1_NAME | VARCHAR2 | (255) | Dimension level 1 name (max 80 chars) | |
DIM_LEVEL2_NAME | VARCHAR2 | (255) | Dimension level 2 name (max 80 chars) | |
DIM_LEVEL3_NAME | VARCHAR2 | (255) | Dimension level 3 name (max 80 chars) | |
DIM_LEVEL4_NAME | VARCHAR2 | (255) | Dimension level 4 name (max 80 chars) | |
DIM_LEVEL5_NAME | VARCHAR2 | (255) | Dimension level 5 name (max 80 chars) | |
DIM_LEVEL6_NAME | VARCHAR2 | (255) | Dimension level 6 name (max 80 chars) | |
DIM_LEVEL7_NAME | VARCHAR2 | (255) | Dimension level 7 name (max 80 chars) | |
DIM_LEVEL8_NAME | VARCHAR2 | (255) | Dimension level 8 name (max 80 chars) | |
DIM_LEVEL1_TEXT | VARCHAR2 | (240) | Dimension level 1 text value (max 80 chars) | |
DIM_LEVEL2_TEXT | VARCHAR2 | (240) | Dimension level 2 text value (max 80 chars) | |
DIM_LEVEL3_TEXT | VARCHAR2 | (240) | Dimension level 3 text value (max 80 chars) | |
DIM_LEVEL4_TEXT | VARCHAR2 | (240) | Dimension level 4 text value (max 80 chars) | |
DIM_LEVEL5_TEXT | VARCHAR2 | (240) | Dimension level 5 text value (max 80 chars) | |
DIM_LEVEL6_TEXT | VARCHAR2 | (240) | Dimension level 6 text value (max 80 chars) | |
DIM_LEVEL7_TEXT | VARCHAR2 | (240) | Dimension level 7 text value (max 80 chars) | |
DIM_LEVEL8_TEXT | VARCHAR2 | (240) | Dimension level 8 text value (max 80 chars) |
Cut, paste (and edit) the following text to query this object:
SELECT TAB_ID
, INDICATOR
, LANGUAGE
, SOURCE_LANG
, ANALYSIS_OPTION0_NAME
, ANALYSIS_OPTION1_NAME
, ANALYSIS_OPTION2_NAME
, PERIOD_NAME
, SERIES_NAME
, DIM_LEVEL1_NAME
, DIM_LEVEL2_NAME
, DIM_LEVEL3_NAME
, DIM_LEVEL4_NAME
, DIM_LEVEL5_NAME
, DIM_LEVEL6_NAME
, DIM_LEVEL7_NAME
, DIM_LEVEL8_NAME
, DIM_LEVEL1_TEXT
, DIM_LEVEL2_TEXT
, DIM_LEVEL3_TEXT
, DIM_LEVEL4_TEXT
, DIM_LEVEL5_TEXT
, DIM_LEVEL6_TEXT
, DIM_LEVEL7_TEXT
, DIM_LEVEL8_TEXT
FROM BSC.BSC_KPI_DEFAULTS_TL;
BSC.BSC_KPI_DEFAULTS_TL does not reference any database object
BSC.BSC_KPI_DEFAULTS_TL is referenced by following:
|
|
|