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


SELECT
    ed.account_dt,
    ed.account_ct,
    COALESCE(ed.pension_scheme_id, et.pens_schema_dt)
        AS debit_scheme_id,
    COALESCE(ed.pension_scheme_id, et.pens_schema_ct)
        AS credit_scheme_id,
    et.contract_class_code
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
JOIN ourpension.eps_detail ed
    ON ed.eps_id = e.id
WHERE src.operation_id = 84061424
  AND e.service_type = 'NPO';