GL SQL to get workflow Item details for a Journal Batch

Posted by

General Ledger SQL Query  to get Journal Batch workflow Item and process activities:

SELECT WF_PROCESS.PROCESS_NAME,
WF_IT_ACT_STATUS.*
FROM WF_ITEM_ACTIVITY_STATUSES WF_IT_ACT_STATUS,
WF_PROCESS_ACTIVITIES WF_PROCESS
WHERE 1=1
AND ITEM_KEY LIKE '%<PROVIDE_JE_BATCH_ID>%'
AND WF_IT_ACT_STATUS.ITEM_TYPE = 'GLBATCH'
AND WF_PROCESS.INSTANCE_ID = WF_IT_ACT_STATUS.PROCESS_ACTIVITY
ORDER BY BEGIN_DATE, END_DATE