Query to get the Approver Details for Expense Report (Doc ID 2279634.1) in Oracle Fusion

SELECT er.expense_report_id

      ,er.expense_report_num

      ,er.expense_report_total

      ,er.reimbursement_currency_code

      ,er.person_id

      ,er.expense_report_date

      ,er.expense_status_code

      ,approval.event

      ,approval.event_performer_id

      ,approval.event_date

      ,approval.approval_level

      ,approval.expense_status_code approval_status

      ,approval.audit_code

      ,approval.audit_return_reason_code

      ,approval.export_reject_code

  FROM exm_expense_reports er

      ,exm_exp_rep_processing approval

 WHERE er.expense_report_id= approval.expense_report_id

   AND er.expense_report_num='EXP00000123456'

ORDER BY approval.approval_level