General Ledger workflow process activities

oracle apps General Ledger SQL to get the complete workflow Item and process activities for a particular Journal Batch

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

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.