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_SET_GRANTS_V

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

View Text

SELECT DISTINCT INSTANCE_SETS.PREDICATE
, USERS.USER_ID
, GRANTS.OBJECT_NAME
, GRANTS.OBJECT_KEY
, FUNCTIONS.FUNCTION_NAME
FROM FND_USER USERS
, HZ_PARTIES
, FND_GRANTS GRANTS
, FND_FORM_FUNCTIONS FUNCTIONS
, FND_MENU_ENTRIES ROLE_PRIVILEGES
, FND_OBJ_INSTANCE_SETS_B INSTANCE_SETS
WHERE GRANTS.OBJECT_KEY_TYPE = 'INSTANCE_SET'
AND GRANTS.START_DATE<=SYSDATE
AND ( GRANTS.END_DATE IS NULL OR GRANTS.END_DATE >=SYSDATE )
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
AND GRANTS.OBJECT_KEY = INSTANCE_SETS.INSTANCE_SET_ID

Columns

Name
PREDICATE
USER_ID
OBJECT_NAME
OBJECT_KEY
FUNCTION_NAME