FND W3H_Role_Users

➜ Back to Library
Description
Categories: BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_Role_Users
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 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
Download
 
Related Blitz Reports
FND User Roles FND User Roles 11i FND W3H_User_Roles FND Roles FND W3H_Role_Functions WH Notifications disabled GCS Consolidation Entries Writeback OKL Termination Quotes FND W3H_Role_Objects
Blitz Report™

Blitz Report™ provides multiple benefits: