---

select
    t.id as decision_id,
    t.number as decision_number,
    t.date as decision_date,
    t.accepted as decision_accepted,
    t.rejected as decision_rejected,
    t.canceled as decision_canceled,
    t.decision_type_code,
    t.decision_payment_type_code,

    pa.id as application_id,
    pa.number as application_number,
    pa."date" as application_date,
    pa.appeal_date,
    pa.registration,
    pa.accepted as application_accepted,

    pa.ops_payment_type_code,
    pa.decision_payment_type_code as application_decision_payment_type,
    pa.payment_way,

    pa.sharer_id,
    s.id as found_sharer_id,

    c.id as contract_id,
    i.id as individual_id,

    i.registration_address_id,
    pa.address_id as application_address_id,
    a.id as found_address_id,

    pa.bank_detail_id,
    pa.bank_account_id,

    aibd.id as found_bank_detail_id,
    aibd.personal_account,
    aibd.bic,
    aibd.accepted as bank_detail_accepted,

    dpt.code as found_decision_payment_type,
    dpt.short_name,

    case
        when s.id is null then 'ОТВАЛ: нет sharer'
        when c.id is null then 'ОТВАЛ: нет contract'
        when i.id is null then 'ОТВАЛ: нет individual'
        when a.id is null then 'ОТВАЛ: нет registration_address'
        when dpt.code is null then 'ОТВАЛ: не найден тип решения'
        when aibd.id is null then 'ОТВАЛ: нет bank_detail'
        when aibd.accepted is null then 'ОТВАЛ: bank_detail.accepted IS NULL'
        else 'ВСЕ ДАННЫЕ ДЛЯ СТАРОГО ОТЧЕТА ЕСТЬ'
    end as diagnostic

from back_office.ops_payment_decision t

join ourpension.ops_pension_assignment_application pa
    on pa.id = t.ops_pension_assignment_application_id

left join ourpension.sharer s
    on s.id = pa.sharer_id

left join ourpension.contract c
    on c.id = s.contract_id

left join ourpension.individual i
    on i.id = c.individual_id

left join ourpension.address a
    on a.id = i.registration_address_id

left join ourpension.application_individual_bank_detail aibd
    on aibd.id = pa.bank_detail_id

left join ourpension.decision_payment_type dpt
    on dpt.code = t.decision_payment_type_code

where t.id in (1985642, 1985638);