FND W3H_Role_Users

Description
Categories: Application, BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_Role_Users
DB package:
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
Ask a question