Search Results pofv_mc_purchase_orders




Overview
Explore in AI Chat

Overview

The APPS.POFV_MC_PURCHASE_ORDERS view is a Purchasing (PO) module reporting object that exposes purchase order header information together with the multi-currency (MC) conversion attributes stored in the PO_MC_HEADERS table. It is part of the Purchasing multi-currency retrofit set, as indicated by the "Retrofitted" description in the Electronic Technical Reference Manual (ETRM). The view is owned by the APPS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2.

The object serves a reporting and integration purpose: it flattens the relationship between a purchase order header, the set of books to which it belongs, the operating unit that owns it, and the daily conversion rate type applied to the multi-currency record. By joining these entities into a single row per purchase order/set-of-books combination, the view allows downstream reports, extracts, and interfaces to retrieve currency conversion details without reconstructing the multi-currency joins themselves. The definition is declared WITH READ ONLY, so the view is strictly a query surface and cannot be used for DML.

Underlying Base Objects

The view is defined over four primary base tables and synthesizes them through inner joins. The documented referenced objects in the ETRM 12.2.2 metadata are GL_DAILY_CONVERSION_TYPES, HR_ALL_ORGANIZATION_UNITS, and PO_HEADERS_ALL, each referenced through an APPS synonym. In addition, the view text references PO_MC_HEADERS (aliased MH) and GL_SETS_OF_BOOKS (aliased SB).

  • PO_MC_HEADERS MH — the driving multi-currency header table, supplying the set of books, purchase order reference, rate date, rate, and rate type.
  • PO_HEADERS_ALL PH — joined on MH.PO_HEADER_ID = PH.PO_HEADER_ID; provides the document number (SEGMENT1) and operating unit identifier.
  • GL_SETS_OF_BOOKS SB — joined on MH.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID; supplies the set of books name.
  • HR_ALL_ORGANIZATION_UNITS OP — joined on PH.ORG_ID = OP.ORGANIZATION_ID; supplies the operating unit name.
  • GL_DAILY_CONVERSION_TYPES RT — joined on MH.RATE_TYPE = RT.CONVERSION_TYPE; supplies the conversion type name and description.

The definition also enforces a security predicate — '_SEC:PH.ORG_ID' IS NOT NULL — which functions as a placeholder for multi-org (operating unit) security filtering on the purchase order organization.

Key Columns

The view exposes twelve columns. The most significant include:

Common Use Cases and Queries

Typical uses include auditing the currency conversion applied to multi-currency purchase orders, reconciling PO commitments against ledger rates, and supplying conversion context to custom multi-currency extracts and integrations.

Retrieve all multi-currency purchase orders for a ledger:

SELECT DOCUMENT_NUMBER, OPERATING_UNIT_NAME, CURRENCY_CONVERSION_RATE,
       CURRENCY_CONVERSION_RATE_TYPE, CURRENCY_CONVERSION_RATE_DATE
FROM   APPS.POFV_MC_PURCHASE_ORDERS
WHERE  SET_OF_BOOKS_NAME = :ledger_name;

Locate a specific purchase order's conversion details:

SELECT PURCHASE_ORDER_ID, DOCUMENT_NUMBER, CURRENCY_CONVERSION_RATE,
       RATE_TYPE_NAME, RATE_TYPE_DESCRIPTION
FROM   APPS.POFV_MC_PURCHASE_ORDERS
WHERE  DOCUMENT_NUMBER = :po_number;

Because the view is read only and joins operating unit security through the purchase order organization, query results are naturally constrained to the organizations accessible to the session. This makes it suitable as a secured reporting source without additional authorization logic in the consuming query.