SELECT ppx.full_name
,fu.user_name
,nvl(ppx.email_address
,fu.email_address) AS email_address,fl.end_time,fl.start_time,(fl.end_time-fl.start_time)
FROM apps.per_people_x ppx, apps.fnd_user fu, apps.fnd_logins fl
WHERE fl.start_time > SYSDATE - 2
AND fu.user_id = fl.user_id
AND ppx.person_id(+) = fu.employee_id
AND fu.user_name NOT IN ('INTERFACE', 'SYSADMIN', 'GUEST')
AND fu.user_name in (<enter the user names seperated by comma ','>)
AND fl.end_time is not null
GROUP BY ppx.full_name
,fu.user_name
,nvl(ppx.email_address
,fu.email_address)
,fl.end_time
,fl.start_time
ORDER BY 2Bookmark
No comments:
Post a Comment