eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FND_OBJ_INSTANCE_GRANTS_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT GRANTS.GRANT_ID
, GRANTS.PARTY_ID
, USERS.USER_ID
, GRANTS.OBJECT_NAME
, GRANTS.OBJECT_KEY
, FUNCTIONS.FUNCTION_NAME
FROM FND_GRANTS GRANTS
, FND_USER USERS
, HZ_PARTIES
, FND_MENU_ENTRIES ROLE_PRIVILEGES
, FND_FORM_FUNCTIONS FUNCTIONS
WHERE GRANTS.START_DATE<= SYSDATE
AND ( GRANTS.END_DATE IS NULL OR GRANTS.END_DATE >= SYSDATE )
AND GRANTS.OBJECT_KEY_TYPE= 'INSTANCE'
AND GRANTS.PARTY_ID = HZ_PARTIES.PARTY_ID
AND HZ_PARTIES.PARTY_ID = USERS.CUSTOMER_ID
AND GRANTS.ROLE_ID = ROLE_PRIVILEGES.MENU_ID
AND ROLE_PRIVILEGES.FUNCTION_ID = FUNCTIONS.FUNCTION_ID

Columns

Name
GRANT_ID
PARTY_ID
USER_ID
OBJECT_NAME
OBJECT_KEY
FUNCTION_NAME