Skip to content
[Home] [Help]
View: 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 |