Search Results po_matched_dist_qty_billed




Overview
Explore in AI Chat

Overview

APBV_AP_INVOICE_DISTRIBUTIONS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is registered under the FND Design Data namespace SQLAP and carries a VALID status in the ETRM repository. The view presents one row per invoice distribution line, exposing the individual charges that make up an Oracle Payables invoice — item lines, tax, freight, and miscellaneous distributions — together with their accounting, matching, withholding, and posting attributes.

Because it is a BIS view rather than a transactional table, APBV_AP_INVOICE_DISTRIBUTIONS is intended for read-only reporting, ad-hoc extraction, and downstream integration. It surfaces denormalised, reporting-friendly columns such as functional amounts, price variance breakdowns, and descriptive invoice distribution text that would otherwise require joins across multiple Payables entities. This makes it a natural source for Payables subledger reporting, accrual analysis, withholding tax monitoring, and data feeds into external financial systems.

Underlying Base Objects

The documented view metadata lists two referenced base objects: AP_INVOICE_DISTRIBUTIONS (accessed through a synonym) and GL_CODE_COMBINATIONS (also via synonym). The synonym over AP_INVOICE_DISTRIBUTIONS points to the core Payables distribution table that stores every distribution line belonging to an invoice line, including accounting flexfield references, amounts, quantities, and matching results.

The synonym over GL_CODE_COMBINATIONS supplies the General Ledger chart-of-accounts context, allowing the view to resolve code combination identifiers into meaningful account information. In practice, the view joins the invoice distribution detail to its corresponding accounting flexfield so that each distribution row can be reported with both its transactional amount and its accounting destination. All columns and business rules are ultimately derived from these two base objects, keeping the view tightly coupled to the Payables subledger data model.

Key Columns

Common Use Cases and Queries

A frequent requirement is isolating distributions that carry withholding tax, which is where AWT_FLAG is most relevant. The following query lists active withholding distributions for further tax analysis:

  • SELECT invoice_id, invoice_line_number, distribution_line_number, awt_flag, awt_gross_amount, invoice_dist_func_amt FROM apps.apbv_ap_invoice_distributions WHERE awt_flag = 'Y';

Other typical scenarios include reconciling posted Payables activity to the GL by filtering on POSTED_FLAG, analysing price and quantity variances from purchase order matching, and reporting asset-related distributions prior to transfer into Oracle Assets. Analysts also use this view to review distributions that remain in a pending matching or approval state, and to feed distribution-level detail into external tax or audit reporting. Because the view is read-only and derived from AP_INVOICE_DISTRIBUTIONS and GL_CODE_COMBINATIONS, all reporting should be performed against it rather than against the base table directly when the additional reporting columns are required.