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 (+)
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 (+)
|
|
|