Search Results mrpbv_mps_consumptions




Overview
Explore in AI Chat

Overview

The APPS.MRPBV_MPS_CONSUMPTIONS view is a Master Scheduling/MRP (MRP) reporting object that exposes consumption—also referred to as relief—activity recorded against master production schedule (MPS) entries. In Oracle EBS 12.1.1 and 12.2.2, MPS schedule relief captures the reduction of a scheduled MPS quantity as that demand is satisfied by a downstream supply document such as a purchase order, requisition, or receiving shipment. The view consolidates this relief data from the MRP_SCHEDULE_CONSUMPTIONS table and resolves the originating document reference into meaningful supply identifiers.

The object is defined in the APPS schema and carries VALID status. Its principal role is to serve as an MPS consumption enquiry, supporting reports, concurrent programs, and integration extracts that need to reconcile scheduled MPS quantities against the actual supply documents that consumed them. Because the view joins schedule consumption rows to schedule date rows filtered by organization, it is effectively a multi-organization secured reporting layer over the underlying MRP scheduling data.

Underlying Base Objects

The documented referenced base objects are MFG_LOOKUPS (VIEW), MRP_SCHEDULE_CONSUMPTIONS (SYNONYM), MRP_SCHEDULE_DATES (SYNONYM), PO_HEADERS_ALL (SYNONYM), PO_REQUISITION_HEADERS_ALL (SYNONYM), RCV_SHIPMENT_HEADERS (SYNONYM), and WIP_ENTITIES (SYNONYM). The view is a UNION ALL of three branches, each drawing from MRP_SCHEDULE_CONSUMPTIONS and MRP_SCHEDULE_DATES and then joining to a distinct disposition source:

  • Purchase order branch: joins PO_HEADERS_ALL on PO_HEADER_ID = MRSC.DISPOSITION_ID for DISPOSITION_TYPE 2 and 6.
  • Receiving branch: joins RCV_SHIPMENT_HEADERS on SHIPMENT_HEADER_ID = MRSC.DISPOSITION_ID for DISPOSITION_TYPE 7 and 8.
  • Requisition branch: joins PO_REQUISITION_HEADERS_ALL for DISPOSITION_TYPE 5.

MFG_LOOKUPS supplies the lookup meaning for the MRP_RELIEF_ORIGINATION lookup type, and MRP_SCHEDULE_DATES provides the MPS_TRANSACTION_ID linkage and organization-dependent filtering. WIP_ENTITIES is a documented reference associated with the disposition resolution context.

Key Columns

The view exposes a consistent set of columns across all three UNION ALL branches:

  • LINE_NUM — the schedule line identifier for the consumed MPS entry.
  • RELIEF_QUANTITY — the quantity by which the MPS schedule was relieved or consumed by the originating supply document.
  • SCHEDULE_DATE — the date of the MPS schedule entry to which the relief applies.
  • TRANSACTION_ID — the MPS transaction identifier linked to MRP_SCHEDULE_DATES.
  • Disposition identifiers (columns five through eight) — each branch populates only the column matching its disposition type family using DECODE. Purchase order dispositions appear in the first such column, receiving in the second, and requisitions in the third; the remaining columns return NULL.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY from MRP_SCHEDULE_CONSUMPTIONS.

Common Use Cases and Queries

Typical uses include reconciling MPS relief against open supply, auditing which document type consumed a scheduled quantity, and feeding planning or exception reports. The following sample retrieves recent consumption records:

SELECT line_num, relief_quantity, schedule_date, transaction_id, creation_date FROM apps.mrpbv_mps_consumptions WHERE schedule_date >= SYSDATE - 30 ORDER BY schedule_date, line_num;

Analysts frequently aggregate relief by date to compare scheduled versus consumed quantities, or join TRANSACTION_ID back to MRP_SCHEDULE_DATES to resolve the item and organization. Because the view is organization secured through the schedule date row, queries return only data for organizations the responsibility is authorized to access.