---

SELECT
    t.id,
    t.code,
    t.name,
    t.short_name,
    t.group_code,
    t.service_type,
    t.type_movement,
    en.enum_value AS type_movement_name,
    t.auto_approver,
    t.display_in_lkk,
    t.display_in_statement,
    t.settings_transaction_extended_id,
    t.version
FROM back_office.operation_type t
LEFT JOIN ourpension.enums en
    ON en.id = t.type_movement
WHERE
       t.code IN (
           'NPO_RETURN_RPPO_PENSION_PAYMENT',
           'NPO_RETURN_SUCCESSOR_PAYMENT',
           'NPO_RETURN_REDEMPTION_SUM',
           'NPO_RETURN_NDFL_NONSTATE_PENSION',
           'NPO_RETURN_NDFL_SUCCESSOR',
           'NPO_RETURN_NDFL_REDEMPTION',

           'NPO_PAYMENT_PENSION',
           'NPO_PAYMENT_SUCCESSOR',
           'NPO_PAYMENT_TERMINATED'
       )
    OR t.code ILIKE '%TARGET%CONTRIBUT%'
    OR t.code ILIKE '%CLASSIFICATION%'
    OR t.code ILIKE '%ANNUAL%'
    OR t.code ILIKE '%ASV%'
    OR t.code ILIKE '%RESERVE%'
    OR t.code ILIKE '%REFUSAL%'
ORDER BY t.id;