View: BSC_DB_COLOR_AO_DEFAULTS_V

Product:	BSC - Balanced Scorecard
Description:	View of the default analysis option combination by indicator.
Implementation/DBA Data:	APPS.BSC_DB_COLOR_AO_DEFAULTS_V

View Text

SELECT AG0_DEFAULT.INDICATOR
, AG0_DEFAULT.DEFAULT_VALUE AS A0_DEFAULT
, NVL(AG1_DEFAULT.DEFAULT_VALUE
, 0) AS A1_DEFAULT
, NVL(AG2_DEFAULT.DEFAULT_VALUE
, 0) AS A2_DEFAULT FROM BSC_KPI_ANALYSIS_GROUPS AG0_DEFAULT
, BSC_KPI_ANALYSIS_GROUPS AG1_DEFAULT
, BSC_KPI_ANALYSIS_GROUPS AG2_DEFAULT
WHERE AG0_DEFAULT.ANALYSIS_GROUP_ID = 0
AND AG1_DEFAULT.INDICATOR (+) = AG0_DEFAULT.INDICATOR
AND AG1_DEFAULT.ANALYSIS_GROUP_ID (+) = 1
AND AG2_DEFAULT.INDICATOR (+) = AG0_DEFAULT.INDICATOR
AND AG2_DEFAULT.ANALYSIS_GROUP_ID (+) = 2

Columns