---

SELECT
    n.id                              AS new_id,
    n.code                            AS new_code,
    t.id                              AS template_id,
    t.code                            AS template_code,

    n.service_type                    AS new_service_type,
    t.service_type                    AS template_service_type,

    n.group_code                      AS new_group_code,
    t.group_code                      AS template_group_code,

    n.type_movement                   AS new_type_movement,
    t.type_movement                   AS template_type_movement,

    n.auto_approver                   AS new_auto_approver,
    t.auto_approver                   AS template_auto_approver,

    n.display_in_lkk                  AS new_display_in_lkk,
    t.display_in_lkk                  AS template_display_in_lkk,

    n.display_in_statement            AS new_display_in_statement,
    t.display_in_statement            AS template_display_in_statement,

    n.settings_transaction_extended_id AS new_settings_id,
    t.settings_transaction_extended_id AS template_settings_id
FROM back_office.operation_type n
JOIN back_office.operation_type t
    ON t.code = CASE n.code
        WHEN 'SECOND_PAYMENT_PENSION'
            THEN 'PAYMENT_PENSION'
        WHEN 'SECOND_PAYMENT_SUCCESSOR'
            THEN 'PAYMENT_SUCCESSOR'
        WHEN 'SECOND_PAYMENT_TERMINATED'
            THEN 'PAYMENT_TERMINATED'
    END
WHERE n.code IN (
    'SECOND_PAYMENT_PENSION',
    'SECOND_PAYMENT_SUCCESSOR',
    'SECOND_PAYMENT_TERMINATED'
)
ORDER BY n.id;