SELECT c.username ,c.created , --c.lock_date, c.account_status ,( SELECT max(b.modified_date) last_logon FROM FNDRR_USER_CLIENT_PROFILE_TAB a ,FNDRR_CLIENT_PROFILE_VALUE_TAB b WHERE a.USER_ID NOT LIKE 'IFS%' AND a.ordinal = 0 AND fnd_user_api.Get_Active(a.user_id) = 'TRUE' AND b.profile_id(+) = a.profile_id AND a.user_id = c.USERNAME GROUP BY a.user_id ) Last_Logon_Time FROM dba_users c WHERE c.account_status = 'OPEN' AND c.USERNAME NOT LIKE 'IFS%' AND c.USERNAME NOT LIKE 'SYS%' AND c.USERNAME NOT IN ('DOCVUETICKETUSER')
2 yıl önce
0 yorum:
Yorum Gönder