How to show unique record of a user for approval with title in BI report

Dhanashree

select upper(W.ASSIGNEESDISPLAYNAME) APPROVER_NAME,

W.TITLE,

 W.TASKNUMBER,

 W.ASSIGNEDDATE,

 W.category,

 W.ASSIGNMENTCONTEXT,

 pef.DISPLAY_NAME Creator_name 

from

 FA_FUSION_SOAINFRA.WFTASKHISTORY W,

 PER_USERS pu,

 per_person_names_f pef

where 1=1 

 AND OUTCOME IS NULL

 AND WORKFLOWPATTERN <> 'FYI'

 and STATE not in ('WITHDRAWN')

AND SUBSTATE not in ( 'DELEGATED')

 AND W.CREATOR = PU.USERNAME(+)

 AND PU.PERSON_ID = PEF.PERSON_ID (+)

 AND NAME_TYPE (+)= 'GLOBAL'

 AND pef.DISPLAY_NAME is not NULL

 AND WORKFLOWPATTERN= 'ApprovalRequest'

ORDER BY ASSIGNEDDATE

This is query but it will showing 2 records of each user.

Anyone can help with the same?