View: BSC_OAF_ANALYSYS_OPT_COMB_V

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

View Text

SELECT A.INDICATOR
, A.ANALYSIS_OPTION0
, A.ANALYSIS_OPTION1
, A.ANALYSIS_OPTION2
, A.SERIES_ID
, A.KPI_MEASURE_ID
, A.PROTOTYPE_FLAG
, BSC_OAF_VIEWS_PVT.GET_AOPTS_SERIES_NAMES(A.INDICATOR
, A.ANALYSIS_OPTION0
, A.ANALYSIS_OPTION1
, A.ANALYSIS_OPTION2
, A.SERIES_ID) AS FULL_NAME
, BSC_OAF_VIEWS_PVT.GET_DATASET_SOURCE(A.DATASET_ID) SOURCE
, BSC_OAF_VIEWS_PVT.GET_AOPTS_DISPLAY_FLAG(A.INDICATOR
, A.ANALYSIS_OPTION0
, A.ANALYSIS_OPTION1
, A.ANALYSIS_OPTION2
, A.SERIES_ID) AS DISPLAY_FLAG
, C.SHARE_FLAG AS MASTER_FLAG
, A.DATASET_ID AS DATASET_ID
, BSC_OAF_VIEWS_PVT.GET_AOPTS_DEFAULT_FLAG(A.INDICATOR
, A.ANALYSIS_OPTION0
, A.ANALYSIS_OPTION1
, A.ANALYSIS_OPTION2
, A.SERIES_ID) AS DEFAULT_FLAG
FROM BSC_KPIS_B C
, BSC_KPI_ANALYSIS_OPTIONS_B B
, BSC_KPI_ANALYSIS_MEASURES_B A
WHERE C.INDICATOR =B.INDICATOR
AND B.INDICATOR = A.INDICATOR
AND B.ANALYSIS_GROUP_ID = 0
AND B.OPTION_ID = ANALYSIS_OPTION0

Columns