---

SELECT
    et.id AS eps_transaction_id,
    et.oper_date,
    et.operation_sum,
    et.strategy_id,
    st.name AS strategy,
    et.pens_schema_dt,
    ps_dt.name AS debit_scheme,
    et.pens_schema_ct,
    ps_ct.name AS credit_scheme
FROM back_office.eps_transaction_source src
JOIN back_office.eps_transaction et
    ON et.eps_transaction_source_id = src.id
JOIN ourpension.eps e
    ON e.id = et.eps_id
LEFT JOIN prod_line.hb_invest_strategy st
    ON st.id = et.strategy_id
LEFT JOIN prod_line.pens_scheme ps_dt
    ON ps_dt.id = et.pens_schema_dt
LEFT JOIN prod_line.pens_scheme ps_ct
    ON ps_ct.id = et.pens_schema_ct
WHERE src.operation_id = 84061424
  AND e.service_type = 'NPO';