FND W3H_User_Objects

Description
Categories: BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_User_Objects
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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