Search Results mrp_schedule_type




Overview
Explore in AI Chat

Overview

The APPS.MRPFV_PLAN_SCHEDULES view is a reporting and integration object within Oracle E-Business Suite that consolidates scheduling information for material requirements planning activities. It presents a denormalized, security-enabled picture of production and purchasing schedules associated with MRP plans and their subordinate schedules, joining organizational identifiers to human-readable names for both the owning organization and any input (source) organization. Because the view resolves lookup codes into their meanings, it is suited for operational reporting, ad-hoc queries, and downstream integrations that require descriptive schedule attributes rather than raw codes. The MRP_SCHEDULE_TYPE lookup referenced in the view definition is the primary dimension that distinguishes schedule types, making the view directly relevant to searches for the mrp_schedule_type concept.

Underlying Base Objects

The view is defined across several base objects documented in the ETRM metadata. It draws from MRP_PLANS for top-level plan and current schedule designators, and from MRP_PLAN_SCHEDULES for schedule-level detail at the input or source organization level. MTL_PARAMETERS supplies the organization code used to identify the owning and input organizations, while HR_ALL_ORGANIZATION_UNITS provides the corresponding organization name. The MFG_LOOKUPS view supplies the lookup meaning for schedule types. The definition is a three-branch UNION ALL: the first branch selects plan-level schedules where ORGANIZATION_SELECTION = 1, the second selects schedule records where PLAN_LEVEL = 2, and the third correlates two MRP_PLANS instances on organization and designator. Each branch filters against the MRP_SCHEDULE_TYPE lookup type and applies an organization-based security predicate.

Key Columns

Common Use Cases and Queries

Typical use cases include listing active schedules by plan, correlating an input organization to its owning organization, and filtering schedules by MRP_SCHEDULE_TYPE meaning. The view respects organization-level security through the embedded _SEC predicates, so results are inherently scoped to accessible organizations.

SELECT organization_code,
       name,
       compile_designator,
       curr_schedule_designator,
       meaning
FROM   apps.mrfv_plan_schedules
WHERE  meaning = 'Material Requirements Plan'
ORDER  BY organization_code, compile_designator;

Because the view resolves schedule lookup codes to descriptive meanings, it is frequently joined to planning or sourcing reports that require schedule-type labels, and it serves as a convenient source for integrations that must publish schedule metadata across organizations.