[Home] [Help]
View: FND_GRANTS_VIEW
| Product: | FND - Application Object Library |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
 APPS.FND_GRANTS_VIEW
|
|---|
View Text
SELECT
G.GRANT_GUID
,
WUR.USER_NAME
,
F.FUNCTION_NAME
,
WUR.START_DATE USER_ROLE_START_DATE
,
WUR.EXPIRATION_DATE USER_ROLE_END_DATE
,
G.START_DATE GRANT_OR_RESP_START_DATE
,
G.END_DATE GRANT_OR_RESP_END_DATE
,
OBJ.OBJ_NAME
,
G.INSTANCE_TYPE
,
INS.INSTANCE_SET_NAME
,
G.INSTANCE_PK1_VALUE
,
G.INSTANCE_PK2_VALUE
,
G.INSTANCE_PK3_VALUE
,
G.INSTANCE_PK4_VALUE
,
G.INSTANCE_PK5_VALUE
,
G.PROGRAM_NAME
,
G.PROGRAM_TAG
,
G.CREATED_BY
,
G.CREATION_DATE
,
G.LAST_UPDATED_BY
,
G.LAST_UPDATE_DATE
,
G.LAST_UPDATE_LOGIN
,
SG.SECURITY_GROUP_KEY CTX_SECGRP_KEY
,
R.RESPONSIBILITY_KEY CTX_RESP_KEY
,
A.APPLICATION_SHORT_NAME CTX_RESP_APP_SHORT_NAME
,
G.CTX_ORG_ID
,
G.PARAMETER1
,
G.PARAMETER2
,
G.PARAMETER3
,
G.PARAMETER4
,
G.PARAMETER5
,
G.PARAMETER6
,
G.PARAMETER7
,
G.PARAMETER8
,
G.PARAMETER9
,
G.PARAMETER10
,
G.NAME
,
G.DESCRIPTION
FROM FND_GRANTS G
,
FND_COMPILED_MENU_FUNCTIONS CMF
,
FND_FORM_FUNCTIONS F
,
WF_USER_ROLES WUR
,
FND_RESPONSIBILITY R
,
FND_SECURITY_GROUPS SG
,
FND_OBJECT_INSTANCE_SETS INS
,
FND_OBJECTS OBJ
,
FND_APPLICATION A
WHERE G.MENU_ID = CMF.MENU_ID
AND CMF.FUNCTION_ID = F.FUNCTION_ID
AND G.GRANTEE_KEY = WUR.ROLE_NAME (+)
AND G.OBJECT_ID = OBJ.OBJECT_ID (+)
AND G.INSTANCE_SET_ID = INS.INSTANCE_SET_ID (+)
AND G.CTX_RESP_ID = R.RESPONSIBILITY_ID (+)
AND G.CTX_RESP_APPL_ID = R.APPLICATION_ID (+)
AND G.CTX_SECGRP_ID = SG.SECURITY_GROUP_ID (+)
AND R.APPLICATION_ID = A.APPLICATION_ID (+)