Search Results mtl_kanban_cards

Overview

The MTL_KANBAN_CARDS table is the central repository for all Kanban card definitions within Oracle E-Business Suite Inventory (INV) modules, specifically for releases 12.1.1 and 12.2.2. It serves as the master transactional table for the Kanban replenishment system, a lean manufacturing methodology for signaling the need to produce or supply components. Each record in this table represents a physical or electronic Kanban card that governs the movement or production of a specific item quantity. The table's integrity is maintained by a primary key on KANBAN_CARD_ID and is intricately linked to core Inventory, Purchasing, and Work in Process entities through numerous foreign key relationships, enabling automated pull-based material flow.

Key Information Stored

The table stores comprehensive data defining each Kanban card's properties and its operational context. Critical columns include the unique identifier KANBAN_CARD_ID and the card NUMBER. It links to the item master via INVENTORY_ITEM_ID and ORGANIZATION_ID. Replenishment source details are captured in SOURCE_TYPE, SOURCE_ORGANIZATION_ID, and SOURCE_SUBINVENTORY, while the destination is defined by SUBINVENTORY_NAME and LOCATOR_ID. For production Kanbans, it references WIP_LINE_ID and PULL_SEQUENCE_ID. Supplier-related columns like SUPPLIER_ID and SUPPLIER_SITE_ID support external replenishment. Status is tracked via STATUS_CODE and CARD_STATUS, while quantities are defined by CONTAINER_CAPACITY and QUANTITY_PER_CARD. The table also holds control information such as GENERATION, LAST_TRANSACTION_ID, and START_DATE.

Common Use Cases and Queries

Primary use cases involve reporting on Kanban card status, troubleshooting replenishment signals, and auditing card utilization. Common analytical queries include identifying all active cards for a specific item, summarizing card counts by status or source type, and listing cards pending replenishment. A typical query to audit card details for an item would be:

• SELECT mkc.card_number, mkc.status_code, msi.segment1 item_code, mkc.container_capacity, mkc.subinventory_name FROM inv.mtl_kanban_cards mkc, inv.mtl_system_items_b msi WHERE mkc.inventory_item_id = msi.inventory_item_id AND mkc.organization_id = msi.organization_id AND msi.segment1 = '&ITEM' AND mkc.organization_id = &ORG_ID;

Another frequent operational query identifies cards that have triggered a replenishment request by joining to MTL_KANBAN_CARD_ACTIVITY or MTL_TXN_REQUEST_LINES on the KANBAN_CARD_ID.

Related Objects

As indicated by the foreign keys, MTL_KANBAN_CARDS is a hub table with extensive dependencies. Key related objects include:

• Master Data References: MTL_SYSTEM_ITEMS_B (item), MTL_SECONDARY_INVENTORIES (subinventory), MTL_PARAMETERS (org), PO_VENDORS and PO_VENDOR_SITES_ALL (supplier).
• Process Configuration: MTL_KANBAN_PULL_SEQUENCES, WIP_LINES, MTL_INTERORG_PARAMETERS.
• Transactional Child Tables: MTL_KANBAN_CARD_ACTIVITY logs all card transactions.
• Integration Points: The KANBAN_CARD_ID is referenced by interface and execution tables including PO_REQUISITIONS_INTERFACE_ALL, MTL_TXN_REQUEST_LINES, WIP_DISCRETE_JOBS, WIP_FLOW_SCHEDULES, and WIP_JOB_SCHEDULE_INTERFACE, demonstrating its critical role in driving procurement and manufacturing processes.