VIEW: APPS.BSC_KPI_ANALYSIS_MEASURES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')