---

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.name_for_statement,
    t.display_in_statement,
    t.settings_transaction_extended_id
FROM back_office.operation_type t
WHERE
       t.code ILIKE '%CLASSIF%'
    OR t.name ILIKE '%классификац%'

    OR t.code ILIKE '%INSURED_FUND%'
    OR t.name ILIKE '%страхов%фонд%'

    OR t.code ILIKE '%RPPO%'
    OR t.name ILIKE '%РППО%'

    OR t.code ILIKE '%ANNUAL%'
    OR t.name ILIKE '%ежегод%'

    OR t.code ILIKE '%OUTSTANDING%'
    OR t.name ILIKE '%задолж%'

    OR t.code ILIKE '%REFUS%'
    OR t.name ILIKE '%отказ%'
ORDER BY t.id;