SELECT baid,
         SUM (acl) ACL,
         historic_days,
         report_date,
         SUM (invoiced) invoiced,
         SUM (published) published,
         SUM (estimated) estimated,
         SUM (extrapolated) extrapolated,
         SUM (crr_current) crr_current,
         SUM (crr_bid_reserve) crr_bid_reserve,
         SUM (crr_win_bid) crr_win_bid,
         SUM (past_due) past_due,
         SUM (ferc_annual) ferc_annual,
         SUM (wac_current) wac_current,
         SUM (wac_future) wac_future,
         SUM (eal_adjustment) eal_adjustment,
         SUM (virtual_bid) virtual_bid,
         SUM (virtual_da) virtual_da,
         SUM (virtual_rt) virtual_rt,
         SUM (crr_bid_liability) crr_bid_liability,
         MAX (sequence_id) sequence_id
    FROM (SELECT arc.customer_number baid,
                 0 acl,
                 NVL (arc.attribute5, fpov.profile_option_value) historic_days,
                 SYSDATE report_date,
                 cesb.invoiced invoiced,
                 cesb.published published,
                 cesb.estimated estimated,
                 cesb.extrapolated extrapolated,
                 cesb.crr_current crr_current,
                 cesb.crr_bid_reserve crr_bid_reserve,
                 cesb.crr_win_bid crr_win_bid,
                 cesb.past_due past_due,
                 cesb.ferc_annual ferc_annual,
                 cesb.wac_current wac_current,
                 cesb.wac_future wac_future,
                 cesb.eal_adjustment eal_adjustment,
                 cesb.virtual_bid virtual_bid,
                 cesb.virtual_da virtual_da,
                 cesb.virtual_rt virtual_rt,
                 cesb.crr_bid_liability,
                 cesb.sequence_id
            FROM ciso_eal_summary_b cesb,
                 ar_customers_v arc,
                 fnd_profile_option_values fpov,
                 fnd_profile_options fpo
           WHERE     arc.customer_number = cesb.baid(+)
                 AND fpo.profile_option_id = fpov.profile_option_id
                 AND fpo.profile_option_name = 'CISO_EXTRAPOLATED_HISTORY_DAYS'
        )
GROUP BY baid, historic_days, report_date