Search Results mrp_planning_code




Overview
Explore in AI Chat

Overview

MRP_SCHEDULE_ITEMS_V is an APPS-owned database view within the Oracle E-Business Suite Master Scheduling/MRP (MRP) product family. It presents a denormalized, reporting-friendly projection of master schedule items, combining scheduling designator data from MRP_SCHEDULE_ITEMS with item master attributes from the system items tables. The view surfaces descriptive item attributes, time fence configurations, and schedule-specific assignments in a single queryable object, avoiding the need for repeated joins across the item master and scheduling tables.

The view is primarily consumed by concurrent programs, Oracle Discoverer worksheets, BI Publisher reports, and custom SQL used in master production scheduling and material requirements planning analysis. Because it joins MTL_SYSTEM_ITEMS_VL and MFG_LOOKUPS, output columns include translated item descriptions and lookup meanings, making it suitable for end-user-facing reports. The REPETITIVE_PLANNING_FLAG column, derived from MTL_SYSTEM_ITEMS and defaulted to 'N' via NVL, indicates whether the item is planned using repetitive manufacturing logic — a frequently searched attribute in planning diagnostics and item setup audits.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying repetitive-planned items within a schedule, auditing time fence configuration, and validating planning codes ahead of a master schedule run.

SELECT item_number, item_description,
       repetitive_planning_flag,
       demand_time_fence_days, planning_time_fence_days
FROM   apps.mrp_schedule_items_v
WHERE  organization_id = :org_id
AND    schedule_designator = :designator
AND    repetitive_planning_flag = 'Y';

A time-fence audit query returns items whose fence dates fall within the current planning horizon:

SELECT item_number, schedule_designator,
       demand_time_fence_date, planning_time_fence_date
FROM   apps.mrp_schedule_items_v
WHERE  planning_time_fence_date >= SYSDATE
ORDER  BY planning_time_fence_date;

These queries make the view valuable for setup verification, exception reporting, and integration extracts destined for external planning systems.