Monday 1 April 2013

Oracle Apps IExpenses Query


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



ap_expense_report_headers_all
ap_expense_report_lines_all

ap_pol_headers
ap_pol_lines

No comments:

Post a Comment