Skip to main content

Query to find the last access date to a Responsibility in R12



SELECT frt.responsibility_name,
       Max(flr.start_time)
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 = '&Username' -- Comment for Complete List
       AND frt.responsibility_id = flr.responsibility_id
GROUP  BY frt.responsibility_name 

Comments