---

select
    pu.id as pu_row_id,
    pu.account,
    pu.uidpensionscheme as saved_pu_uid,
    ps.uid_1c as dictionary_uid,
    bu.id as matching_bu_row_id,
    bu.uidsubtypeactivity,
    bu.sum_dt_bu,
    bu.sum_ct_bu
from back_office.report_conformity_pu_bu_detail pu
left join prod_line.pens_scheme ps
    on ps.id = pu.pension_scheme_id
left join back_office.report_conformity_pu_bu_detail bu
    on bu.report_conformity_pu_bu_id =
       pu.report_conformity_pu_bu_id
   and bu.account = pu.account
   and cast(bu.uidpensionscheme as text) =
       cast(ps.uid_1c as text)
   and (
       bu.sum_dt_bu is not null
       or bu.sum_ct_bu is not null
   )
where pu.report_conformity_pu_bu_id = 92
  and pu.id = 6039;