Search Results req_header_reference_num




Overview
Explore in AI Chat

Overview

PO_DISTRIBUTIONS_ALL_MRC_V is a multiple-reporting-currency (MRC) view in the Oracle E-Business Suite Purchasing module. It presents purchase order distribution information alongside the accounting-currency amounts and the corresponding converted amounts for each reporting set of books, allowing a single distribution line to be reported in more than one functional currency. In releases 12.1.1 and 12.2.2 this view is used primarily for multi-currency reporting and for reconciliation of encumbered, unencumbered, billed, and ordered amounts across ledgers.

The ETRM metadata for this object classifies it as "Retrofitted" and notes that it is "Not implemented in this database." This indicates that the view definition is supplied for reference and compatibility purposes and is not necessarily instantiated in every environment; availability therefore depends on whether MRC functionality has been enabled and the view has been deployed in the target instance.

The user search term "amount_ordered" is relevant because quantity and amount metrics on PO distributions are frequently queried for spend analysis. The view exposes QUANTITY_ORDERED and related quantity columns directly, and carries monetary columns such as ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT, and AMOUNT_BILLED. The literal column AMOUNT_ORDERED does not appear in the documented view text; ordered value is generally derived from quantity ordered and line price in the base purchasing tables.

Underlying Base Objects

The documented metadata lists no referenced base objects, but the view text clearly selects from PO_DISTRIBUTIONS_ALL (aliased PO) joined to a multiple-reporting-currency table (aliased MC), which supplies SET_OF_BOOKS_ID, RATE_DATE, RATE, and the MRC amount columns. The MC alias corresponds to the MRC companion table that stores reporting-currency conversions for purchasing distributions. The join key is the set of books and the distribution identifier.

Because the view is described as retrofitted, it exists to preserve backward compatibility with earlier MRC-based reporting while the underlying multi-org and subledger accounting architecture evolved. In 12.1.1 and 12.2.2, most MRC views of this type are read-only reporting constructs and should not be used for transactional DML.

Key Columns

Common Use Cases and Queries

Typical usage includes multi-ledger spend reporting, encumbrance reconciliation, and auditing of converted purchase order distributions.

SELECT SET_OF_BOOKS_ID,
       PO_DISTRIBUTION_ID,
       QUANTITY_ORDERED,
       ENCUMBERED_AMOUNT,
       MRC_ENCUMBERED_AMOUNT,
       MRC_UNENCUMBERED_AMOUNT,
       MRC_RATE
FROM   PO_DISTRIBUTIONS_ALL_MRC_V
WHERE  PO_HEADER_ID = :p_po_header_id
ORDER BY SET_OF_BOOKS_ID;

A second pattern compares primary and reporting-currency encumbrances to identify conversion variances:

SELECT PO_DISTRIBUTION_ID,
       ENCUMBERED_AMOUNT,
       MRC_ENCUMBERED_AMOUNT,
       (MRC_ENCUMBERED_AMOUNT - ENCUMBERED_AMOUNT) variance
FROM   PO_DISTRIBUTIONS_ALL_MRC_V
WHERE  NVL(ENCUMBERED_FLAG,'N') = 'Y';