FND W3H_User_Objects

Description
Categories: BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_User_Objects
DB package:
Run FND W3H_User_Objects and other Oracle EBS reports with Blitz Report™ on our demo environment
select * from (        
select fo.obj_name as ObjName,fot.display_name,fo.database_object_name
from fnd_objects fo,fnd_objects_tl fot
where fot.object_id=fo.object_id and fot.language=userenv('LANG')
and fo.object_id in
(
select object_id from fnd_grants
where object_id <> -1
and (start_date <= sysdate and (end_date is null or sysdate <= end_date))
and grantee_key in
(select role_name from wf_user_role_assignments where user_name= :PARAM1
and (effective_start_date <= sysdate or effective_start_date is null)
and (effective_end_date is null or sysdate <= effective_end_date))
union
select object_id from fnd_grants
where object_id <> -1
and (start_date <= sysdate and (end_date is null or sysdate <= end_date))
and grantee_type='GLOBAL')
) &PARAM2