---

SELECT
    rd.id AS detail_id,
    rd.uidpensionscheme,
    old_ps.id AS old_scheme_id,
    old_ps.number AS old_scheme_number,
    old_ps.prod_line_pens_scheme_id,
    ps.name AS pension_scheme,
    ps.index_scheme
FROM back_office.report_conformity_pu_bu_detail rd
LEFT JOIN ourpension.pension_scheme old_ps
    ON NULLIF(LOWER(TRIM(old_ps.scheme_id_1c)), '') =
       NULLIF(LOWER(TRIM(rd.uidpensionscheme)), '')
LEFT JOIN prod_line.pens_scheme ps
    ON ps.id = old_ps.prod_line_pens_scheme_id
WHERE rd.report_conformity_pu_bu_id = 39
ORDER BY rd.id;