List history of executed requests

Hi team,

I have request from our audit team to provide history information for one specific user responsibility which I have found by using this query:

SELECT DISTINCT fu.USER_NAME,

fl.start_time,

fl.END_TIME,

fl.LOGIN_TYPE,

ftl.RESPONSIBILITY_NAME

FROM FND_LOGINS fl,

fnd_user fu,

FND_LOGIN_RESPONSIBILITIES fr,

fnd_responsibility_tl ftl,

fnd_responsibility frr,

fnd_user_resp_groups_direct furg

WHERE fu.USER_ID = fl.USER_ID

AND fl.login_id = fr.login_id

AND fr.RESPONSIBILITY_ID = ftl.RESPONSIBILITY_ID

AND furg.responsibility_id = ftl.responsibility_id

AND frr.responsibility_id = ftl.responsibility_id