Search Results allocation_value




Overview
Explore in AI Chat

Overview

POR_DISTRIBUTIONS_ALL_V is an Oracle E-Business Suite (EBS) database view owned by the APPS schema in the ICX – Oracle iProcurement product module. Its documented description is simply "Distribution View," reflecting its purpose of presenting requisition distribution information in a form suited to iProcurement and downstream reporting requirements. The view joins distribution records to their parent requisition lines, thereby exposing a consolidated, denormalized picture of how a requisition line has been allocated across accounting, project, and budgetary dimensions. The user search term "allocation_value" corresponds directly to one of the view's derived columns: ALLOCATION_VALUE is produced via an NVL expression that substitutes the requisition line quantity when the stored allocation value is null. This makes the view particularly relevant to iProcurement allocation logic, shopping cart requisition processing, and encumbrance tracking. In EBS 12.1.1 and 12.2.2 the object remains a standard, valid view available to reporting and integration scenarios.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two referenced base objects, both accessed through synonyms: PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL. The view text selects from PO_REQ_DISTRIBUTIONS_ALL (aliased DIST) and PO_REQUISITION_LINES_ALL (aliased LINE), joining them on REQUISITION_LINE_ID. This join is the structural foundation of the view: it takes each distribution row from PO_REQ_DISTRIBUTIONS_ALL and enriches it with attributes from the parent requisition line. Because the distributor table is the driving table, the view returns one row per requisition distribution, with the parent line quantity and unit price available for derived computations such as PERCENTAGE, AMOUNT, and quantity-based allocation values.

Key Columns

The view exposes the full set of distribution columns plus several computed values. Notable columns include:

Common Use Cases and Queries

The view is commonly used in iProcurement reporting to analyze how requisition lines are distributed across accounts, and to inspect allocation values, percentages, and amounts. A typical query filters by a specific requisition line or distribution to examine allocation_value:

SELECT distribution_id, requisition_line_id, allocation_type,
       allocation_value, percentage, quantity, amount, code_combination_id
FROM   apps.por_distributions_all_v
WHERE  requisition_line_id = :p_requisition_line_id;

Other common scenarios include validating encumbrance state (ENCUMBERED_FLAG, ENCUMBERED_AMOUNT), auditing failed funds checks (FAILED_FUNDS_LOOKUP_CODE), and reconciling project-related distributions. Because ALLOCATION_VALUE defaults to the line quantity when no explicit value exists, the view provides a reliable basis for allocation reporting without requiring outer joins or null-handling logic in consuming queries.