---

SELECT
    t.id,
    t.code,
    t.name,
    t.short_name,
    t.group_code,
    t.service_type,
    t.type_movement,
    t.auto_approver,
    t.display_in_lkk,
    t.display_in_statement,
    t.settings_transaction_extended_id
FROM back_office.operation_type t
WHERE t.code IN (
    'NPO_TARGET_CONTRIBUTIONS',
    'NPO_RETURN_PENSION_PAYMENT',
    'NPO_RETURN_SUCCESSOR_PAYMENT',
    'NPO_RETURN_REDEMPTION_SUM',
    'NPO_RETURN_NDFL_NONSTATE_PENSION',
    'NPO_RETURN_NDFL_SUCCESSOR',
    'NPO_RETURN_NDFL_HEIRS',
    'NPO_RETURN_NDFL_REDEMPTION',
    'NPO_PAYMENT_PENSION',
    'NPO_PAYMENT_SUCCESSOR',
    'NPO_PAYMENT_TERMINATED',
    'TRANSFER_TO_INSURED_FUND_RESERVE',
    'TRANSFER_FROM_INSURED_FUND_RESERVE',
    'TRANSFER_FROM_FUND_RESERVE',
    'TRANSFER_TO_RESERVE',
    'CHARGE_FROM_RESERVE'
)
ORDER BY t.id;