Results for “pofv_mc_inbound_shipments”

16 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

POFV_MC_INBOUND_SHIPMENTS is a read-only Oracle EBS view owned by the APPS schema and catalogued under the Purchasing (PO) product family. It is flagged as "Retrofitted," indicating it was originally introduced as a custom or country-specific object and subsequently folded into the standard application object set. The view consolidates inbound (receiving) shipment header information with the multi-currency (MC) conversion attributes captured at receipt time, and joins those attributes to the General Ledger set of books and the daily conversion rate definitions.

Its principal role is reporting and integration: it exposes a denormalised, query-friendly projection of receiving shipment data that already includes the currency conversion rate and its associated rate type name, avoiding the need for downstream reports, interfaces, or extracts to re-derive that context. Because the view is defined WITH READ ONLY, it is strictly a query surface for inbound shipment and currency conversion analysis.

Underlying Base Objects

The view is defined over four base objects:

The documented ETRM 12.2.2 metadata records GL_DAILY_CONVERSION_TYPES and RCV_SHIPMENT_HEADERS as the referenced base objects (via synonyms), and the full view text confirms the remaining joins to RCV_MC_SHIPMENT_HEADERS and GL_SETS_OF_BOOKS. The join to GL_DAILY_CONVERSION_TYPES is the critical link between a stored conversion-rate code and its human-readable name.

Key Columns

  • SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — the ledger identifier and its descriptive name from GL_SETS_OF_BOOKS.
  • SHIPMENT_HEADER_ID — the shipment header identifier, joining key back to RCV_SHIPMENT_HEADERS.
  • SHIPMENT_NUM — the shipment number associated with the inbound receipt.
  • RECEIPT_NUM — the receipt number for the inbound transaction.
  • CONVERSION_DATE / CURRENCY_CONVERSION_RATE_DATE — the date on which the conversion rate was applied.
  • CONVERSION_RATE / CURRENCY_CONVERSION_RATE — the numeric exchange rate stored on the shipment header.
  • CONVERSION_RATE_TYPE / CURRENCY_CONVERSION_RATE_TYPE — the rate type code (for example, Corporate, Spot, User-defined), which maps to GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE.
  • RATE_TYPE_NAME / USER_CONVERSION_TYPE — the user-defined conversion type name from GL_DAILY_CONVERSION_TYPES, matching the common search term rate_type_name.
  • RATE_TYPE_DESCRIPTION — the descriptive text of the rate type, useful for report labels and audits.

Common Use Cases and Queries

Typical usage includes multicurrency receipt reconciliation, landed-cost analysis, and audit reporting where the rate type applied to an inbound shipment must be evidenced. A basic query filtering by receipt number is shown below.

SELECT shipment_number, receipt_number, currency_conversion_rate_date,
currency_conversion_rate, rate_type_name
FROM apps.pofv_mc_inbound_shipments
WHERE receipt_number = :p_receipt_num;

To report volume by rate type per ledger:

SELECT set_of_books_name, rate_type_name, COUNT(*)
FROM apps.pofv_mc_inbound_shipments
GROUP BY set_of_books_name, rate_type_name;

Because the view already resolves rate_type_name, it is frequently used in place of hand-built joins between RCV_MC_SHIPMENT_HEADERS and GL_DAILY_CONVERSION_TYPES. It should be treated as a read-only reporting source.