ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
82288223EF8F3869E053B46B63588994Y
select * from (
select distinct usr.user_name as UserName,
decode((usr.start_date-sysdate)-abs(usr.start_date-sysdate),0,fnd_message.get_STRING('FND','W3H_SHOW_INACTIVE_FUNCTIONS'),
decode((nvl(usr.end_date,sysdate+1)-sysdate)-abs((nvl(usr.end_date,sysdate+1)-sysdate)),0,
fnd_message.get_STRING('FND','W3H_SHOW_ACTIVE_FUNCTIONS'),fnd_message.get_STRING('FND','W3H_SHOW_INACTIVE_FUNCTIONS'))) User_Status,
decode( UMX_W3H_UTL.isFunctionAccessible(wur.user_name,wur.role_name),'true' ,fnd_message.get_STRING('FND','W3H_SHOW_ACTIVE_FUNCTIONS'),
fnd_message.get_STRING('FND','W3H_SHOW_INACTIVE_FUNCTIONS') ) Assignment_Status,
decode(wur.assignment_type,'D',fnd_message.get_STRING('FND','W3H_DIRECT_ASSIGNMENTTYPE'),'I',fnd_message.get_STRING('FND','W3H_INDIRECT_ASSIGNMENTTYPE'),'B',fnd_message.get_STRING('FND','W3H_BOTH_ASSIGNMENTTYPE'))
Assignment_Type
from fnd_user usr,wf_local_user_roles wur
where usr.user_name=wur.user_name and wur.role_name= :PARAM1
and (wur.role_orig_system='FND_RESP' or wur.role_orig_system='UMX')
) &PARAM2
FND
W3H_Role_Users
AR
FND W3H_Role_Users
Application: مكتبة وحدات التطبيقات
Source:
Short Name: W3H_Role_Users
DB package:
D
FND W3H_Role_Users
Application: Basisbibliothek
Source:
Short Name: W3H_Role_Users
DB package:
US
FND W3H_Role_Users
Application: Application Object Library
Source:
Short Name: W3H_Role_Users
DB package:
ZHS
FND W3H_Role_Users
Application: 应用对象程序库
Source:
Short Name: W3H_Role_Users
DB package:
BI Publisher
¶m2
:param1