Get workflow task history for Purchase Requisition (SQL Query)

Summary:

I need help to understand how can I get the WF task history to Purchase Requisition. I am trying to use the query below:

Content (please ensure you mask any confidential information):

SELECT
W.CREATEDDATE,
W.CREATOR,
W.UPDATEDDATE,
W.UPDATEDBY,
W.ASSIGNEES,
W.ASSIGNEESDISPLAYNAME,
W.APPROVERS,
W.VERSIONREASON,
W.STATE,
W.OUTCOME,
W.STAGE,
W.PARTICIPANTNAME,
W.ASSIGNMENTCONTEXT,
W.COMPOSITEVERSION,
W.ACTIVITYID,
W.TASKDEFINITIONNAME
FROM FA_FUSION_SOAINFRA.WFTASKHISTORY W
WHERE W.IDENTIFICATIONKEY IN
(SELECT TO_CHAR(REQUISITION_HEADER_ID) FROM FUSION.POR_REQUISITION_HEADERS_ALL
WHERE REQUISITION_NUMBER = 'XXXXXXXXX')
ORDER BY
W.UPDATEDDATE DESC

Version (include the version you are using, if applicable):