Query : To get Menus Associated with responsibility

SELECT DISTINCT a.responsibility_name, c.user_menu_name 
FROM apps.fnd_responsibility_tl a, 
apps.fnd_responsibility b, 
apps.fnd_menus_tl c, 
apps.fnd_menus d, 

apps.fnd_application_tl e, 
apps.fnd_application f 
WHERE a.responsibility_id(+) = b.responsibility_id 
AND a.responsibility_id = ‘20538’ --- pass the responsiblity IdAND b.menu_id = c.menu_id 
AND b.menu_id = d.menu_id 
AND e.application_id = f.application_id 
AND f.application_id = b.application_id 
AND a.LANGUAGE = 'US';