---

SELECT
    opaa.id,
    to_char(opaa.appeal_date, 'DD.MM.YYYY') AS appeal_date,

    CASE
        WHEN opaa.accepted IS NOT NULL THEN 'Да'
        ELSE 'Нет'
    END AS accepted,

    opaa.number AS reg_numb,

    dpt.short_name,

    upper(
        i.last_name || ' ' ||
        i.first_name || ' ' ||
        i.middle_name
    ) AS fio_zl,

    i.insurance_number AS i_zl,

    c.number AS contract_numb,

    pt.name AS payment_way,

    a.address_text,

    aibd.personal_account,
    aibd.bic,

    br.bank_name,
    br.corraccount,

    br.place || ' ' || br.address AS bank_addres,

    to_char(aibd.accepted, 'DD.MM.YYYY') AS br_date,

    -- временно добавил для проверки
    opd.id AS decision_id,
    opd.number AS decision_number,
    to_char(opd.date, 'DD.MM.YYYY') AS decision_date,
    opd.decision_payment_type_code AS decision_payment_type_code

FROM back_office.ops_payment_decision opd

JOIN ourpension.ops_pension_assignment_application opaa
    ON opaa.id = opd.ops_pension_assignment_application_id

LEFT JOIN ourpension.payment_type pt
    ON opaa.payment_way = pt.code

JOIN ourpension.sharer s
    ON s.id = opaa.sharer_id

JOIN ourpension.contract c
    ON c.id = s.contract_id

JOIN ourpension.individual i
    ON i.id = c.individual_id

JOIN ourpension.address a
    ON i.registration_address_id = a.id

JOIN ourpension.decision_payment_type dpt
    ON opd.decision_payment_type_code = dpt.code

LEFT JOIN ourpension.application_individual_bank_detail aibd
    ON opaa.bank_detail_id = aibd.id

LEFT JOIN ourpension.bankru br
    ON aibd.bic = br.bic

WHERE opd.decision_payment_type_code IN ('01', '16')

  AND opd.date BETWEEN DATE '2026-08-21'
                   AND DATE '2026-08-28'

ORDER BY opd.date DESC;