To Check Application--> Responsablity and Asssigned Menu

SELECT
DISTINCT e.application_name,

a.responsibility_name,

a.LANGUAGE,

b.responsibility_key,

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'