How to Find Table with Approver Details for General Ledger Lines.
Summary
I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this information.Content
Query currently being used however i have been unable to find the approver information.
SELECT
gjh.JE_BATCH_ID ,
gjb.name BATCH_NAME,
gjh.JE_HEADER_ID,
gjc.USER_JE_CATEGORY_NAME,
gjs.USER_JE_SOURCE_NAME,
gjh.PERIOD_NAME,
gjh.name JOURNAL_NAME,
gjh.CURRENCY_CODE,
gjh.CREATION_DATE,
gjh.CREATED_BY,
gjh.POSTED_DATE,
gl.name LEDGER,
gjl.JE_LINE_NUM,
gjl.STATUS,
gjl.EFFECTIVE_DATE,
gjl.ACCOUNTED_DR,
1