What is the link between batch name and ESS job Import Journals ?

Hello,

We need to query the details of a journal batch (Batch name) with the schedule process (ESS Job 'Import Journals') that created that journal batch.

We obtain the batch name from the oracle table GL_JE_BATCHES and we obtain the schedule process details from the table FUSION.ESS_REQUEST_PROPERTY.

Grateful if you could show us how to link these two tables or if any there is any other alternatives to obtain the requested details.

Regards,