Query to get Approver Details of Ad-hoc payment in Cash management

Summary:

Need Query or Joins to get Approver Details of Ad-hoc payments in Cash Management

Content (please ensure you mask any confidential information):

Hello Experts,

Is there any joins between the tables below. My requirement is to get Approver details of Ad-hoc payments made in Cash Management in Oracle fusion. I have gone through Oracle table docs, but unable to find joins.

1. ce_external_transactions

2.ce_bat_transfers

3.Iby_payments_all

4.fnd_bpm_task_vl

5.fnd_bpm_task_history_vl

Thanks & Regards,

Sai Kumar

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):