Results for “mps_entry_id”

18 results




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

Overview

MRPFV_MPS_ENTRIES is a read-only Oracle EBS view owned by the APPS schema in the MRP (Master Scheduling/MRP) product family. It exposes Master Production Schedule (MPS) entry data — the dated, item-level schedule quantities and rates that drive the MPS planning engine. The view presents entries drawn from MRP_SCHEDULE_DATES restricted to MPS-type designators (marked internally by SCHEDULE_TYPE = 2 on the underlying designator header), then denormalizes each row with organization, line, project, and lookup descriptions to produce a human-readable, reporting-friendly projection.

The view is defined WITH READ ONLY, meaning it is intended exclusively for query and reporting access and cannot be used as the target of DML. The ETRM description carries the annotation "Retrofitted," indicating that the object was formalized into the ETRM catalog rather than originating as a documented seeded artifact. For functional and technical users searching on the term "mps_entry_id," this view is the primary reporting surface over the MPS schedule entry data maintained in the underlying schedule tables.

Underlying Base Objects

The view is defined over eight documented base objects:

  • MRP_SCHEDULE_DATES (alias SCDA) — the driving table containing the actual schedule entry rows: dates, quantities, rates, and comments.
  • MRP_SCHEDULE_ITEMS (SCIT) — the item-level association joining schedule entries to a specific organization and schedule designator.
  • MRP_SCHEDULE_DESIGNATORS (SCDE) — the schedule header; the view filters on SCHEDULE_TYPE = 2 to isolate MPS designators.
  • MTL_PARAMETERS (PA, PA2) — supplies the organization code (and source organization code via an outer join).
  • HR_ALL_ORGANIZATION_UNITS (ORG, ORG2) — supplies the organization name and the source organization name through outer joins.
  • WIP_LINES (LI) — an outer join providing the production line code for repetitive schedule entries.
  • MFG_LOOKUPS (LKUP) — joined on LOOKUP_TYPE = 'MRP_SCHEDULE_ORIG' to translate the schedule origination type into a meaning.
  • MRP_GET_PROJECT — a package supplying project and task name resolution through its PROJECT and TASK functions.

The joins effectively flatten the MPS schedule model — header, item, and dated entry — into a single denormalized row per MPS entry, enriched with descriptive attributes.

Key Columns

Common Use Cases and Queries

The view is typically used for MPS reporting, schedule comparison, and reconciliation between organizations or against forecast source designators.

SELECT organization_code,
       organization_name,
       schedule_name,
       schedule_date,
       current_quantity,
       repetitive_daily_rate
FROM   apps.mrpfv_mps_entries
WHERE  organization_code = :org_code
AND    schedule_date BETWEEN :start_date AND :end_date
ORDER  BY schedule_date;

To reconcile current versus originally scheduled quantities:

SELECT schedule_name,
       schedule_date,
       current_quantity,
       original_schedule_quantity,
       (current_quantity - original_schedule_quantity) variance
FROM   apps.mrpfv_mps_entries
WHERE  current_quantity <> original_schedule_quantity;

Because the view is read-only and includes project, task, and line descriptions, it is well suited to ad hoc reporting and downstream extracts without requiring custom joins to the eight underlying base objects.