sql query for list all users who have not logged on in oracle apps r12

We can use this query for your requirement.

SELECT pap.full_name,user_name,to_char(last_logon_date,'DD-MON-YYYY HH24:MI:SS AM') last_logon_date,

to_char(end_date,'DD-MON-YYYY HH24:MI:SS AM') end_date

FROM fnd_user fu,

     per_all_people_f pap

WHERE fu.employee_id = pap.person_id

AND fu.user_name NOT IN (SELECT user_name

                                         FROM   fnd_user

                                         WHERE  1=1

                                          AND end_date IS NULL

                                           AND  last_logon_date >= TRUNC(sysdate)-2)

ORDER BY pap.full_name