SELECT A.FIRST_NAME , A.LAST_NAME , A.FULL_NAME , A.EMAIL_ADDRESS , A.PERSON_ID , C.NAME , B.LOCATION_CODE , B.TOWN_OR_CITY FROM HR_LOCATIONS B , HR_ORGANIZATION_UNITS C , PER_ASSIGNMENTS_X D , PER_PEOPLE_X A WHERE A.PERSON_ID = D.PERSON_ID AND D.PRIMARY_FLAG = 'Y' AND D.ORGANIZATION_ID = C.ORGANIZATION_ID AND D.LOCATION_ID = B.LOCATION_ID(+)