Results for “to_invoice_line_number”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_APPLICABLE_LINES_V is a Payables (AP) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented status is VALID. The view presents a restricted, report-friendly projection of invoice line data, joining invoice line records to their descriptive line-type values. Rather than exposing the full breadth of AP_INVOICE_LINES, it returns a focused set of columns intended for inquiry, reporting, and integration scenarios where the consumer needs line-level detail together with a human-readable line type.

The name itself signals its purpose: it exposes lines that are "applicable" for downstream processing and reporting. The view text is defined over AP_INVOICE_LINES and AP_LOOKUP_CODES, with a row identifier (ROWID) surfaced as ROW_ID for direct row addressing. This design makes it convenient for tools and custom reports that need to reference an individual invoice line unambiguously. The view is commonly encountered in Payables-related extracts and in query tools where a concise, decoded view of invoice lines is preferred over the wide base table.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over three referenced objects:

• AP_INVOICE_LINES (referenced through a synonym) — the primary source of invoice line records.
• AP_LOOKUP_CODES (referenced as a view) — supplies the decoded display value for the invoice line type.
• FND_GLOBAL (package) — a standard EBS runtime dependency used for session context such as organization and user information.

The view joins AP_INVOICE_LINES to AP_LOOKUP_CODES with the condition that the lookup type equals 'INVOICE LINE TYPE' and the line's LINE_TYPE_LOOKUP_CODE matches the lookup code. This correlation equates each line to a descriptive line-type label. The alias structure shown in the view text uses AIL for the invoice lines and ALC for the lookup codes.

Key Columns

The documented column list is concise and stable across 12.1.1 and 12.2.2:

• ROW_ID — the ROWID of the underlying AP_INVOICE_LINES row, enabling direct row addressing.
• INVOICE_ID — the identifier of the parent invoice header.
• TO_INVOICE_LINE_NUMBER — exposed from LINE_NUMBER; this is the column most relevant to the user's search term, representing the line number of the invoice line as used in matching and distribution logic.
• LINE_TYPE_LOOKUP_CODE — the stored code classifying the invoice line type.
• LINE_TYPE — the decoded display value derived from AP_LOOKUP_CODES for the 'INVOICE LINE TYPE' lookup type.
• DESCRIPTION — the line description text.
• LINE_AMOUNT — the monetary amount associated with the line.

Common Use Cases and Queries

The view is frequently used to report invoice lines with readable line types and to resolve a line number back to its parent invoice. A typical query that addresses the user's search term is:

• Retrieve all lines for a given invoice:
  SELECT invoice_id, to_invoice_line_number, line_type, description, line_amount FROM apps.ap_applicable_lines_v WHERE invoice_id = :invoice_id ORDER BY to_invoice_line_number;
• Match a specific line by number:
  SELECT invoice_id, to_invoice_line_number, line_amount FROM apps.ap_applicable_lines_v WHERE to_invoice_line_number = :line_number;
• Filter by decoded line type:
  SELECT invoice_id, to_invoice_line_number, line_type, line_amount FROM apps.ap_applicable_lines_v WHERE line_type = 'Item';

Because the view derives its row identity from AP_INVOICE_LINES, it is well suited to drill-down and reconciliation reports. Consumers should apply standard Payables security and organizational access filters, and should remember that the join to AP_LOOKUP_CODES restricts results to lines whose lookup codes are valid entries under the 'INVOICE LINE TYPE' lookup type.