Search Results ap_invoice_distributions_v




Overview
Explore in AI Chat

Overview

AP_INVOICE_DISTRIBUTIONS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the Payables (AP) product family. In both 12.1.1 and 12.2.2, it exposes invoice distribution accounting information consolidated from the AP_INVOICE_DISTRIBUTIONS base table together with a wide set of joined reference objects. It presents a denormalized, security-filtered, and functionally enriched projection of distribution lines, providing accounting flexfield assignments, matched purchase order and receipt context, project and task information, withholding tax attributes, and descriptive flexfield columns.

The view is the standard interface used by Payables reporting, subledger accounting extraction, and custom integrations that need distribution-level detail without replicating the underlying join logic. Because it embeds organizational security through the HR and FND packages, it is also the recommended access path for multi-org aware reporting. The metadata records a note referencing BUG 4926356 against the ACCOUNTING_EVENT_ID column, indicating that this column was introduced or corrected for subledger accounting integration.

Underlying Base Objects

The view is defined over the base synonym AP_INVOICE_DISTRIBUTIONS and is joined to a documented set of supporting objects. These fall into several functional groups:

The joins to RCV and PO objects supply the matching context for purchase-order-matched distributions, while the PA objects resolve project and task names. HR_SECURITY and FND packages enforce the operating unit and organization security predicate at query time.

Key Columns

The searched term rec_nrec_rate does not correspond to a column exposed by this view; the withholding-related rate attributes are carried through the AWT_TAX_RATE_ID reference to AP_TAX_CODES_ALL rather than as an explicit rate column.

Common Use Cases and Queries

The view is most often queried for distribution analysis, withholding tax reconciliation, project cost reporting, and matched PO-to-invoice audits. Typical usages include reconciling liability and expense accounts by accounting period, reviewing withholding lines against their gross amounts, and validating that matched distributions reference the expected receipt transactions.

Sample query — list distributions for a given invoice with accounting and withholding context:

SELECT invoice_id
     , distribution_line_number
     , line_type_lookup_code
     , amount
     , base_amount
     , accounting_date
     , dist_code_combination_id
     , awt_flag
     , awt_gross_amount
  FROM apps.ap_invoice_distributions_v
 WHERE invoice_id = :p_invoice_id
 ORDER BY distribution_line_number;

Sample query — summarize withholding distributions by accounting period:

SELECT accounting_date
     , SUM(awt_gross_amount) gross_withheld
     , SUM(amount)           withheld_amount
  FROM apps.ap_invoice_distributions_v
 WHERE awt_flag = 'Y'
   AND accounting_date BETWEEN :p_start AND :p_end
 GROUP BY accounting_date;

Because the view applies FND and HR security predicates, sessions must initialize the correct operating unit context before querying, particularly in 12.2.2 where the multi-org model is unchanged but payables setup is configured through the newer reference data framework.