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.

VIEW: APPS.FND_OBJ_INS_GRANTS_V

Source

View Text - Preformatted


SELECT DISTINCT grants.grant_guid, grants.grantee_key, grants.grantee_type, grants.object_id, grants.instance_pk1_value, grants.instance_pk2_value, grants.instance_pk3_value, grants.instance_pk4_value, grants.instance_pk5_value, functions.function_name FROM fnd_grants grants, fnd_menu_entries role_privileges, fnd_form_functions functions WHERE trunc(grants.start_date)<= trunc(sysdate) AND ( grants.end_date IS NULL OR trunc(grants.end_date) >= trunc(sysdate) ) AND grants.instance_type= 'INSTANCE' AND role_privileges.function_id = functions.function_id AND role_privileges.menu_id in (select m.menu_id from fnd_menu_entries m connect by m.menu_id=prior m.sub_menu_id start with m.menu_id=grants.menu_id)

View Text - HTML Formatted

SELECT DISTINCT GRANTS.GRANT_GUID
, GRANTS.GRANTEE_KEY
, GRANTS.GRANTEE_TYPE
, GRANTS.OBJECT_ID
, GRANTS.INSTANCE_PK1_VALUE
, GRANTS.INSTANCE_PK2_VALUE
, GRANTS.INSTANCE_PK3_VALUE
, GRANTS.INSTANCE_PK4_VALUE
, GRANTS.INSTANCE_PK5_VALUE
, FUNCTIONS.FUNCTION_NAME
FROM FND_GRANTS GRANTS
, FND_MENU_ENTRIES ROLE_PRIVILEGES
, FND_FORM_FUNCTIONS FUNCTIONS
WHERE TRUNC(GRANTS.START_DATE)<= TRUNC(SYSDATE)
AND ( GRANTS.END_DATE IS NULL OR TRUNC(GRANTS.END_DATE) >= TRUNC(SYSDATE) )
AND GRANTS.INSTANCE_TYPE= 'INSTANCE'
AND ROLE_PRIVILEGES.FUNCTION_ID = FUNCTIONS.FUNCTION_ID
AND ROLE_PRIVILEGES.MENU_ID IN (SELECT M.MENU_ID
FROM FND_MENU_ENTRIES M CONNECT BY M.MENU_ID=PRIOR M.SUB_MENU_ID START WITH M.MENU_ID=GRANTS.MENU_ID)