SELECT
frt.responsibility_name,
fu.user_name,
MAX(flr.start_time) "Last Connect"
FROM
applsys.fnd_login_responsibilities flr,
applsys.fnd_user fu,
applsys.fnd_logins fl,
applsys.fnd_responsibility_tl frt
WHERE
fl.login_id = flr.login_id
AND fl.user_id = fu.user_id
AND fu.user_name = 'SANDEEP_SHARMA' -- Username
AND frt.responsibility_id = flr.responsibility_id
--and frt.responsibility_name = '&ResponsibilityName'
GROUP BY
frt.responsibility_name,
fu.user_name;
frt.responsibility_name,
fu.user_name,
MAX(flr.start_time) "Last Connect"
FROM
applsys.fnd_login_responsibilities flr,
applsys.fnd_user fu,
applsys.fnd_logins fl,
applsys.fnd_responsibility_tl frt
WHERE
fl.login_id = flr.login_id
AND fl.user_id = fu.user_id
AND fu.user_name = 'SANDEEP_SHARMA' -- Username
AND frt.responsibility_id = flr.responsibility_id
--and frt.responsibility_name = '&ResponsibilityName'
GROUP BY
frt.responsibility_name,
fu.user_name;
No comments:
Post a Comment