SELECT m.module_id,
       m.module_category_id,
       m.name,
       str.str_value reportName,
       m.description,
       m.view_name,
       m.graphical_symbol,
       gm.order_num,
       m.group_type,
       gm.gui_user_id
FROM gu_module gm , module m, str str, gui_users gu, gui_users cur_gu
WHERE gm.module_id = m.module_id
AND str.str_id = m.title_str_id
AND m.module_category_id = 6
AND gu.gui_user_id = gm.gui_user_id
AND gu.loginname = 'of_admin'
AND cur_gu.gui_user_id = ?
AND str.language = cur_gu.language
ORDER BY "ORDER_NUM"