Appliocation Menus , Submenus assigned to User

SELECT r.responsibility_name,
f.user_menu_name,
me.prompt "Main_Prompt",
me.description "Main_Desc",
metl.prompt "sub_prompt",
metl.description "sub_desc"
FROM apps.fnd_user fu,
apps.fnd_user_resp_groups urg,
apps.fnd_menus_vl f,
apps.fnd_responsibility fr,
apps.fnd_responsibility_tl r,
apps.fnd_menus fm,
apps.fnd_menu_entries fme,
apps.fnd_menu_entries_tl me,
apps.fnd_menus fm2,
apps.fnd_menu_entries fme2,
apps.fnd_menu_entries_tl metl
WHERE 1 = 1 AND fr.menu_id = f.menu_id AND fu.user_id = urg.user_id
AND (urg.responsibility_id = fr.responsibility_id
AND urg.responsibility_application_id = fr.application_id)
AND (fr.responsibility_id = r.responsibility_id
AND fr.application_id = r.application_id)
AND (fme.menu_id = me.menu_id
AND fme.entry_sequence = me.entry_sequence)
AND fr.menu_id = fm.menu_id
AND fm.menu_id = fme.menu_id
AND fme.sub_menu_id = fm2.menu_id
AND fm2.menu_id = fme2.menu_id
AND (fme2.menu_id = metl.menu_id
AND fme2.entry_sequence = metl.entry_sequence)
AND fr.RESPONSIBILITY_ID = XXXX
and metl.language='US'and me.language='US'order by urg.description