OKC_TEAM_USER_SESSION_ROLES

Details

Schema: FUSION
Object owner: OKC
Object type: VIEW

Columns

Name
USER_NAME USER_GUID SESSION_ID SESSION_DATE ROLE_CODE ROLE_NAME ROLE_GUID

Name

USER_NAME

USER_GUID

SESSION_ID

SESSION_DATE

ROLE_CODE

ROLE_NAME

ROLE_GUID

Query

SQL_Statement
SELECT s.user_name, s.user_guid , s.session_id, s.last_update_date AS session_date, r.role_name AS role_code , er.role_name AS role_name ,r.role_guid AS role_guid FROM fnd_sessions s, fnd_session_roles r , per_roles_dn_vl er WHERE s.session_id = r.session_id AND r.role_guid = er.role_guid(+) AND s.session_id IN ( SELECT max(session_id) FROM fnd_sessions si WHERE si.user_name = s.user_name AND trunc(si.last_update_date) >= trunc(SYSDATE - 1) ) ORDER BY s.last_update_date, s.user_name, r.role_name

SQL_Statement

SELECT s.user_name, s.user_guid , s.session_id, s.last_update_date AS session_date, r.role_name AS role_code , er.role_name AS role_name ,r.role_guid AS role_guid

FROM fnd_sessions s, fnd_session_roles r , per_roles_dn_vl er

WHERE s.session_id = r.session_id

AND r.role_guid = er.role_guid(+)

AND s.session_id IN ( SELECT max(session_id) FROM fnd_sessions si WHERE si.user_name = s.user_name AND trunc(si.last_update_date) >= trunc(SYSDATE - 1) )

ORDER BY s.last_update_date, s.user_name, r.role_name