View: EGO_ROLES_V

Product:	EGO - Advanced Product Catalog
Description:	View contains all the Roles defined
Implementation/DBA Data:	APPS.EGO_ROLES_V

View Text

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'))

Columns