---

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.id IN (
    148, 149, 150, 151,
    152, 153, 154, 155,
    160, 161, 162, 163, 164
)
OR t.code IN (
    'ANNUAL_PAYMENT_ASV',
    'DEPOSIT_FUNDS_UNIDENTIFIED_PAYMENTS',
    'REFUSAL_BANK'
)
OR t.code ILIKE '%CLASSIFICATION%'
OR t.code ILIKE '%TARGET_CONTRIBUT%'
ORDER BY t.id;