OKC_TEAM_USER_APP_ROLES

Details

Schema: FUSION
Object owner: OKC
Object type: VIEW

Columns

Name
USER_NAME USER_GUID SESSION_ID SESSION_DATE ROLE_NAME ROLE_GUID

Name

USER_NAME

USER_GUID

SESSION_ID

SESSION_DATE

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 , r.role_guid FROM fnd_sessions s, fnd_session_roles r WHERE s.session_id = r.session_id AND s.session_id IN ( SELECT session_id FROM fnd_sessions si WHERE si.user_name = s.user_name AND trunc(si.last_update_date) = trunc(SYSDATE) and rownum = 1 ) ORDER BY 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 , r.role_guid

FROM fnd_sessions s, fnd_session_roles r

WHERE s.session_id = r.session_id

AND s.session_id IN ( SELECT session_id FROM fnd_sessions si WHERE si.user_name = s.user_name AND trunc(si.last_update_date) = trunc(SYSDATE) and rownum = 1 )

ORDER BY r.role_name