Link between Workflow Table (FA_FUSION_SOAINFRA.WFTASKHISTORY) And PO/Requisition

Summary:

Hello,

I need to extract all notifications related to PO , Requsition and Credit card transactions

For PO I am working with

SELECT wfth.*
FROM fa_fusion_soainfra.wftaskhistory_sec wfth ,
fusion.po_versions_sec pov ,
fusion.po_headers_all_sec poh
WHERE wfth.compositeinstanceid = pov.approval_instance_id
AND pov.po_header_id = poh.po_header_id

but i do not find any matches

Content (please ensure you mask any confidential information):

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

Code Snippet (add any code snippets that support your topic, if applicable):