VIEW: APPS.BIS_GRANTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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