Product: | BSC - Balanced Scorecard |
---|---|
Description: | View of BSC_KPI_DIM_LEVELS_B and BSC_KPI_DIM_LEVELS_TL |
Implementation/DBA Data: | APPS.BSC_KPI_DIM_LEVELS_VL |
SELECT B.INDICATOR
, B.DIM_SET_ID
, B.DIM_LEVEL_INDEX
, TL.NAME
, TL.HELP
, TL.TOTAL_DISP_NAME
, TL.COMP_DISP_NAME
, B.LEVEL_TABLE_NAME
, B.LEVEL_VIEW_NAME
, B.FILTER_COLUMN
, B.FILTER_VALUE
, B.DEFAULT_VALUE
, B.DEFAULT_TYPE
, B.VALUE_ORDER_BY
, B.COMP_ORDER_BY
, B.LEVEL_PK_COL
, B.PARENT_LEVEL_INDEX
, B.PARENT_LEVEL_REL
, B.TABLE_RELATION
, B.PARENT_LEVEL_INDEX2
, B.PARENT_LEVEL_REL2
, B.STATUS
, B.PARENT_IN_TOTAL
, B.POSITION
, B.TOTAL0
, B.LEVEL_DISPLAY
, B.NO_ITEMS
, B.DEFAULT_KEY_VALUE
, B.USER_LEVEL0
, B.USER_LEVEL1
, B.USER_LEVEL1_DEFAULT
, B.USER_LEVEL2
, B.USER_LEVEL2_DEFAULT
, S.DISP_KEY_SIZE
, B.TARGET_LEVEL
, S.SHORT_NAME AS LEVEL_SHORTNAME
, S.SOURCE AS LEVEL_SOURCE
FROM BSC_KPI_DIM_LEVELS_B B
, BSC_KPI_DIM_LEVELS_TL TL
, BSC_SYS_DIM_LEVELS_B S
WHERE B.INDICATOR= TL.INDICATOR
AND B.DIM_SET_ID =TL.DIM_SET_ID
AND B.DIM_LEVEL_INDEX = TL.DIM_LEVEL_INDEX
AND TL.LANGUAGE =USERENV('LANG')
AND B.LEVEL_TABLE_NAME = S.LEVEL_TABLE_NAME(+)