Link between Workflow Table (FA_FUSION_SOAINFRA.WFTASK) And project expenditure batch tables
We are trying to find out the link between the Workflow Table (FA_FUSION_SOAINFRA.WFTASK) and projects expenditure batch (PJC_EXP_ITEMS_ALL.USER_BATCH_NAME) tables to get the Approver details. Is there any another table which can provide the missing link between the two tables?
We have tried to execute the below query for expenditure batch but it's not fetching any details.
SELECT * FROM FA_FUSION_SOAINFRA.wftask WHERE COMPONENTNAME = 'ProjectExpenditureBatchApprovalTask' AND identificationkey like '%APC%ARE-8801%' --- Batch Name
We are looking for below similar query for expenditure batch also.
select * from FA_FUSION_SOAINFRA.WFTASK where componentname ='ProjectStatusNotificationApproval' and identificationkey = (select project_id from pjf_projects_all_b where segment1 = <Project Number>);