Query to get non person account details

Summary

Query to get non person account details

Content

Using the below query to get the non person account details but for few users the first name, lastname and email addresses are blank.

SELECT DISTINCT

    PU.USERNAME,

    PLU.FIRST_NAME,

    PLU.LAST_NAME,

    PLU.EMAIL

   

    FROM

    PER_USERS PU,

    PER_LDAP_USERS PLU,

    PER_USER_ROLES PUR

 

    WHERE

    NOT EXISTS(SELECT 1 FROM PER_ALL_PEOPLE_F PER WHERE PU.PERSON_ID = PER.PERSON_ID)

    AND PU.USER_ID = PUR.USER_ID

    AND PUR.ACTIVE_FLAG = 'Y'

    AND PLU.USERNAME(+) = PU.USERNAME

    AND (PLU.LAST_UPDATE_DATE = (SELECT MAX(PLU1.LAST_UPDATE_DATE) FROM PER_LDAP_USERS PLU1 WHERE PU.USERNAME = PLU1.USERNAME) OR PLU.LAST_UPDATE_DATE is null)