Search Results mrp_kanban_comparison_v




Overview
Explore in AI Chat

Overview

The MRP_KANBAN_COMPARISON_V view is a Kanban comparison view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to compare two Kanban pull sequence configurations for the same inventory item, subinventory, and locator combination, thereby enabling planners and manufacturing personnel to evaluate variations in Kanban card sizing and pull signals across the "from" and "to" states.

Within the Master Scheduling/MRP product family, Kanban execution relies on pull sequences that describe how material is replenished at a given point of use. This view correlates a source pull sequence (PSFROM) with a target pull sequence (PSTO) so that differences in Kanban size, number of cards, and plan assignment can be reviewed side by side. It is therefore useful both as a reconciliation aid during plan redefinition and as a data source for custom reports and integration interfaces that must surface Kanban configuration deltas.

Underlying Base Objects

The view is defined over the following documented base objects:

The join logic correlates the two pull-sequence instances by matching item, subinventory, and locator (with a NVL default of 1 for null locators), while also tying KANFROM to the same Kanban plan as PSFROM and to the same organization as PSTO.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing pull-sequence changes before committing a plan, identifying items where Kanban quantities differ significantly between two states, and feeding exception reports. A representative query follows:

  • Compare Kanban sizing for a given item and organization across two plans to highlight material variance.
  • Report all pull sequences associated with a Kanban plan using the plan name derived from the lookup.
  • Join the view to item and plan master data for a Kanban configuration dashboard.

For example, to surface significant Kanban quantity deltas:

SELECT organization_id, concatenated_segments, subinventory_name, kanban_size, number_of_cards FROM apps.mrp_kanban_comparison_v WHERE organization_id = :org_id AND plan_name_to = :plan_name AND ROUND(DECODE(kanban_size * number_of_cards, 0, 0, 1), 2) IS NOT NULL;

Because the view references packaged functions and a KFV synonym, queries should be run against the APPS schema with the standard EBS responsibility and MO profile options in place to ensure correct organization security and item visibility.