Results for “quantity_recouped”

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

Overview

POBV_MC_PO_DISTRIBUTIONS is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Purchasing (PO) module. The object name prefix "MC" denotes multi-currency (or multi-organization currency conversion) processing, and the metadata describes the object as "Retrofitted," indicating it was re-pointed or re-created during a technology stack or schema upgrade to conform to current EBS standards. The view presents purchasing distribution records enriched with set-of-books context, currency conversion rate information, and encumbrance amounts, making it a reporting convenience layer over core purchasing data rather than a transactional object.

The view is a join of multi-currency distribution data (PO_MC_DISTRIBUTIONS) against the standard purchasing distribution, line, shipment and header entities, plus general ledger set-of-books and organization definitions. It includes a WITH READ ONLY clause, so it cannot be used for DML; it is intended strictly for inquiry, reporting, and integration extraction.

Underlying Base Objects

The documented base objects referenced by the view are:

• GL_SETS_OF_BOOKS (view) — supplies the set-of-books identifier and name used to anchor currency conversion context.
• HR_ALL_ORGANIZATION_UNITS (synonym) — supplies the operating unit name via ORG_ID to ORGANIZATION_ID.
• PO_DISTRIBUTIONS_ALL (synonym) — the primary distribution record; the join key is PO_DISTRIBUTION_ID.
• PO_HEADERS_ALL (synonym) — joined on PO_HEADER_ID to retrieve the purchase order document number (SEGMENT1).
• PO_LINES_ALL (synonym) — joined on PO_LINE_ID to retrieve the line number.
• PO_LINE_LOCATIONS_ALL (synonym) — joined on LINE_LOCATION_ID; this is the shipment/line-location entity that carries SHIPMENT_NUM, DROP_SHIP_FLAG and SALES_ORDER_UPDATE_DATE.

PO_MC_DISTRIBUTIONS is the driving multi-currency table, joined to PO_DISTRIBUTIONS_ALL by PO_DISTRIBUTION_ID. The view therefore links currency-conversion and encumbrance detail to the standard purchasing hierarchy of header, line, shipment, and distribution. A predicate of the form '_SEC:PD.ORG_ID' IS NOT NULL is present in the view text, representing the row-level security (MLS/operating unit) enforcement applied through the distribution's ORG_ID.

Key Columns

• SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME — the ledger context for the conversion rate and encumbrance values.
• PO_DISTRIBUTION_ID, DISTRIBUTION_NUMBER — unique distribution identifier and its user-visible number.
• PO_SHIPMENT_ID, SHIPMENT_NUMBER — the shipment (line location) identifier and number. PO_SHIPMENT_ID is the column most frequently searched for, as it is the standard link to receipt, shipment, and delivery reporting.
• PO_LINE_ID, LINE_NUMBER, PURCHASE_ORDER_ID (PO_HEADER_ID), PO_DOCUMENT_NUMBER — the purchasing document hierarchy identifiers and display values.
• OPERATING_UNIT_ID, OPERATING_UNIT_NAME — the organization owning the distribution.
• CURRENCY_CONVERSION_RATE_DATE, CURRENCY_CONVERSION_RATE — the date and rate used for multi-currency valuation of the distribution.
• ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT — encumbrance balances associated with the distribution for budgetary reporting.
• DROP_SHIP_FLAG, SALES_ORDER_UPDATE_DATE — indicators supporting drop-shipment and sales-order-linked procurement analysis.

Common Use Cases and Queries

Typical uses include multi-currency encumbrance reporting, drop-shipment analysis, and integration extracts that need shipment-level purchasing detail joined to ledger conversion rates. A representative query retrieving shipment-level encumbrance detail is:

SELECT po_document_number, line_number, shipment_number, po_shipment_id, distribution_number, encumbered_amount, unencumbered_amount, currency_conversion_rate, set_of_books_name FROM apps.pobv_mc_po_distributions WHERE po_shipment_id = :p_shipment_id AND operating_unit_name = :p_org;

To analyze drop-ship distributions by operating unit:

SELECT operating_unit_name, COUNT(*) dist_count, SUM(encumbered_amount) total_encumbered FROM apps.pobv_mc_po_distributions WHERE drop_ship_flag = 'Y' GROUP BY operating_unit_name;

Because the view is READ ONLY and inherits operating unit security through the ORG_ID predicate, queries must run in a context where the appropriate organization security profile is initialized (for example, via MO_GLOBAL or the standard EBS security framework). Direct DML against the view is not supported; updates must target PO_DISTRIBUTIONS_ALL or PO_MC_DISTRIBUTIONS.