Search Results mrp_relief_origination




Overview
Explore in AI Chat

Overview

APPS.MRPFV_MPS_CONSUMPTIONS is a Business Intelligence System (BIS) view in Oracle E-Business Suite, owned by the APPS schema and registered under FND Design Data MRP.MRPFV_MPS_CONSUMPTIONS. In releases 12.1.1 and 12.2.2 the object is documented as VALID and is classified as a View Type A Business Intelligence System view. Its functional purpose is to expose the relief recorded against a particular production schedule entry, allowing planners and reporting tools to see which demand documents have consumed, or relieved, a master production schedule (MPS) entry.

The view is read-only metadata abstraction. It is not referenced by any other database object, so it functions strictly as a reporting and integration surface rather than as a component of the runtime planning engine. Because it presents order numbers, order types, line numbers, relief quantities and schedule dates in a single flat structure, it is well suited to discoverer reports, BI Publisher datasets, and ad hoc SQL used by manufacturing and supply chain analysts.

Underlying Base Objects

The view is defined over a set of APPS synonyms that resolve to the underlying planning, purchasing, receiving, and work-in-process tables. The documented dependencies are:

  • MFG_LOOKUPS (VIEW) — supplies the lookup meanings used to translate order and transaction type codes into readable values.
  • MRP_SCHEDULE_CONSUMPTIONS (SYNONYM) — the primary source of schedule relief records, holding the quantity consumed against a schedule entry.
  • MRP_SCHEDULE_DATES (SYNONYM) — provides the schedule date dimension associated with each MPS entry.
  • PO_HEADERS_ALL (SYNONYM) — supplies purchase order header context where relief originates from a PO.
  • PO_REQUISITION_HEADERS_ALL (SYNONYM) — supplies requisition header context.
  • RCV_SHIPMENT_HEADERS (SYNONYM) — supplies shipment and receipt header context.
  • WIP_ENTITIES (SYNONYM) — supplies work in process entity information for manufacturing orders.

These joins allow a single consumption record to be resolved to the originating document, whether that document is a purchase order, a requisition, a receipt shipment, or a discrete manufacturing order.

Key Columns

The view exposes fourteen columns. The most significant are:

Common Use Cases and Queries

The view is typically used to reconcile MPS relief against actual supply documents, to investigate why a schedule entry was reduced, and to build audit reports showing which orders consumed the plan. A representative query follows:

SELECT ORDER_NUMBER, ORDER_TYPE, LINE_NUMBER, RELIEF_QUANTITY, SCHEDULE_DATE, MPS_ENTRY_ID
FROM APPS.MRPFV_MPS_CONSUMPTIONS
WHERE SCHEDULE_DATE BETWEEN :from_date AND :to_date
ORDER BY SCHEDULE_DATE, ORDER_NUMBER;

Additional scenarios include filtering by MPS_ENTRY_ID to trace all relief applied to a single schedule entry, and aggregating RELIEF_QUANTITY by ORDER_TYPE to measure how much demand was satisfied by purchase orders versus WIP jobs or requisitions. Because the view is read-only and carries no dependencies from other objects, it can be queried freely without affecting planning data integrity.