Last updated on SEPTEMBER 02, 2016
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms