View: BSC_KPI_ANALYSIS_OPTIONS_VL

Product:	BSC - Balanced Scorecard
Description:	View of BSC_KPI_ANALYSIS_OPTIONS_B and BSC_KPI_ANALYSIS_OPTIONS_TL
Implementation/DBA Data:	APPS.BSC_KPI_ANALYSIS_OPTIONS_VL

View Text

SELECT B.INDICATOR
, B.ANALYSIS_GROUP_ID
, B.OPTION_ID
, B.PARENT_OPTION_ID
, B.GRANDPARENT_OPTION_ID
, TL.NAME
, TL.HELP
, B.DIM_SET_ID
, B.USER_LEVEL0
, B.USER_LEVEL1
, B.USER_LEVEL1_DEFAULT
, B.USER_LEVEL2
, B.USER_LEVEL2_DEFAULT FROM BSC_KPI_ANALYSIS_OPTIONS_B B
, BSC_KPI_ANALYSIS_OPTIONS_TL TL
WHERE B.INDICATOR = TL.INDICATOR
AND B.ANALYSIS_GROUP_ID = TL.ANALYSIS_GROUP_ID
AND B.OPTION_ID = TL.OPTION_ID
AND B.PARENT_OPTION_ID = TL.PARENT_OPTION_ID
AND B.GRANDPARENT_OPTION_ID = TL.GRANDPARENT_OPTION_ID
AND LANGUAGE = USERENV('LANG')

Columns