DBA Data[Home] [Help]

VIEW: APPS.EGO_ROLE_PRIVILEGES_V

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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