Search Results mtl_cycle_count_items




Overview
Explore in AI Chat

Overview

The MTL_CYCLE_COUNT_ITEMS table is a core data object within the Oracle E-Business Suite (EBS) Inventory (INV) module, specifically for releases 12.1.1 and 12.2.2. It serves as the detailed definition table for items that have been selected for inclusion in a cycle counting program. While the MTL_CYCLE_COUNT_HEADERS table defines the overall parameters of a cycle count, such as its name and schedule, MTL_CYCLE_COUNT_ITEMS defines the specific inventory items that will be counted under each header. This table is fundamental to the setup and execution of cycle counting, a critical inventory accuracy process where subsets of items are counted on a recurring basis.

Key Information Stored

The table's structure is designed to link items to cycle count headers and store item-specific counting parameters. Its primary key is a composite of CYCLE_COUNT_HEADER_ID and INVENTORY_ITEM_ID, ensuring a unique definition for each item within a specific count. Key columns include CYCLE_COUNT_HEADER_ID, which links to MTL_CYCLE_COUNT_HEADERS, and INVENTORY_ITEM_ID, which identifies the master item from MTL_SYSTEM_ITEMS_B. Another critical column is ABC_CLASS_ID, which links to MTL_ABC_CLASSES and MTL_CYCLE_COUNT_CLASSES, defining the ABC classification and associated counting frequency for the item within this specific cycle count. The table also tracks scheduling and control information, such as the last count date and the number of counts scheduled, which are managed by related entities like MTL_CC_SCHEDULE_REQUESTS.

Common Use Cases and Queries

This table is central to queries for auditing cycle count setups, troubleshooting missing items in schedules, and generating custom reports. A common scenario is identifying all items assigned to a specific cycle count for review.

  • List Items in a Cycle Count: SELECT mcci.inventory_item_id, msi.segment1 item_code, mcci.abc_class_id FROM mtl_cycle_count_items mcci JOIN mtl_system_items_b msi ON mcci.inventory_item_id = msi.inventory_item_id WHERE mcci.cycle_count_header_id = &header_id;
  • Audit ABC Class Assignments: SELECT mcci.cycle_count_header_id, mcch.cycle_count_header_name, mcci.abc_class_id, mac.abc_class_name, COUNT(*) item_count FROM mtl_cycle_count_items mcci JOIN mtl_cycle_count_headers mcch ON mcci.cycle_count_header_id = mcch.cycle_count_header_id JOIN mtl_abc_classes mac ON mcci.abc_class_id = mac.abc_class_id GROUP BY mcci.cycle_count_header_id, mcch.cycle_count_header_name, mcci.abc_class_id, mac.abc_class_name;

Related Objects

MTL_CYCLE_COUNT_ITEMS has integral relationships with several key Inventory tables, forming the backbone of the cycle counting setup.

  • MTL_CYCLE_COUNT_HEADERS: The primary parent table, linked via CYCLE_COUNT_HEADER_ID.
  • MTL_ABC_CLASSES & MTL_CYCLE_COUNT_CLASSES: Provide the ABC classification and counting rules via ABC_CLASS_ID.
  • MTL_CC_SCHEDULE_REQUESTS: A child table that generates the actual count schedules based on the item definitions in MTL_CYCLE_COUNT_ITEMS.
  • MTL_SYSTEM_ITEMS_B: The source of the INVENTORY_ITEM_ID, providing descriptive item information.