ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
82288223EF913869E053B46B63588994Y
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
FND
W3H_User_Objects
AR
FND W3H_User_Objects
Application: مكتبة وحدات التطبيقات
Source:
Short Name: W3H_User_Objects
DB package:
D
FND W3H_User_Objects
Application: Basisbibliothek
Source:
Short Name: W3H_User_Objects
DB package:
US
FND W3H_User_Objects
Application: Application Object Library
Source:
Short Name: W3H_User_Objects
DB package:
ZHS
FND W3H_User_Objects
Application: 应用对象程序库
Source:
Short Name: W3H_User_Objects
DB package:
BI Publisher
¶m2
:param1