VIEW: APPS.BSC_OAF_ANALYSYS_OPT_COMB_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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