Find Client IP Address logged in to EBS 12

Below query will provide the list of all application users connected to EBS with their client IP-Addresses.

SELECT distinct 

        d.user_name

       ,c.CLIENTIP

FROM fnd_logins c, 

       fnd_user d

WHERE d.user_id = c.user_id

AND c.end_time IS NULL;