Search Results mps_entry_id




Overview
Explore in AI Chat

Overview

APPS.MRPBV_MPS_CONSUMPTIONS is a Business Intelligence System (BIS) view in the Oracle E-Business Suite APPS schema. It exposes relief activity associated with a particular production schedule entry, allowing planners and developers to trace how demand against an MPS (Master Production Schedule) entry has been consumed or relieved. The view is registered under FND Design Data MRP.MRPBV_MPS_CONSUMPTIONS and carries a status of VALID. Because it is a BIS view rather than a transactional base table, it is read-only in practice and intended for reporting, inquiry, and integration scenarios rather than direct DML.

The object the user searched for, mps_entry_id, is one of the view's exposed columns and acts as the primary linkage back to the originating MPS schedule entry. This makes the view particularly valuable when reconciling schedule relief against planning records.

Underlying Base Objects

The view is defined over a set of base objects, several of which are accessed through synonyms and lookups. The documented references are:

The view is not referenced by any other database object, confirming its role as a terminal reporting artifact.

Key Columns

  • MPS_ENTRY_ID (NUMBER) — identifier of the MPS schedule entry being relieved; the central join key.
  • LINE_NUMBER (VARCHAR2, 30) — line identifier for the schedule entry.
  • RELIEF_QUANTITY (NUMBER) — quantity of demand relieved against the entry.
  • SCHEDULE_DATE (DATE) — date on which the relief is scheduled.
  • PURCHASE_ORDER_HEADER_ID, SHIPMENT_HEADER_ID, REQUISITION_HEADER_ID, MFG_ORDER_ID — source document identifiers for the relief (MFG_ORDER_ID links to WIP entities).
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include reconciling MPS relief, auditing which supply documents consumed a given schedule entry, and feeding downstream reporting. A basic query filtering on the searched column is:

SELECT LINE_NUMBER, RELIEF_QUANTITY, SCHEDULE_DATE,
       MFG_ORDER_ID, PURCHASE_ORDER_HEADER_ID
FROM   APPS.MRPBV_MPS_CONSUMPTIONS
WHERE  MPS_ENTRY_ID = :mps_entry_id;

Aggregating relief per entry supports capacity and consumption analysis:

SELECT MPS_ENTRY_ID, SUM(RELIEF_QUANTITY) AS TOTAL_RELIEF
FROM   APPS.MRPBV_MPS_CONSUMPTIONS
GROUP  BY MPS_ENTRY_ID;