SELECT fu.user_name "User Name", papf.full_name "Employee Name",
NVL (papf.email_address, fu.email_address) "Email Address"
FROM per_all_people_f papf, fnd_user fu, fnd_logins fl
WHERE TRUNC (fl.start_time) = TRUNC (SYSDATE)
AND fu.user_id = fl.user_id
AND papf.person_id(+) = fu.employee_id
AND fu.user_name NOT IN ('INTERFACE', 'SYSADMIN', 'GUEST')
GROUP BY fu.user_name,
papf.full_name,
NVL (papf.email_address, fu.email_address)
ORDER BY fu.user_name
NVL (papf.email_address, fu.email_address) "Email Address"
FROM per_all_people_f papf, fnd_user fu, fnd_logins fl
WHERE TRUNC (fl.start_time) = TRUNC (SYSDATE)
AND fu.user_id = fl.user_id
AND papf.person_id(+) = fu.employee_id
AND fu.user_name NOT IN ('INTERFACE', 'SYSADMIN', 'GUEST')
GROUP BY fu.user_name,
papf.full_name,
NVL (papf.email_address, fu.email_address)
ORDER BY fu.user_name
No comments:
Post a Comment