EBS custom Audit report
Hi,
i am looking for a query to get details of all EBS users and all their responsibilities last logon date. i am using below queries to get last login date of responsibility. but it is not getting details of responsibility which was not logged in by users.please help me on this query to get details of all users and all their responsibilities. if he not logged in to resp it should show as null date. this is for Audit requirement.
select max(flr.start_time), flr.responsibility_id ,fu.user_name,
flt.responsibility_name
from fnd_logins fl, fnd_login_Responsibilities flr, fnd_user fu ,