View: BSC_KPI_ANALYSIS_MEASURES_VL

Product:	BSC - Balanced Scorecard
Description:
Implementation/DBA Data:	APPS.BSC_KPI_ANALYSIS_MEASURES_VL

View Text

SELECT B.INDICATOR
, B.ANALYSIS_OPTION0
, B.ANALYSIS_OPTION1
, B.ANALYSIS_OPTION2
, B.SERIES_ID
, TL.NAME
, TL.HELP
, B.DATASET_ID
, B.AXIS
, B.SERIES_TYPE
, B.STACK_SERIES_ID
, B.BM_FLAG
, B.BUDGET_FLAG
, B.DEFAULT_VALUE
, B.SERIES_COLOR
, B.BM_COLOR
, B.PROTOTYPE_FLAG
, B.KPI_MEASURE_ID FROM BSC_KPI_ANALYSIS_MEASURES_B B
, BSC_KPI_ANALYSIS_MEASURES_TL TL WHERE B.INDICATOR= TL.INDICATOR
AND B.ANALYSIS_OPTION0 = TL.ANALYSIS_OPTION0
AND B.ANALYSIS_OPTION1 = TL.ANALYSIS_OPTION1
AND B.ANALYSIS_OPTION2 = TL.ANALYSIS_OPTION2
AND B.SERIES_ID= TL.SERIES_ID
AND TL.LANGUAGE =USERENV('LANG')

Columns