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
(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