Search Results pn_distributions




Overview
Explore in AI Chat

Overview

The view APPS.PN_DISTRIBUTIONS_V is a reporting and integration layer exposed by Oracle E-Business Suite's Property Manager (PN) module, which is part of the Enterprise Asset Management (EAM) / Real Estate Management family of applications. It presents distribution records associated with payment terms and term templates, providing a denormalized and conveniently aliased projection of the underlying PN_DISTRIBUTIONS base table. In Oracle EBS 12.1.1 and 12.2.2, this view is owned by the APPS schema and is intended to give external consumers, concurrent programs, and custom reports a stable column naming convention distinct from the base table's physical column names.

The view plays a role similar to other _V objects across EBS: it isolates consumers from direct dependencies on base table internals while exposing the same data. In practice, it supports reporting on how payment terms, and specifically term templates, are allocated across accounts using percentage-based distribution lines.

Underlying Base Objects

According to the ETRM metadata, the view is defined over a single documented base object: the synonym PN_DISTRIBUTIONS. The view text confirms this relationship directly, selecting all columns from PN_DISTRIBUTIONS, aliased internally as PDIST. The synonym resolves to the actual PN.PN_DISTRIBUTIONS table. No joins, unions, or aggregation are present in the view definition; it is a straightforward column-projection view. Consequently, the row count and granularity of PN_DISTRIBUTIONS_V match the base table exactly, with one row per distribution record.

Key Columns

The view exposes the following principal columns:

  • ROW_ID — derived from PDIST.ROWID, providing the physical row identifier for the base table row.
  • DISTRIBUTION_ID — the primary key of the distribution record.
  • PAYMENT_TERM_ID — foreign key reference to the payment term with which the distribution is associated.
  • TERM_TEMPLATE_ID — foreign key reference to the term template governing the distribution rule.
  • PERCENTAGE — the allocation percentage assigned to the distribution line.
  • LINE_NUMBER — the ordering sequence of the distribution line within its parent term.
  • ACCOUNT_ID — the account identifier to which the distribution applies.
  • ACCOUNT_CLASS — the account classification. Notably, this column is projected three times under the aliases ACCOUNT_CLASS, ACCOUNT_CLASS_PAY, and ACCOUNT_CLASS_BILL, supporting both pay and bill contexts.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns for auditing.
  • ORG_ID — the operating unit identifier, enabling multi-org (MOAC) security filtering.

Common Use Cases and Queries

Typical use cases include reporting on account-level distribution splits for a given payment term, reconstructing term template logic, and integrating distribution data into custom extensions. A representative query retrieving all distributions for a term template is:

SELECT distribution_id, line_number, percentage, account_id, account_class
FROM apps.pn_distributions_v
WHERE term_template_id = :p_template_id
ORDER BY line_number;

To enforce multi-org security, consumers should restrict by ORG_ID, typically via the MOAC profile, as in:

SELECT distribution_id, payment_term_id, percentage, account_id
FROM apps.pn_distributions_v
WHERE org_id = :p_org_id;

Because the view performs no joins or filtering, it is inexpensive to query and can be used freely in concurrent programs, BI Publisher reports, and OAF/ADF integrations without incurring additional execution cost beyond the base table access.