FND Design Data [Home] [Help]

View: EGO_ROLE_PRIVILEGES_V

Product: EGO - Advanced Product Catalog
Description: View contains all the privileges defined for Role
Implementation/DBA Data: ViewAPPS.EGO_ROLE_PRIVILEGES_V
View Text

SELECT PRIVILEGES_TL.FUNCTION_ID PRIVILEGE_ID
, PRIVILEGES_TL.USER_FUNCTION_NAME PRIVILEGE_DISPLAY_NAME
, PRIVILEGES_TL.DESCRIPTION PRIVILEGE_DESCRIPTION
, PRIVILEGES_TL.ROWID ROW_ID
, ROLE_PRIVS.MENU_ID ROLE_ID
FROM FND_FORM_FUNCTIONS_TL PRIVILEGES_TL
, FND_MENU_ENTRIES ROLE_PRIVS
WHERE ROLE_PRIVS.FUNCTION_ID=PRIVILEGES_TL.FUNCTION_ID
AND PRIVILEGES_TL.LANGUAGE=USERENV('LANG')

Columns

Name
PRIVILEGE_ID
PRIVILEGE_DISPLAY_NAME
PRIVILEGE_DESCRIPTION
ROW_ID
ROLE_ID