Featured post

Functionality of Segment Value Inheritance ESS Process

  The Segment Value Inheritance process simplifies the maintenance of the chart of accounts. When the characteristics of values in the value...

Saturday 11 November 2017

IExpenses and Oracle AP - AP EXP REPORT and AP INVOICE DISTRIBUTIONS

SELECT COUNT (*) 
FROM ap_invoices_all aia, ap_expense_report_headers_all aerha 
WHERE aerha.report_header_id = aia.reference_key1 
AND aia.product_table = 'AP_EXPENSE_REPORT_HEADERS_ALL' 

No comments:

Post a Comment

Please review my topic and update your comments

Note: only a member of this blog may post a comment.