SELECT KP.INDICATOR , NVL(CM1.PROPERTY_VALUE , 100) AS COL_M1_LEVEL1 , NVL(CM2.PROPERTY_VALUE , 110) AS COL_M2_LEVEL1 , NVL(CM3.PROPERTY_VALUE , 110) AS COL_M3_LEVEL1 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_LEVEL1' AND KP.INDICATOR =CM2.INDICATOR(+) AND CM2.PROPERTY_CODE(+) ='COL_M2_LEVEL1' AND KP.INDICATOR =CM3.INDICATOR(+) AND CM3.PROPERTY_CODE(+) ='COL_M3_LEVEL1'