1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| select cu.cx_user_oid,
cu.user_name as FIRST_AND_LAST_NAMES,
cu.user_id as USER_ID,
csl.authentication_id as AUTHENT_ID,
--token
decode(cu.active_status, 'I', 'Inactive', 'A', 'Active', 'D', 'Deactivated') as STATUS,
--culd.login_timestamp, -- a verifier, pas bon cx_user login date
NVL(decode(cu.authorizer_status,'A','Y','I','N','N','N'), '?') as "IS_AUTHORIZER?",
NVL(cu.is_initiater, '?') as "IS_INITIATER?",
NVL(cu.is_watcher, '?') as "IS_WATCHER?"
--cp.
from connexis.cx_entity ce, connexis.cx_sealed_letter csl, connexis.cx_user cu, connexis.cx_profile cp
left outer join connexis.cx_user_login_date culd on culd.cx_user_oid = connexis.cx_user.cx_user_oid
where csl.cx_user_oid = cu.cx_user_oid
and cu.cx_entity_oid = ce.cx_entity_oid
and cp.cx_profile_oid = nvl(cu.cx_private_profile_oid, cu.cx_public_profile_oid)
and ce.entity_id = 'toto' |
Partager