Results for “invoice_distribution_id”

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

Overview

AP_CHARGE_ALLOCATIONS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Payables (AP) module. It presents a filtered, enriched projection of accounts payable invoice distribution lines, restricted to charge-bearing distribution types. Specifically, the view surfaces distributions whose LINE_TYPE_LOOKUP_CODE is one of ITEM, MISCELLANEOUS, FREIGHT, or PREPAY — the categories that represent tangible charges on an invoice — while excluding other distribution types such as tax, withholding, and recoupment lines.

The view's primary role is to provide a simplified, presentation-ready dataset for reporting and integration. Rather than requiring the report developer or integration consumer to manually join AP_INVOICE_DISTRIBUTIONS against the distribution type lookup view and hand-filter the qualifying line types, this view encapsulates that logic. It also renames several physical columns to friendlier aliases (for example, AMOUNT is exposed as DISTRIBUTION_AMOUNT and the lookup's DISPLAYED_FIELD as LINE_TYPE), reducing the interpretation burden on downstream consumers.

The object is documented as VALID in ETRM and is present across both Oracle EBS 12.1.1 and 12.2.2 releases. Because it is a view, no separate storage or maintenance is required; it always reflects the current committed state of its underlying tables at query time.

Underlying Base Objects

The documented metadata identifies three referenced objects. The principal base object is AP_INVOICE_DISTRIBUTIONS (referenced through a synonym), which holds the individual accounting distribution lines for every invoice. The view selects only those distribution rows whose line type matches the qualifying charge categories.

The second base object is AP_LOOKUP_CODES, itself a view that exposes lookup code values and their user-facing display strings. AP_CHARGE_ALLOCATIONS_V joins to it with LOOKUP_TYPE = 'INVOICE DISTRIBUTION TYPE', matching the distribution's LINE_TYPE_LOOKUP_CODE to the lookup's LOOKUP_CODE. This join supplies the human-readable label exposed as LINE_TYPE.

The third referenced object is the FND_GLOBAL package, the standard Oracle Application Object Library package used for session context (such as responsibility, user, and organization identifiers). Its inclusion in the dependency list indicates that the view or its referenced objects consult session-level context during resolution.

Key Columns

• INVOICE_ID — Identifier of the parent invoice; joins to AP_INVOICES_ALL for header-level attributes such as vendor, invoice number, and currency.
• INVOICE_DISTRIBUTION_ID — Primary key of the underlying distribution line; the unique identifier for each row returned.
• DISTRIBUTION_LINE_NUMBER — Sequence number of the distribution within the invoice, defining display and processing order.
• LINE_TYPE_LOOKUP_CODE — The raw lookup code (ITEM, MISCELLANEOUS, FREIGHT, or PREPAY) identifying the nature of the charge.
• LINE_TYPE — The descriptive label resolved from AP_LOOKUP_CODES (DISPLAYED_FIELD), suitable for direct display in reports.
• DESCRIPTION — Free-text description entered on the distribution line.
• DISTRIBUTION_AMOUNT — The amount of the distribution line, sourced from AP_INVOICE_DISTRIBUTIONS.AMOUNT.

Common Use Cases and Queries

The view is typically used for charge analysis, freight and miscellaneous cost reporting, and reconciliation extracts feeding subledger or data-warehouse processes. A representative query totals charges by type for a given invoice:

SELECT LINE_TYPE, SUM(DISTRIBUTION_AMOUNT) TOTAL_AMOUNT
FROM APPS.AP_CHARGE_ALLOCATIONS_V
WHERE INVOICE_ID = :p_invoice_id
GROUP BY LINE_TYPE;

A second pattern joins to the invoice header to correlate charges with suppliers and periods:

SELECT ai.invoice_num, ai.vendor_id, ca.line_type, ca.distribution_amount
FROM APPS.AP_CHARGE_ALLOCATIONS_V ca,
     APPS.AP_INVOICES_ALL ai
WHERE ca.invoice_id = ai.invoice_id
  AND ai.invoice_date BETWEEN :p_start AND :p_end;

Because the view already filters to ITEM, MISCELLANEOUS, FREIGHT, and PREPAY lines, consumers should not expect tax, withholding, or other non-charge distributions to appear. Reports requiring the full population of distributions must query AP_INVOICE_DISTRIBUTIONS directly.