Friday, March 30, 2012

Menu's Attached to a particular 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 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';