---

with last_report as (
    select id
    from back_office.report_conformity_pu_bu
    where service_type = 'NPO'
      and m_y_report = '09.2026'
    order by id desc
    limit 1
)
select
    r.id as report_id,
    rd.classification_id,
    rd.contract_model_label,
    count(rd.id) as detail_rows,
    sum(coalesce(rd.sum_dt_pu, 0)) as sum_dt_pu,
    sum(coalesce(rd.sum_ct_pu, 0)) as sum_ct_pu,
    sum(coalesce(rd.sum_dt_bu, 0)) as sum_dt_bu,
    sum(coalesce(rd.sum_ct_bu, 0)) as sum_ct_bu
from last_report r
left join back_office.report_conformity_pu_bu_detail rd
    on rd.report_conformity_pu_bu_id = r.id
group by
    r.id,
    rd.classification_id,
    rd.contract_model_label
order by
    rd.classification_id,
    rd.contract_model_label;