Find whether user is active or Inactive in EBS

Query to Find whether user is active or Inactive in EBS

SQL :

SELECT ‘Active’, valid.*  FROM fnd_user valid WHERE valid.user_id IN 

(SELECT user_id FROM fnd_user WHERE NVL (end_date, SYSDATE) >= SYSDATE)

UNION ALLSELECT ‘In Active’, invalid.*  FROM fnd_user invalid 

WHERE invalid.user_id IN (SELECT user_id FROM fnd_user 

WHERE NVL (end_date, SYSDATE) < SYSDATE)ORDER BY 2;