[Home] [Help] [Dependency Information]
Object Name: | BSC_KPI_DIM_LEVELS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BSC.BSC_KPI_DIM_LEVELS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
BSC_KPI_DIM_LEVELS_VL is a view that joins the translated, language specific values from BSC_KPI_DIM_LEVELS_TL with the non-displayed data from BSC_KPI_DIM_LEVELS_B . BSC uses this view to display translated information in languages installed at your site.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDICATOR | NUMBER | (5) | Yes | |
DIM_SET_ID | NUMBER | (3) | Yes | |
DIM_LEVEL_INDEX | NUMBER | (3) | Yes | |
NAME | VARCHAR2 | (255) | Yes | |
HELP | VARCHAR2 | (1024) | Yes | |
TOTAL_DISP_NAME | VARCHAR2 | (45) | ||
COMP_DISP_NAME | VARCHAR2 | (45) | ||
LEVEL_TABLE_NAME | VARCHAR2 | (30) | Yes | |
LEVEL_VIEW_NAME | VARCHAR2 | (30) | ||
FILTER_COLUMN | VARCHAR2 | (30) | ||
FILTER_VALUE | NUMBER | (5) | ||
DEFAULT_VALUE | VARCHAR2 | (2) | ||
DEFAULT_TYPE | NUMBER | (5) | ||
VALUE_ORDER_BY | NUMBER | (5) | Yes | |
COMP_ORDER_BY | NUMBER | (5) | Yes | |
LEVEL_PK_COL | VARCHAR2 | (30) | Yes | |
PARENT_LEVEL_INDEX | NUMBER | (3) | ||
PARENT_LEVEL_REL | VARCHAR2 | (30) | ||
TABLE_RELATION | VARCHAR2 | (30) | ||
PARENT_LEVEL_INDEX2 | NUMBER | (3) | ||
PARENT_LEVEL_REL2 | VARCHAR2 | (30) | ||
STATUS | NUMBER | (3) | Yes | |
PARENT_IN_TOTAL | NUMBER | (3) | ||
POSITION | NUMBER | (3) | Yes | |
TOTAL0 | NUMBER | (3) | ||
LEVEL_DISPLAY | NUMBER | (3) | ||
NO_ITEMS | NUMBER | (1) | ||
DEFAULT_KEY_VALUE | VARCHAR2 | (400) | ||
USER_LEVEL0 | NUMBER | (3) | ||
USER_LEVEL1 | NUMBER | (3) | ||
USER_LEVEL1_DEFAULT | NUMBER | (3) | ||
USER_LEVEL2 | NUMBER | (3) | ||
USER_LEVEL2_DEFAULT | NUMBER | (3) | ||
DISP_KEY_SIZE | NUMBER | (5) | ||
TARGET_LEVEL | NUMBER | (1) | Target Level | |
LEVEL_SHORTNAME | VARCHAR2 | (30) | Short name | |
LEVEL_SOURCE | VARCHAR2 | (10) | Source |
Cut, paste (and edit) the following text to query this object:
SELECT INDICATOR
, DIM_SET_ID
, DIM_LEVEL_INDEX
, NAME
, HELP
, TOTAL_DISP_NAME
, COMP_DISP_NAME
, LEVEL_TABLE_NAME
, LEVEL_VIEW_NAME
, FILTER_COLUMN
, FILTER_VALUE
, DEFAULT_VALUE
, DEFAULT_TYPE
, VALUE_ORDER_BY
, COMP_ORDER_BY
, LEVEL_PK_COL
, PARENT_LEVEL_INDEX
, PARENT_LEVEL_REL
, TABLE_RELATION
, PARENT_LEVEL_INDEX2
, PARENT_LEVEL_REL2
, STATUS
, PARENT_IN_TOTAL
, POSITION
, TOTAL0
, LEVEL_DISPLAY
, NO_ITEMS
, DEFAULT_KEY_VALUE
, USER_LEVEL0
, USER_LEVEL1
, USER_LEVEL1_DEFAULT
, USER_LEVEL2
, USER_LEVEL2_DEFAULT
, DISP_KEY_SIZE
, TARGET_LEVEL
, LEVEL_SHORTNAME
, LEVEL_SOURCE
FROM APPS.BSC_KPI_DIM_LEVELS_VL;
|
|
|