Загрузка данных


SELECT v.code
FROM (
    VALUES
        ('CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_INV_TO_STR'),
        ('CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_STR_TO_INV'),
        ('NPO_TARGET_CONTRIBUTIONS_SR'),
        ('NPO_TARGET_CONTRIBUTIONS_SS'),
        ('NPO_INSURED_FUND_REPLENISHMENT_SR'),
        ('NPO_RETURN_PENSION_PAYMENT'),
        ('NPO_RETURN_RPPO_SUCCESSOR_PAYMENT'),
        ('NPO_RETURN_RPPO_REDEMPTION_SUM'),
        ('NPO_RETURN_RPPO_NDFL'),
        ('ANNUAL_PAYMENT_ASV'),
        ('TRANSFER_FROM_RESERVE_TO_ACCOUNT_OF_OUTSTANDING_DEBTS'),
        ('SECOND_PAYMENT_PENSION'),
        ('SECOND_PAYMENT_SUCCESSOR'),
        ('SECOND_PAYMENT_TERMINATED'),
        ('DEPOSIT_FUNDS_UNIDENTIFIED_PAYMENTS'),
        ('REFUSAL_BANK')
) AS v(code)
LEFT JOIN back_office.operation_type t
    ON t.code = v.code
WHERE t.id IS NULL
ORDER BY v.code;