insert into nx_translation
select NVL(v.string_status,0), NULL, v.created, v.source_file, v.language_code,
       p.character_set, np.project_id, nm.module_id, nv.version_id
from nx_versions v, nx_projects p, nx_project np,
     nx_module nm, nx_version nv
where v.project_name = np.name
and   v.module_name = nm.name
and   np.project_id = nm.project_id
and   p.project_name = v.project_name
and   v.version_number = nv.version_number
and   nv.project_id = np.project_id
and   nv.module_id = nm.module_id
and   v.language_code = p.language_code;
