Search Results item_source_id




Overview
Explore in AI Chat

Overview

The view PO_REQUISITION_LINES_MRC_V is a Multi-Reporting-Currency (MRC) reporting view belonging to the Oracle Purchasing (PO) module. It exposes purchase requisition line information alongside currency-converted monetary values, allowing requisition data to be analyzed in both the functional currency of the operating unit and the associated reporting currency. The "MRC" designation indicates the view is part of Oracle's multiple reporting currency architecture, which was originally introduced in earlier releases and retrofitted into later 11i/12.x code lines.

Per the supplied ETRM metadata, the view is described simply as "Retrofitted," and the Implementation/DBA Data section states "Not implemented in this database." This is a critical caveat: although the view text exists in the ETRM documentation repository, the object may not be deployed in every environment. Its presence in the data dictionary is therefore environment-dependent, and developers should verify existence before dependency.

Underlying Base Objects

The view's SELECT list is anchored on a single base table, PO_REQUISITION_LINES, referenced throughout by the alias "PO." No other documented base objects are listed in the ETRM metadata, and the "Referenced base objects" field is recorded as "none documented." The view is not a join of multiple tables; instead it derives reported amounts by applying currency conversion logic to columns already stored on the requisition line.

Two external PL/SQL package functions perform the monetary conversion: PO_MC_CURRENCY_PKG.FUNC_TO_REP_RATE and PO_MC_CURRENCY_PKG.GET_REQ_RATE. These functions accept a rate date (defaulting to SYSDATE via NVL), the operating unit identifier ORG_ID, and, where applicable, the document CURRENCY_CODE. Because the rate lookup is evaluated at query time, reported values can change as exchange rates are maintained.

Key Columns

The view exposes the standard requisition line identifiers and attributes, along with MRC-converted monetary columns. Important columns include:

Common Use Cases and Queries

This view is typically consumed by custom reporting, extracts, and integration programs requiring requisition lines expressed in reporting currency, particularly in multi-org environments that activate MRC. A representative query follows:

  • SELECT requisition_line_id, line_num, item_description, unit_price, currency_code, rate_date FROM po_requisition_lines_mrc_v WHERE org_id = :p_org_id;
  • Filtering by CURRENCY_CODE and RATE_DATE supports period-end revaluation reporting and foreign-currency exposure analysis.
  • Joining to PO_REQUISITION_HEADERS supplies header-level descriptors not stored on the line.

Because the ETRM record states the object is not implemented in the reference database, DBAs and developers must confirm the view's existence in the target instance and validate that PO_MC_CURRENCY_PKG is compiled before relying on it in production code.