[Home] [Help]
View: EGO_ROLE_PRIVILEGES_V
Product: | EGO - Advanced Product Catalog |
Description: | View contains all the privileges defined for Role |
Implementation/DBA Data: |
APPS.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 |