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?
