SELECT Person.FIRST_NAME,
       Person.LAST_NAME,
       Person.PERSON_ID,
       Person.COMPANY_NR,
       VoPersonCategory.NAME CAT_NAME
FROM V_UPDATABLE_PERSON Person, GU_PERSON GuPerson, V_UPDATABLE_VO_PERSON_CATEGORY VoPersonCategory, PERSON_ROLE PersonRole, VO_ROLE VoRole, ROLE Role
WHERE GuPerson.PERSON_ID = Person.PERSON_ID
AND Person.VO_PERSON_CATEGORY_ID = VoPersonCategory.VO_PERSON_CATEGORY_ID
AND GuPerson.GUI_USER_ID = 144151
AND person.person_status_id = 0
AND Person.PERSON_ID = PersonRole.PERSON_ID
AND PersonRole.VO_ROLE_ID = VoRole.VO_ROLE_ID
AND VoRole.ROLE_ID = Role.ROLE_ID
AND Role.VALIDATION_STATUS_ID >= 81
GROUP BY Person.FIRST_NAME,Person.LAST_NAME,Person.PERSON_ID, Person.COMPANY_NR,VoPersonCategory.NAME
ORDER BY Person.LAST_NAME,Person.FIRST_NAME;