Sunday, February 9, 2020

Responsibilities Sessions

/* 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

No comments:

Post a Comment