You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Link between Workflow Table (FA_FUSION_SOAINFRA.WFTASK) And project expenditure batch tables

Accepted answer


Content (required):

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>);

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!