SELECT DISTINCT frt.responsibility_name, fmt.user_menu_name
FROM apps.fnd_responsibility_tl frt,
apps.fnd_responsibility fr,
apps.fnd_menus_tl fmt,
apps.fnd_menus fm,
apps.fnd_application_tl fat,
apps.fnd_application fa
WHERE frt.responsibility_id(+) = fr.responsibility_id
AND fr.menu_id = fmt.menu_id
AND fr.menu_id = fm.menu_id
AND fat.application_id = fa.application_id
AND fa.application_id = fr.application_id
AND frt.LANGUAGE = 'US';
FROM apps.fnd_responsibility_tl frt,
apps.fnd_responsibility fr,
apps.fnd_menus_tl fmt,
apps.fnd_menus fm,
apps.fnd_application_tl fat,
apps.fnd_application fa
WHERE frt.responsibility_id(+) = fr.responsibility_id
AND fr.menu_id = fmt.menu_id
AND fr.menu_id = fm.menu_id
AND fat.application_id = fa.application_id
AND fa.application_id = fr.application_id
AND frt.LANGUAGE = 'US';
No comments:
Post a Comment