SELECT KP.INDICATOR , NVL(CM1.PROPERTY_VALUE , 90) AS COL_M1_LEVEL2 , NVL(CM2.PROPERTY_VALUE , 100) AS COL_M2_LEVEL2 , NVL(CM3.PROPERTY_VALUE , 105) AS COL_M3_LEVEL2 FROM BSC_TAB_INDICATORS KP , BSC_KPI_PROPERTIES CM1 , BSC_KPI_PROPERTIES CM2 , BSC_KPI_PROPERTIES CM3 WHERE KP.INDICATOR =CM1.INDICATOR(+) AND CM1.PROPERTY_CODE(+) ='COL_M1_LEVEL2' AND KP.INDICATOR =CM2.INDICATOR(+) AND CM2.PROPERTY_CODE(+) ='COL_M2_LEVEL2' AND KP.INDICATOR =CM3.INDICATOR(+) AND CM3.PROPERTY_CODE(+) ='COL_M3_LEVEL2'