SELECT KP.INDICATOR , NVL(CM1.PROPERTY_VALUE , 0) AS COL_M1_LEVEL4 , NVL(CM2.PROPERTY_VALUE , 0) AS COL_M2_LEVEL4 , NVL(CM3.PROPERTY_VALUE , 90) AS COL_M3_LEVEL4 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_LEVEL4' AND KP.INDICATOR =CM2.INDICATOR(+) AND CM2.PROPERTY_CODE(+) ='COL_M2_LEVEL4' AND KP.INDICATOR =CM3.INDICATOR(+) AND CM3.PROPERTY_CODE(+) ='COL_M3_LEVEL4'