find an approver from the setup tables
We don't have any report or workflow to check the potential approver once Invoice adjustment is submitted by the user in Receivables Module. so I am trying to develop a BI report to check potential approvers based on the ar_adjustment_all table. In this table, the approver column is getting updated once adjustment is approved by the approver. so I have written an attached sql query to find the corresponding approver from the setup tables but it returns duplicate values due to the multiple approvers.
Amount From Amount To Approver
-100 499 Approver1
-499 1000 Approver2
-50. 300 Approver3.