Friday 7 September 2012

Oracle Apps IExpenses Tables

The below query for relation ship between Oracle IExpenses  and Oracle Payables.
The below query will give the End to End details raising expense report to Payments made  against.

select *
  from ap_expense_report_headers_all aerha
      ,ap_expense_report_lines_all aerla
      ,ap_expense_report_params_all aerpa
      ,per_all_people_f papf
      ,ap_invoices_all aia
      ,ap_invoice_payments_all aipa
      ,ap_checks_all aca
 where aerha.employee_id = papf.person_id
   and aerha.report_header_id = aerla.report_header_id
   and aerla.web_parameter_id = aerpa.parameter_id
   and aerha.expense_status_code = 'PAID'
   and papf.effective_end_date >= trunc(sysdate)
   and aerha.invoice_num = aia.invoice_num
   and aia.invoice_id = aipa.invoice_id
   and aipa.check_id = aca.check_id

2 comments:

  1. could u give me the monthly basis records

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete