VIEW: APPS.EGO_ROLES_V

Source

View Text - Preformatted

SELECT distinct object_id OBJECT_ID, display_name OBJECT_DISPLAY_NAME, menu_id ROLE_ID, user_menu_name ROLE_DISPLAY_NAME, description ROLE_DESCRIPTION, user_name ROLE_CREATOR_USER_NAME, last_update_date LAST_UPDATE_DATE, last_updated_by LAST_UPDATED_BY FROM ( SELECT o.object_id object_id, o.display_name display_name, m.menu_id menu_id, m.user_menu_name user_menu_name, m.description description, u.user_name user_name, m.last_update_date last_update_date, m.last_updated_by last_updated_by FROM fnd_menus_vl m, fnd_user u, fnd_form_functions f, fnd_menu_entries e, fnd_objects_tl o WHERE e.menu_id = m.menu_id AND f.function_id = e.function_id AND m.last_updated_by = u.user_id(+) AND upper(m.type) = 'SECURITY' AND f.object_id = o.object_id AND o.language = userenv('LANG'))

View Text - HTML Formatted

SELECT DISTINCT OBJECT_ID OBJECT_ID
, DISPLAY_NAME OBJECT_DISPLAY_NAME
, MENU_ID ROLE_ID
, USER_MENU_NAME ROLE_DISPLAY_NAME
, DESCRIPTION ROLE_DESCRIPTION
, USER_NAME ROLE_CREATOR_USER_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM ( SELECT O.OBJECT_ID OBJECT_ID
, O.DISPLAY_NAME DISPLAY_NAME
, M.MENU_ID MENU_ID
, M.USER_MENU_NAME USER_MENU_NAME
, M.DESCRIPTION DESCRIPTION
, U.USER_NAME USER_NAME
, M.LAST_UPDATE_DATE LAST_UPDATE_DATE
, M.LAST_UPDATED_BY LAST_UPDATED_BY
FROM FND_MENUS_VL M
, FND_USER U
, FND_FORM_FUNCTIONS F
, FND_MENU_ENTRIES E
, FND_OBJECTS_TL O
WHERE E.MENU_ID = M.MENU_ID
AND F.FUNCTION_ID = E.FUNCTION_ID
AND M.LAST_UPDATED_BY = U.USER_ID(+)
AND UPPER(M.TYPE) = 'SECURITY'
AND F.OBJECT_ID = O.OBJECT_ID
AND O.LANGUAGE = USERENV('LANG'))