SQL Statement which produced this data: SELECT gmsa.award_id, gmsac.project_id, gmsac.task_id, SUM(DECODE (SUBSTR (gmsac.expenditure_type, 1, 3), 'IDC', 0, NVL (GMSAC.BURDENED_COST, 0))) TOTAL_EXP, SUM(Decode(substr(gmsac.expenditure_type,1,3), 'IDC', 0, NVL(GMSAC.BURDENED_COST,0))) DIR_EXP, SUM(NVL(gmsac.BILLED_AMOUNT,0)) billed, SUM(NVL(gmsac.REVENUE_AMOUNT,0)) rev FROM tams.tams_gms_status_actuals gmsac, apps.gms_awards_all gmsa WHERE gmsac.award_id = gmsa.AWARD_ID AND gmsa.award_number in ('532437C1', '532437C2') -- and gmsac.pa_date BETWEEN to_date(substr('##1',1,10),'YYYY/MM/DD') AND to_date(substr('##2',1,10),'YYYY/MM/DD') --removed left outer join group by gmsa.award_id,gmsac.project_id, gmsac.task_id AWARD_ID,PROJECT_ID,TASK_ID,TOTAL_EXP,DIR_EXP,BILLED,REV 147,268,268,0,0,0,0 2573,268,268,3473.85,3473.85,10378,10378