Search Results po_revision




Overview
Explore in AI Chat

Overview

APPS.PA_PROJ_PO_DISTRIBUTIONS_V is a reporting and integration view in the Oracle E-Business Suite Projects (PA) module. It presents a consolidated, project-aware picture of purchasing activity by joining Oracle Purchasing distributions to their associated project, task, and expenditure classification attributes. The view exposes purchase order documentation, revision and release information, commit amounts, delivered and invoiced quantities, and the accounting currency conversions applied to those amounts. Its documented status is VALID, and it is registered in the FND design data repository as PA.PA_PROJ_PO_DISTRIBUTIONS_V. In both release 12.1.1 and 12.2.2, the view serves as a denormalized read-only interface for project commitment reporting, funds control analysis, and supplier spend inquiries, allowing inquiries and reports to retrieve purchase-order commitment data alongside project and expenditure type context without manually joining the underlying purchasing and projects tables.

Underlying Base Objects

The view is defined over a combination of Purchasing, Projects, and common reference objects, including several package calls used to derive computed values. Documented referenced objects are GL_SETS_OF_BOOKS (VIEW), PA_CMT_UTILS (PACKAGE), PA_EXPENDITURE_TYPES (SYNONYM), PA_FUNDS_CONTROL_UTILS (PACKAGE), PA_MULTI_CURRENCY (PACKAGE), PA_PJC_CWK_UTILS (PACKAGE), PA_PROJECTS (SYNONYM), PA_TASKS (SYNONYM), PER_ALL_PEOPLE_F (SYNONYM), PO_DISTRIBUTIONS_ALL (SYNONYM), PO_DOCUMENT_TYPES (SYNONYM), PO_HEADERS_ALL (SYNONYM), PO_LINES_ALL (SYNONYM), PO_LINE_LOCATIONS_ALL (SYNONYM), PO_LINE_TYPES (SYNONYM), PO_RELEASES_ALL (SYNONYM), and PO_VENDORS (VIEW). PO_DISTRIBUTIONS_ALL supplies the distribution-level project and task references, PO_HEADERS_ALL and PO_RELEASES_ALL provide document-level information such as revision and release numbers, PO_LINES_ALL and PO_LINE_LOCATIONS_ALL supply line and shipment detail, and the PA_* objects resolve project, task, expenditure, and currency attributes. The PL/SQL packages are invoked to compute derived flags and conversion amounts.

Key Columns

Common Use Cases and Queries

Typical uses include project commitment reporting, purchase order line and release reconciliation, and analysis of cancelled, delivered, invoiced, and outstanding quantities. A common query to inspect the revision and release revision fields a user searched for is:

  • SELECT po_number, po_revision, release_number, release_revision, project_number, task_number, amount_ordered, quantity_ordered FROM apps.pa_proj_po_distributions_v WHERE project_number = :project_number;
  • SELECT po_number, release_number, release_revision, quantity_delivered, quantity_invoiced, quantity_outstanding_delivery FROM apps.pa_proj_po_distributions_v WHERE po_number = :po_number;
  • SELECT project_number, expenditure_category, SUM(amount_ordered) committed_amount FROM apps.pa_proj_po_distributions_v GROUP BY project_number, expenditure_category;

Because the view aggregates data from multiple Purchasing and Projects objects and invokes PA packages, queries should be filtered on indexed identifiers such as project number or purchase order number wherever possible to limit the processing performed by the underlying joins.