Thursday 2 April 2015

EBS : List of EBS users with their responsibilities

select fu.user_name,frv.responsibility_name,papf.full_name,papf.previous_last_name,
(select name from hr_organization_units where organization_id = paaf.ORGANIZATION_ID) department_name
from FND_USER_RESP_GROUPS_DIRECT furgd,fnd_user fu,
                         fnd_responsibility_vl frv,per_all_assignments_f paaf,per_all_people_f papf
       where furgd.user_id = fu.user_id
       and furgd.responsibility_id = frv.responsibility_id
       --and fu.user_name like 'H%'
       and paaf.person_id = fu.employee_id
       and paaf.person_id = papf.person_id
       order by 5,1

No comments:

Post a Comment

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...