SELECT PE.PARTY_NUMBER PERSON_NUMBER , SUM(NVL(AWD.OFFERED_AMT , 0)) , SUM(NVL(AWD.ACCEPTED_AMT , 0)) , SUM(NVL(AWD.PAID_AMT , 0)) FROM IGF_AW_AWARD AWD , IGF_AP_FA_BASE_REC FA , HZ_PARTIES PE WHERE AWD.AWARD_STATUS IN ('ACCEPTED' , 'OFFERED' , 'REVISED') AND AWD.BASE_ID = FA.BASE_ID AND FA.PERSON_ID = PE.PARTY_ID GROUP BY PE.PARTY_NUMBER