SELECT DISTINCT user_name,
TO_CHAR(last_logon_date,'DD-MON-YYYY HH24:MI:SS') LAST_LOGIN_DATE,
papf.full_name,
(select name from hr_organization_units where organization_id = paaf.ORGANIZATION_ID) department_name
FROM fnd_user fu, per_all_people_f papf,per_all_assignments_f paaf
WHERE last_logon_date >=sysdate-14
--and fu.user_name like 'H%'
and paaf.person_id = fu.employee_id
and paaf.person_id = papf.person_id
order by 4,2,1 desc
TO_CHAR(last_logon_date,'DD-MON-YYYY HH24:MI:SS') LAST_LOGIN_DATE,
papf.full_name,
(select name from hr_organization_units where organization_id = paaf.ORGANIZATION_ID) department_name
FROM fnd_user fu, per_all_people_f papf,per_all_assignments_f paaf
WHERE last_logon_date >=sysdate-14
--and fu.user_name like 'H%'
and paaf.person_id = fu.employee_id
and paaf.person_id = papf.person_id
order by 4,2,1 desc
No comments:
Post a Comment