Search Results po_req_distributions




Overview
Explore in AI Chat

Overview

POR_VIEW_DIST_LINES_V is an APPS-owned database view in Oracle E-Business Suite, registered under the ICX (Oracle iProcurement) product family. In both EBS 12.1.1 and 12.2.2 it exists with a status of VALID, but Oracle's own reference documentation classifies the object as obsolete. This designation means the view is retained only for backward compatibility with older iProcurement code paths and legacy customizations; it is not part of any supported extension surface and should not be used as the foundation for new development or reporting.

Functionally, the view presents a flattened, requisition-distribution-level projection of purchasing data. It joins requisition header/line information to requisition distributions and resolves the distribution's charge account into a concatenated, key-flexfield-ready form. In historical releases it was consumed by iProcurement pages that displayed how a single requisition line was split across accounting distributions, including the percentage and monetary amount attributable to each distribution. Because the view is obsolete, Oracle may remove or alter it without notice, and no seed data or profile options depend on it in current releases.

Underlying Base Objects

The view is defined over five referenced objects, all resolved through APPS synonyms or public synonyms:

  • PO_REQUISITION_LINES (synonym) — supplies the requisition line quantity and unit price used in percentage and amount calculations.
  • PO_REQ_DISTRIBUTIONS (synonym) — the driving distribution rows, including distribution number, quantity, and code combination.
  • GL_CODE_COMBINATIONS_KFV (view) — the key-flexfield view that renders the accounting flexfield as a single concatenated segments string for the CHARGE_ACCOUNT column.
  • FINANCIALS_SYSTEM_PARAMETERS (synonym) — provides the set of books context used to derive the functional currency.
  • GL_SETS_OF_BOOKS (view) — supplies the currency code passed to the currency-formatting routine.
  • FND_CURRENCY (package) — invoked at query time via FND_CURRENCY.SAFE_GET_FORMAT_MASK to format the amount according to the ledger currency.

The join is driven from PO_REQ_DISTRIBUTIONS to PO_REQUISITION_LINES on REQUISITION_LINE_ID, to GL_CODE_COMBINATIONS_KFV on CODE_COMBINATION_ID, and to the ledger context through FINANCIALS_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID.

Key Columns

  • REQUISITION_LINE_ID — foreign key to the requisition line; the join key back to PO_REQUISITION_LINES.
  • DISTRIBUTION_NUM — the distribution sequence number within the requisition line.
  • CHARGE_ACCOUNT — the concatenated accounting flexfield segments sourced from GL_CODE_COMBINATIONS_KFV.
  • PERCENTAGE — computed as (PRD.REQ_LINE_QUANTITY * 100) / PRL.QUANTITY, the share of the line quantity allocated to the distribution.
  • QUANTITY — the distribution's requisition line quantity.
  • AMOUNT — the distribution quantity multiplied by the line unit price, formatted using the ledger currency mask.

Common Use Cases and Queries

The view is most often referenced when maintaining legacy iProcurement customizations or when reconciling requisition distribution splits against charge accounts. A representative query is:

  • SELECT requisition_line_id, distribution_num, charge_account, percentage, quantity, amount FROM apps.por_view_dist_lines_v WHERE requisition_line_id = :line_id ORDER BY distribution_num;
  • SELECT distribution_num, charge_account, SUM(amount) FROM apps.por_view_dist_lines_v GROUP BY distribution_num, charge_account;
  • SELECT d.charge_account, d.amount FROM apps.por_view_dist_lines_v d, apps.po_requisition_lines l WHERE d.requisition_line_id = l.requisition_line_id AND l.requisition_header_id = :header_id;

Because the underlying object is documented as obsolete, the recommended alternative for requisition distribution reporting is to query PO_REQ_DISTRIBUTIONS directly, joining to PO_REQUISITION_LINES and GL_CODE_COMBINATIONS_KFV manually. This avoids dependency on an unsupported view while reproducing the same CHARGE_ACCOUNT, PERCENTAGE, QUANTITY, and AMOUNT projections.