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

To fetch all the approval group details for a journal.

edited Nov 13, 2025 9:33AM in Reporting and Analytics for ERP

Hi,

I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal.
Please provide me a SQL query on how to join workflow tables with GL tables (like GL_JE_ACTION_LOG, GL_JE_BATCHES etc.,) to fetch the approval group details for a specific journal.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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