Search Results ap_distribution_set_lines_v




Overview
Explore in AI Chat

Overview

The AP_DISTRIBUTION_SET_LINES_V view resides in the APPS schema and belongs to the Oracle Payables (AP) product family. It exposes the line-level detail of Payables distribution sets, pairing each distribution set header with its constituent distribution lines. A distribution set in Oracle EBS is a reusable template that defines how an invoice or payment amount is apportioned across multiple accounts, cost centers, or expense distributions. The view presents the line records that carry the actual allocation percentages, descriptive text, 1099 reporting classification, and grant award linkage.

The documented ETRM metadata indicates this view is associated with Release 10SC, which signals that it is a legacy object retained through the 12.1.1 and 12.2.2 code lines. Because it is a simple join view rather than a table with business logic, its primary role is to provide a denormalized, read-only projection suitable for reporting, reconciliation, integrations, and diagnostic queries. When a user searches for "percent_distribution" in the context of Oracle Payables, this view is the canonical source for that attribute at the distribution-set-line grain.

Underlying Base Objects

The view is defined over two base objects, both referenced through APPS synonyms:

  • AP_DISTRIBUTION_SETS — the distribution set header. It supplies the distribution set identifier and the human-readable distribution set name.
  • AP_DISTRIBUTION_SET_LINES — the distribution set lines. It supplies the line number, allocation percentage, description, 1099 type, and award identifier.

The join condition links the two objects on DISTRIBUTION_SET_ID, so the view returns one row per distribution set line, enriched with the parent set name. The view text is a straightforward SELECT-JOIN with no aggregation, and it therefore preserves the one-to-many relationship between a distribution set and its lines. No additional filtering or decoding is applied in the view definition, meaning the consuming query or report is responsible for any business logic such as validation that percentages total one hundred.

Key Columns

  • DISTRIBUTION_SET_ID — the primary identifier of the parent distribution set; the join key to AP_DISTRIBUTION_SETS.
  • DISTRIBUTION_SET_NAME — the descriptive name of the distribution set, used in user interfaces and reports.
  • DISTRIBUTION_SET_LINE_NUMBER — the sequential line number that orders the distributions within the set.
  • PERCENT_DISTRIBUTION — the percentage of the transaction amount allocated to this line; the attribute most relevant to the "percent_distribution" search.
  • DESCRIPTION — free-text description associated with the distribution line.
  • TYPE_1099 — the 1099 reporting type classification applied to the line, relevant to US tax reporting.
  • AWARD_ID — the identifier linking the distribution line to a grant award, supporting grants accounting requirements.

Common Use Cases and Queries

The view is typically used to inspect how distribution sets split amounts, to validate that line percentages sum correctly, and to extract set definitions for migration or audit purposes. A representative query lists all lines for a named set:

  • Percent validation: SELECT distribution_set_id, distribution_set_name, SUM(percent_distribution) FROM ap_distribution_set_lines_v GROUP BY distribution_set_id, distribution_set_name HAVING SUM(percent_distribution) <> 100; — identifies sets whose lines do not total one hundred percent.
  • Standard extraction: SELECT distribution_set_name, distribution_set_line_number, percent_distribution, description, type_1099, award_id FROM ap_distribution_set_lines_v WHERE distribution_set_name = :set_name ORDER BY distribution_set_line_number; — returns the ordered composition of a set.
  • 1099 impact analysis: SELECT distribution_set_name, distribution_set_line_number, percent_distribution FROM ap_distribution_set_lines_v WHERE type_1099 IS NOT NULL; — surfaces lines with 1099 reporting implications.

Because the view is read-only and defined solely over AP synonyms, it should not be used for updates; all maintenance of distribution sets is performed through the base tables or the Payables application. Confirmed against ETRM 12.2.2 metadata, the object remains VALID with AP_DISTRIBUTION_SETS and AP_DISTRIBUTION_SET_LINES as its documented referenced base objects.