Results for “mrp_parameters_v”

18 results




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

Overview

MRP_PARAMETERS_V is a VALID database view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the MRP (Master Scheduling/MRP) product family and exposes the planning parameter configuration defined for each inventory organization. Functionally, the view presents a denormalized, reporting-friendly representation of a row in MRP_PARAMETERS, enriched with the human-readable ABC assignment group name resolved from MTL_ABC_ASSIGNMENT_GROUPS. Because the underlying MRP_PARAMETERS table stores only the numeric ASSIGNMENT_GROUP_ID for the default ABC compilation group, the view spares developers and report authors from performing that lookup manually.

The view is read-only from an application perspective and is intended for querying, reporting, and integration extraction rather than for maintenance of planning parameters. Parameter maintenance is performed through the Planner Workbench and the Oracle Master Scheduling/MRP setup windows, which write to the base table. The view therefore acts as a convenient access point for anyone who needs to inspect how planning is configured for a given organization, including the repetitive manufacturing attributes that the user's search term, repetitive_anchor_date, is associated with.

Underlying Base Objects

The view text is defined over two objects:

  • MRP_PARAMETERS (referenced as a synonym in APPS) — the primary base table holding one planning parameter row per organization. All operational planning columns originate here, aliased as M in the view definition.
  • MTL_ABC_ASSIGNMENT_GROUPS (referenced as a synonym in APPS) — joined to resolve the default ABC assignment group name. This is an outer join: MTL.ORGANIZATION_ID(+) = M.ORGANIZATION_ID AND MTL.ASSIGNMENT_GROUP_ID(+) = M.DEFAULT_ABC_ASSIGNMENT_GROUP. The outer join ensures that organizations without a matching ABC assignment group row still return their MRP parameters, with ABC_ASSIGNMENT_GROUP_NAME null.

The ROW_ID column is generated from MRP_PARAMETERS.ROWID, preserving a unique row identifier for the view result set.

Key Columns

The view exposes the full set of planning parameter columns. Significant groupings include:

Common Use Cases and Queries

Typical scenarios include verifying repetitive planning configuration across organizations, auditing time fence settings before a planning run, and joining planning parameters to organization master data in custom reports. A representative query retrieving repetitive settings is:

SELECT organization_id,
       repetitive_anchor_date,
       repetitive_horizon1,
       repetitive_horizon2,
       repetitive_bucket_size1,
       repetitive_bucket_size2,
       repetitive_bucket_size3,
       demand_time_fence_flag,
       planning_time_fence_flag
FROM   apps.mrp_parameters_v
WHERE  organization_id = :p_org_id;

To review the ABC group configuration across the enterprise:

SELECT organization_id,
       default_abc_assignment_group,
       abc_assignment_group_name,
       part_include_type,
       period_type
FROM   apps.mrp_parameters_v;

Because the view is defined in APPS, it is subject to standard EBS security conventions; queries should be issued against the APPS synonym so that the underlying base tables resolve correctly for the connecting user.