FND W3H_User_Objects
Description
Categories: BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_User_Objects
DB package:
Source:
Short Name: W3H_User_Objects
DB package:
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 |