Search Results mtl_kanban_source_type




Overview
Explore in AI Chat

Overview

The APPS.MTL_KANBAN_PULL_SEQUENCES_V view is a reporting and integration layer over Oracle EBS Kanban replenishment setup. It exposes pull sequence definitions configured for Kanban planning, presenting the source, sourcing organization, subinventory, locator, supplier, and replenishment parameters that govern how Kanban cards are replenished. The view is owned by APPS and is primarily consumed by Kanban execution and replenishment programs, as well as by custom reports and interfaces that need to resolve kanban sourcing attributes without joining the many supporting setup tables directly. Its central value is that it joins the pull sequence transaction table to organization, item, subinventory, and lookup reference data in a single flat structure.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

Common Use Cases and Queries

Typical uses include listing all pull sequences for a plan, identifying source types such as internal, supplier, or inter-org, and driving replenishment reports. A representative query:

  • SELECT pull_sequence_id, organization_id, inventory_item_id, source_type, source_type_meaning, source_org_code, subinventory_name FROM apps.mtl_kanban_pull_sequences_v WHERE kanban_plan_id = :p_plan_id;
  • SELECT source_type, source_type_meaning, COUNT(*) FROM apps.mtl_kanban_pull_sequences_v GROUP BY source_type, source_type_meaning;
  • SELECT pull_sequence_id, supplier_id, supplier_site_id, source_organization_id FROM apps.mtl_kanban_pull_sequences_v WHERE source_type = 3;

Because SOURCE_TYPE_MEANING is derived from MTL_KANBAN_SOURCE_TYPE in MFG_LOOKUPS, the view is well suited for reporting that must present decoded source types without an additional lookup join.