Search Results ap_distribution_sets




Overview
Explore in AI Chat

Overview

APPS.AP_DISTRIBUTION_SET_LINES_V is a reporting and integration view within the Oracle E-Business Suite Payables (AP) module. It exposes the individual distribution lines that belong to an accounts payable distribution set, joined with the parent distribution set header. Distribution sets are predefined templates that automatically allocate an invoice or payment amount across multiple general ledger accounts and percentages, eliminating the need to manually enter repetitive distribution lines.

In Oracle EBS 12.1.1 and 12.2.2, this view serves as a consolidated read interface over two base entities. Rather than requiring callers to join the header table and the line table manually, the view presents both the set-level attribute (the distribution set name) and the line-level attributes in a single row per distribution line. This makes it convenient for reports, concurrent programs, forms, and third-party integrations that need to enumerate the composition of a distribution set without reconstructing the underlying join.

Underlying Base Objects

The ETRM metadata documents the view as owned by APPS and defined over two referenced base objects, both represented as synonyms:

  • AP_DISTRIBUTION_SETS (aliased as S) — the header table holding the distribution set identifier and name.
  • AP_DISTRIBUTION_SET_LINES (aliased as L) — the line table holding each line's distribution percentage, description, 1099 type, and award reference.

The view text joins these two objects on the distribution set identifier:

WHERE L.DISTRIBUTION_SET_ID = S.DISTRIBUTION_SET_ID

Because the join is an inner join, the view returns only lines that are attached to a valid distribution set. If a set has no lines defined, no rows appear for that set in this view; header-only information is not returned.

Key Columns

  • DISTRIBUTION_SET_ID — the unique identifier of the parent distribution set; the join key between the header and line tables.
  • DISTRIBUTION_SET_NAME — the descriptive name of the distribution set, sourced from AP_DISTRIBUTION_SETS.
  • DISTRIBUTION_SET_LINE_NUMBER — the sequence number identifying the individual line within the set.
  • PERCENT_DISTRIBUTION — the percentage of the transaction amount allocated to this line.
  • DESCRIPTION — free-text description associated with the distribution line.
  • TYPE_1099 — the 1099 reporting classification for the line, used for US tax reporting.
  • AWARD_ID — the award identifier, used where the line is associated with a grant or award.

Common Use Cases and Queries

Typical uses include auditing the composition of distribution sets, validating that percentage distributions total correctly, and reporting 1099 or award associations for a given set. A common query lists all lines for a named set:

SELECT distribution_set_name, distribution_set_line_number,
percent_distribution, description, type_1099, award_id
FROM apps.ap_distribution_set_lines_v
WHERE distribution_set_name = :p_set_name
ORDER BY distribution_set_line_number;

To verify that a set's percentages sum to 100:

SELECT distribution_set_name, SUM(percent_distribution)
FROM apps.ap_distribution_set_lines_v
GROUP BY distribution_set_name;

Because the view is read-only and defined over AP synonyms, it should be used strictly for query and reporting purposes rather than as a DML target.