View: EGO_ROLE_DETAILS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains the Role Details
Implementation/DBA Data:	APPS.EGO_ROLE_DETAILS_V

View Text

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)

Columns