Apps- Query to find Active & In Active User's List in EBS

Query to find  Active & In Active User's List in EBS


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 ALL
SELECT '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;