R12: Iexpense Expense Reports Join To Ap Invoices
(Doc ID 1914546.1)
Last updated on JULY 01, 2019
Applies to:Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
User would like to confirm the join from iexpense tables to ap invoice tables.
ap_expense_report_headers_all.vouchno = ap_invoices_all.invoice_id
ap_expense_report_lines_all.distribution_line_number = ap_invoice_lines_all.line_number
ap_expense_report_lines_all.report_header_id = ap_invoices_all.reference_key1
ap_expense_report_lines_all.report_line_id = ap_invoices_all.reference_key2
1. Are the joins above correct?
2. Is it possible that a single ap_expense_report_lines_all can point to more than one ap_invoice_lines_all record?
3. This 2nd question is concerned with the associated ap_invoice_distributions_all records. If after joining ap_expense_report_lines_all to ap_invoice_lines_all record we then join to ap_invoice_distributions_all and filter ap_invoice_distribution_all where line_type_lookup_code = 'ITEM', is it possible that there could be more than 1 ap_invoice_distributions_all record?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document