FND W3H_Object_RolesResp

➜ Back to Library
Description
Categories: BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_Object_RolesResp
DB package:
Run FND W3H_Object_RolesResp and other Oracle EBS reports with Blitz Report™ on our demo environment
select * from (	 
select fg.grantee_key  AS RoleName, fg.name AS GrantName, fnd_message.get_STRING('FND','W3H_YES_ACCESSIBILITY')  AS  Accessibility,
(select user_name from fnd_user where user_id=fg.created_by) AS GrantCreatedBy,
fg.creation_date AS GrantCreationDate,
(select user_name from fnd_user where user_id=fg.last_updated_by) AS GrantUpdatedBy,
fg.last_update_date AS GrantUpdateDate
from fnd_objects fo,fnd_grants fg
where fo.object_id=fg.object_id
and fg.start_date <= sysdate 
and (sysdate <= fg.end_date or fg.end_date is null)
and fo.obj_name= :PARAM1
and fg.grantee_type='GROUP'
union all
select fg.grantee_key AS RoleName,fg.name "Grant Name", fnd_message.get_STRING('FND','W3H_NO_ACCESSIBILITY') AS  Accessibility,
(select user_name from fnd_user where user_id=fg.created_by) AS GrantCreatedBy,
fg.creation_date  AS GrantCreationDate,
(select user_name from fnd_user where user_id=fg.last_updated_by) AS GrantUpdatedBy,
fg.last_update_date AS GrantUpdateDate
from fnd_objects fo,fnd_grants fg
where fo.object_id=fg.object_id
and (sysdate < fg.start_date  or sysdate > fg.end_date)
and fo.obj_name= :PARAM1 and fg.grantee_type='GROUP'
) &PARAM2
Download
Related Blitz Reports
FND W3H_Object_Users FND W3H_User_Objects FND W3H_Role_Objects GL Other - Definition Access By User FND W3H_Role_Functions FND W3H_User_Functions FND W3H_Function_Users RWB Security Blitz Report RDF Import Validation
Blitz Report™

Blitz Report™ provides multiple benefits: