Product: | BSC - Balanced Scorecard |
---|---|
Description: | View of BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_TL. |
Implementation/DBA Data: | APPS.BSC_SYS_DIM_LEVELS_VL |
SELECT B.DIM_LEVEL_ID
, TL.NAME
, TL.HELP
, TL.TOTAL_DISP_NAME
, TL.COMP_DISP_NAME
, B.LEVEL_TABLE_NAME
, B.TABLE_TYPE
, B.LEVEL_PK_COL
, B.ABBREVIATION
, B.VALUE_ORDER_BY
, B.COMP_ORDER_BY
, B.CUSTOM_GROUP
, B.USER_KEY_SIZE
, B.DISP_KEY_SIZE
, NVL(B.EDW_FLAG
, 0) AS EDW_FLAG
, B.EDW_DIM_ID
, B.EDW_DIM_LEVEL_ID
, B.LEVEL_VIEW_NAME
, B.SHORT_NAME
, B.SOURCE
FROM BSC_SYS_DIM_LEVELS_B B
, BSC_SYS_DIM_LEVELS_TL TL
WHERE B.DIM_LEVEL_ID = TL.DIM_LEVEL_ID
AND TL.LANGUAGE = USERENV('LANG')