VIEW: APPS.EGO_ROLE_DETAILS_V

Source

View Text - Preformatted

SELECT objects.display_name OBJECT_DISPLAY_NAME, menus.user_menu_name ROLE_DISPLAY_NAME, menus.description ROLE_DESCRIPTION, menus.menu_id ROLE_ID from fnd_menus_tl menus, fnd_objects_tl objects WHERE objects.language = USERENV('LANG') and menus.language = USERENV('LANG') and exists (select 1 from fnd_form_functions f, fnd_menu_entries e where e.menu_id = menus.menu_id and e.function_id = f.function_id and f.object_id = objects.object_id)

View Text - HTML Formatted

SELECT OBJECTS.DISPLAY_NAME OBJECT_DISPLAY_NAME
, MENUS.USER_MENU_NAME ROLE_DISPLAY_NAME
, MENUS.DESCRIPTION ROLE_DESCRIPTION
, MENUS.MENU_ID ROLE_ID
FROM FND_MENUS_TL MENUS
, FND_OBJECTS_TL OBJECTS
WHERE OBJECTS.LANGUAGE = USERENV('LANG')
AND MENUS.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT 1
FROM FND_FORM_FUNCTIONS F
, FND_MENU_ENTRIES E
WHERE E.MENU_ID = MENUS.MENU_ID
AND E.FUNCTION_ID = F.FUNCTION_ID
AND F.OBJECT_ID = OBJECTS.OBJECT_ID)