Search Results ap_invoice_lines_v




Overview
Explore in AI Chat

Overview

AP_INVOICE_LINES_V is an APPS-schema view within the Oracle E-Business Suite Payables (AP) module, provided by Oracle as a reporting and enquiry interface over invoice line data. It exposes a denormalised, readable representation of rows held in AP_INVOICE_LINES_ALL, joined to invoice headers in AP_INVOICES_ALL and enriched with descriptive values resolved through lookup views and API packages. The view is a core building block for Oracle Payables inquiry forms, Oracle Payments, and third-party reporting tools that require line-level accounts payable detail without navigating the normalisation of the underlying transaction tables.

Among the attributes it exposes is DEFERRED_NUMBER_OF_PERIODS, which corresponds to DEF_ACCTG_NUMBER_OF_PERIODS on the base line table. This column records the number of accounting periods over which a line amount is to be recognised when deferred accounting is applied, and it is meaningful only when the DEFERRED_ACCTG_FLAG is set. It is used together with DEFERRED_START_DATE and DEFERRED_END_DATE to drive the period-by-period creation of accounting entries.

Underlying Base Objects

The view is defined primarily over AP_INVOICE_LINES_ALL, aliased as AIL, which supplies invoice line attributes including amounts, quantities, matching references, deferred accounting attributes and accounting flexfield segments. Invoice header context is drawn from AP_INVOICES_ALL. Distribution set information is joined from AP_DISTRIBUTION_SETS_ALL through DISTRIBUTION_SET_ID. Lookup descriptions are resolved via AP_LOOKUP_CODES, which supplies the displayed LINE_TYPE and workflow approval status values.

Reference data is joined from a broad set of purchasing, receiving, project and HR objects, including PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_RELEASES_ALL, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES and RCV_TRANSACTIONS for matched and received lines. Project and task information is resolved through PA_PROJECTS_ALL, PA_TASKS_EXPEND_V, PA_TASK_UTILS and PA_UTILS4, while HR_ORGANIZATION_UNITS, HR_LOCATIONS and HR_SECURITY support organisation and location display. Set of books and period context is obtained from GL_SETS_OF_BOOKS and FA_BOOK_CONTROLS, and runtime security and profile values come from FND_GLOBAL, FND_PROFILE and HR_GENERAL. PL/SQL logic is embedded through AP_INVOICES_UTILITY_PKG, AP_INVOICE_LINES_UTILITY_PKG, AP_MATCHING_UTILS_PKG and AP_AWT_GROUPS for withholding group resolution.

Key Columns

Common Use Cases and Queries

The view is commonly used for invoice line extracts, deferred accounting analysis, unmatched or matched line reconciliation, and approval status reporting. A typical query retrieving deferred lines and their recognition period count would be:

  • SELECT invoice_id, line_number, line_type, amount, deferred_acctg_flag, deferred_start_date, deferred_end_date, deferred_number_of_periods, deferred_period_type FROM ap_invoice_lines_v WHERE org_id = :p_org_id AND deferred_acctg_flag = 'Y' AND deferred_number_of_periods > 1;
  • SELECT invoice_id, line_number, line_type, amount, match_type, quantity_invoiced, unit_price FROM ap_invoice_lines_v WHERE invoice_id = :p_invoice_id ORDER BY line_number;
  • SELECT period_name, SUM(amount) FROM ap_invoice_lines_v WHERE set_of_books_id = :p_sob_id GROUP BY period_name;

Because the view applies HR security and profile-based filtering, results are restricted to organisations and ledgers visible to the requesting user. Consumers should expect slower performance than direct queries against AP_INVOICE_LINES_ALL and should restrict results by INVOICE_ID, ORG_ID or PERIOD_NAME wherever possible.