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 = 2to 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
- ORGANIZATION_CODE / ORGANIZATION_NAME — the owning organization for the MPS entry.
- SCHEDULE_NAME / SCHEDULE_DESIGNATOR — the MPS schedule designator the entry belongs to.
- SCHEDULE_DATE / END_DATE (RATE_END_DATE) — the effective date range of the entry.
- CURRENT_QUANTITY (SCHEDULE_QUANTITY) / ORIGINAL_SCHEDULE_QUANTITY — the current and originally planned schedule quantities.
- REPETITIVE_DAILY_RATE — the daily rate for repetitive MPS entries.
- MEANING — decoded schedule origination type from MFG_LOOKUPS.
- Project and Task — resolved via MRP_GET_PROJECT.PROJECT and MRP_GET_PROJECT.TASK.
- LINE_CODE — the production line for repetitive schedules.
- END_ITEM_UNIT_NUMBER — the unit number for end-item identification.
- MPS_TRANSACTION_ID / REFERENCE_SCHEDULE_ID / SOURCE_SCHEDULE_ID — internal keys linking entries to their originating transactions and source schedules.
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.
-
View: MRPFV_MPS_ENTRIES 12.2.2
- Retrofitted
APPS.MRPFV_MPS_ENTRIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·Explore MRP module →
-
View: MRPFV_MPS_CONSUMPTIONS 12.2.2
APPS.MRPFV_MPS_CONSUMPTIONS·↳ MFG_LOOKUPS·↳ MRP_SCHEDULE_CONSUMPTIONS·↳ MRP_SCHEDULE_DATES·Explore MRP module →
-
View: MRPBV_MPS_CONSUMPTIONS 12.2.2
APPS.MRPBV_MPS_CONSUMPTIONS·↳ MFG_LOOKUPS·↳ MRP_SCHEDULE_CONSUMPTIONS·↳ MRP_SCHEDULE_DATES·Explore MRP module →
-
View: MRPBV_MPS_CONSUMPTIONS 12.1.1
APPS.MRPBV_MPS_CONSUMPTIONS·↳ MFG_LOOKUPS·↳ MRP_SCHEDULE_CONSUMPTIONS·↳ MRP_SCHEDULE_DATES·Explore MRP module →
-
View: MRPBV_MPS_ENTRIES 12.2.2
- Retrofitted
APPS.MRPBV_MPS_ENTRIES·↳ MFG_LOOKUPS·↳ MRP_SCHEDULE_DATES·↳ MRP_SCHEDULE_DESIGNATORS·Explore MRP module →
-
View: MRPFV_MPS_CONSUMPTIONS 12.1.1
APPS.MRPFV_MPS_CONSUMPTIONS·↳ MFG_LOOKUPS·↳ MRP_SCHEDULE_CONSUMPTIONS·↳ MRP_SCHEDULE_DATES·Explore MRP module →
-
View: MRPFV_MPS_ENTRIES 12.1.1
- Retrofitted
APPS.MRPFV_MPS_ENTRIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·↳ MRP_GET_PROJECT·Explore MRP module →
-
View: MRPBV_MPS_ENTRIES 12.1.1
- Retrofitted
APPS.MRPBV_MPS_ENTRIES·↳ MFG_LOOKUPS·↳ MRP_SCHEDULE_DATES·↳ MRP_SCHEDULE_DESIGNATORS·Explore MRP module →
-
VIEW: APPS.MRPBV_MPS_ENTRIES 12.1.1
-
VIEW: APPS.MRPFV_MPS_ENTRIES 12.1.1
-
VIEW: APPS.MRPFV_MPS_ENTRIES 12.2.2
-
VIEW: APPS.MRPBV_MPS_ENTRIES 12.2.2
-
eTRM - MRP Tables and Views 12.2.2
Recommendations based on user criteria selected in MRP Planner WorkBench
-
eTRM - MRP Tables and Views 12.1.1
Recommendations based on user criteria selected in MRP Planner WorkBench