---

select
    to_char(o.ef_date, 'DD.MM.YYYY') as effective_date,
    coalesce(ot.name_for_statement, ot.name) as name,
    o.value,
    o.cred_mnemonics,
    o.ef_date
from operations o
join back_office.operation_type ot
    on ot.id = o.operation_type_id
where o.cred_mnemonics is not null
    and ot.display_in_statement = true
    and ot.code not in (
        'PDS_RETURN_NDFL_REDEMPTION',
        'PDS_RETURN_LUMP_SUM_PAYMENT',
        'PDS_RETURN_NDFL_LUMP_SUM'
    )
order by o.ef_date, o.id;