IFS User Last Logon Time

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')

Detaylar