SELECT AAM.ACT_METRIC_USED_BY_ID EVENT_OFFER_ID , AAM.TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE , AAM.LAST_CALCULATED_DATE LAST_CALCULATED_DATE , SUM(NVL(AAM.TRANS_FORECASTED_VALUE , 0)) EVENT_OFFER_TOT_FRCST_COST , SUM(NVL(AAM.TRANS_ACTUAL_VALUE , 0)) EVENT_OFFER_TOT_ACTL_COST FROM AMS_ACT_METRICS_ALL AAM , AMS_METRICS_ALL_B AMT WHERE AAM.ARC_ACT_METRIC_USED_BY ='EVEO' AND AAM.METRIC_ID = AMT.METRIC_ID AND AMT.SUMMARY_METRIC_ID IS NULL AND AMT.METRIC_CATEGORY = 901 GROUP BY AAM.ACT_METRIC_USED_BY_ID , AAM.TRANSACTION_CURRENCY_CODE , AAM.LAST_CALCULATED_DATE WITH READ ONLY