SELECT DISTINCT fu.user_name user_name
,to_char(ic.first_connect, 'DD-Mon-YYYY HH12: MI: SS AM') "First conn"
,to_char(ic.last_connect, 'DD-Mon-YYYY HH12: MI: SS AM')"Last conn"
,decode((ic.disabled_flag), 'N', 'ACTIVE', 'Y', 'INACTIVE') status
,fvl.responsibility_name "Resp"
,ic.function_type
,ic.time_out
,fu.user_id
,ic.org_id
,fr.menu_id
FROM fnd_user fu
,fnd_responsibility fr
,icx_sessions ic
,apps.fnd_responsibility_vl fvl
WHERE fu.user_id = ic.user_id
AND fr.responsibility_key = fvl.responsibility_key
AND fr.responsibility_id = ic.responsibility_id
AND ic.disabled_flag = 'N'
AND ic.responsibility_id IS NOT NULL
AND ic.last_connect > SYSDATE - (ic.time_out / 60) / 96;
NOTE: Copied Code.
No comments:
Post a Comment