SQL Query to Create Lookup Values

INSERT INTO lkv (
    lkv_key,
    lku_key,
    lkv_encoded,
    lkv_decoded,
    lkv_language,
    lkv_country,
    lkv_variant,
    lkv_disabled,
    lkv_data_level,
    lkv_create,
    lkv_createby,
    lkv_update,
    lkv_updateby,
    lkv_note,
    lkv_rowver
) SELECT
    lkv_seq.NEXTVAL AS lkv_key,
    lku_key AS lku_key,
    ' codeValue ' || lkv_seq.NEXTVAL AS lkv_encoded,
    'decodeValue' || lkv_seq.NEXTVAL AS lkv_decoded,
    lkv_language,
    lkv_country,
    lkv_variant,
    lkv_disabled,
    lkv_data_level,
    lkv_create,
    lkv_createby,
    lkv_update,
    lkv_updateby,
    NULL AS lkv_note,
    lkv_rowver
FROM
    lkv
WHERE
    lku_key = lku_key;