VIEW: APPS.BSC_KPI_DIM_LEVELS_VL

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)