/* Responsibilities Sessions*/
SELECT usr.user_name, ful.login_id, ses.session_id,
TO_CHAR (ses.first_connect, 'YYYY/MM/DD HH24:MI:SS') first_connect,
TO_CHAR (ses.last_connect, 'YYYY/MM/DD HH24:MI:SS') last_connect,
ses.counter, ses.disabled_flag,
TO_CHAR (ful.end_time, 'YYYY/MM/DD HH24:MI:SS') end_time,
TO_CHAR (ful.start_time, 'YYYY/MM/DD HH24:MI:SS') start_time,
rsp.responsibility_name, fff.user_function_name
FROM icx_sessions ses,
fnd_user usr,
fnd_logins ful,
fnd_responsibility_tl rsp,
fnd_form_functions_vl fff
WHERE 1 = 1
/* joins */
AND ses.login_id(+) = ful.login_id
AND ses.responsibility_id = rsp.responsibility_id(+)
AND ses.responsibility_application_id = rsp.application_id(+)
AND ses.function_id = fff.function_id(+)
AND usr.user_id = ful.user_id
AND rsp.LANGUAGE(+) = USERENV ('LANG')
/* filters */
--and USR.USER_NAME like nvl(upper('&USER_NAME_FILTER'), '%')
AND ful.start_time > SYSDATE - 61 /* two month history */
ORDER BY ful.start_time
SELECT usr.user_name, ful.login_id, ses.session_id,
TO_CHAR (ses.first_connect, 'YYYY/MM/DD HH24:MI:SS') first_connect,
TO_CHAR (ses.last_connect, 'YYYY/MM/DD HH24:MI:SS') last_connect,
ses.counter, ses.disabled_flag,
TO_CHAR (ful.end_time, 'YYYY/MM/DD HH24:MI:SS') end_time,
TO_CHAR (ful.start_time, 'YYYY/MM/DD HH24:MI:SS') start_time,
rsp.responsibility_name, fff.user_function_name
FROM icx_sessions ses,
fnd_user usr,
fnd_logins ful,
fnd_responsibility_tl rsp,
fnd_form_functions_vl fff
WHERE 1 = 1
/* joins */
AND ses.login_id(+) = ful.login_id
AND ses.responsibility_id = rsp.responsibility_id(+)
AND ses.responsibility_application_id = rsp.application_id(+)
AND ses.function_id = fff.function_id(+)
AND usr.user_id = ful.user_id
AND rsp.LANGUAGE(+) = USERENV ('LANG')
/* filters */
--and USR.USER_NAME like nvl(upper('&USER_NAME_FILTER'), '%')
AND ful.start_time > SYSDATE - 61 /* two month history */
ORDER BY ful.start_time
No comments:
Post a Comment