SQL Query to get the expense report approver in Oracle Fusion

SQL Query to get the expense report approver in Oracle Fusion

Hi friends, we are going to discuss about the SQL Query to get the expense report approver name in Oracle Fusion. We will share the detail sql query which helps to fetch the approver name of the expense report in oracle fusion. Using this sql query we can able to find out the list of approvers which has approved the expense report in oracle fusion. Using this sql query we can develop the custom Expense report in oracle fusion. Here below , i will share the detail SQL Query to get the expense report approver in Oracle Fusion.

SQL Query to get the expense report approver in Oracle Fusion

3 Important Tables uses in the SQL Query to get the expense report approver in Oracle Fusion

1. PER_PERSON_NAMES_F_V

2. EXM_EXP_REP_PROCESSING

3. EXM_EXPENSE_REPORTS

Detail SQL Query to get the expense report approver in Oracle Fusion

Here below is the detail sql query find out the expense report approvers in oracle fusion

 SELECT display_name 

    from PER_PERSON_NAMES_F_V ppnfv,

          (select a1.event_performer_id from ( select eerp.event_performer_id

                               from EXM_EXP_REP_PROCESSING eerp,

                                    exm_expense_reports eer1

                              where eerp.expense_report_id = eer1.expense_report_id 

                                                            --and eerp.approval_level =1

                                and eer1.expense_report_num=:P_EXPENSE_NUMBER

                                and eerp.expense_status_code LIKE '%PEND_MGR_APPROVAL%'

                                and eerp.event_performer_id not in ('-1')

                                order by EVENT_DATE desc

                                )a1

                                where rownum=1) b

   where ppnfv.person_id = b.event_performer_id

      and ppnfv.effective_end_date > SYSDATE and rownum=1

SQL Query to get the expense report approver in Oracle Fusion