View: BIS_GRANTS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_GRANTS_V

View Text

SELECT FG.GRANTEE_KEY GRANTED_TO
, FG.MENU_ID ROLE_ID
, AKRIE.REGION_CODE REPORT_REGION_CODE
, FG.INSTANCE_PK1_VALUE GRANTED_FOR
, FG.PARAMETER1 DELEGATION_PARAMETER
, FG.START_DATE
, FG.END_DATE
, FG.CREATED_BY
, FG.CREATION_DATE
, FG.LAST_UPDATED_BY
, FG.LAST_UPDATE_DATE
, FG.LAST_UPDATE_LOGIN
FROM FND_FORM_FUNCTIONS F
, FND_MENU_ENTRIES ME
, FND_GRANTS FG
, BIS_AK_REGION_ITEM_EXTENSION AKRIE
WHERE ME.MENU_ID = FG.MENU_ID
AND F.FUNCTION_ID= ME.FUNCTION_ID
AND ( AKRIE.ATTRIBUTE24 = F.FUNCTION_NAME OR AKRIE.ATTRIBUTE24 LIKE '%
, '||F.FUNCTION_NAME||'
, %' OR AKRIE.ATTRIBUTE24 LIKE '%
, '||F.FUNCTION_NAME OR AKRIE.ATTRIBUTE24 LIKE F.FUNCTION_NAME || '
, %')
AND GRANTEE_TYPE = 'USER'
AND INSTANCE_TYPE = 'INSTANCE'
AND PROGRAM_NAME = 'BIS_PMV_GRANTS'
AND FG.OBJECT_ID = ( SELECT OBJECT_ID
FROM FND_OBJECTS
WHERE OBJ_NAME = 'HRI_PER' )