How Extract flexfield attributes of department

Content

Hello Guys,

I need to extract the flex-field attributes of department, but by using this query I don't find any things. Moreover, I have a lot of duplicate rows with the same value how i can resolve?

This is the query I used:

select FIRST_NAME, LAST_NAME, name.PERSON_ID, org.name as Department, info.*
    from PER_PERSON_NAMES_F name
    join PER_ALL_ASSIGNMENTS_M assignment on name.PERSON_ID = assignment.PERSON_ID
    join HR_ORGANIZATION_UNITS_F_TL org on assignment.ORGANIZATION_ID = org.ORGANIZATION_ID
    join HR_ORGANIZATION_INFORMATION_F info on info.ORGANIZATION_ID = org.ORGANIZATION_ID