Загрузка данных


all_sum as (
    select
        0 as id,
        1 as step,
        sum(
            coalesce(rd.sum_dt_pu, 0)
            - coalesce(rd.sum_ct_pu, 0)
        ) as s_pu,
        sum(
            coalesce(rd.sum_dt_bu, 0)
            - coalesce(rd.sum_ct_bu, 0)
        ) as s_bu
    from back_office.report_conformity_pu_bu_detail rd
    where rd.report_conformity_pu_bu_id = $P{id}
),