Search Results mtl_cc_subinventories_pk

Overview

The MTL_CC_SUBINVENTORIES table is a core data object within the Oracle E-Business Suite (EBS) Inventory (INV) module. Its primary function is to define and store the specific subinventories that are included in a subinventory-level cycle count. A cycle count is a critical inventory management process for auditing and maintaining accurate on-hand quantities. When a cycle count is defined at the subinventory level, this table acts as the junction, linking a parent cycle count definition (header) to the precise storage sub-locations that will be subject to the counting activity. It is essential for configuring and executing targeted physical inventory audits.

Key Information Stored

The table's structure is relatively simple, focusing on the relationship between a cycle count and its designated subinventories. The primary columns, as indicated by the metadata, are CYCLE_COUNT_HEADER_ID and SUBINVENTORY, which together form the table's primary key (MTL_CC_SUBINVENTORIES_PK). The CYCLE_COUNT_HEADER_ID is a foreign key that references the MTL_CYCLE_COUNT_HEADERS table, tying each record to a specific cycle count definition. The SUBINVENTORY column stores the code of the subinventory to be included in that particular cycle count. This design ensures that a given subinventory can only be listed once for a specific cycle count header, preventing duplicate assignments.

Common Use Cases and Queries

This table is central to the setup and analysis of subinventory-level cycle counting. Common operational and reporting scenarios include validating the scope of an active cycle count, generating lists of subinventories due for counting, and auditing count setup. A typical query would join this table to the cycle count headers and subinventory master table to produce a readable report.

• Identifying Subinventories for a Specific Cycle Count: SELECT subinventory FROM inv.mtl_cc_subinventories WHERE cycle_count_header_id = :p_header_id;
• Reporting All Cycle Counts and Their Assigned Subinventories: SELECT cch.cycle_count_header_name, ccs.subinventory FROM inv.mtl_cycle_count_headers cch, inv.mtl_cc_subinventories ccs WHERE cch.cycle_count_header_id = ccs.cycle_count_header_id ORDER BY 1, 2;

Related Objects

MTL_CC_SUBINVENTORIES has defined relationships with other key Inventory tables, forming a critical part of the cycle counting data model.

• MTL_CYCLE_COUNT_HEADERS: This is the primary parent table. The foreign key constraint on CYCLE_COUNT_HEADER_ID enforces that every entry in MTL_CC_SUBINVENTORIES must correspond to a valid record in the headers table, which defines the overall count parameters like schedule and tolerance.
• MTL_SECONDARY_INVENTORIES: While not explicitly listed as a foreign key in the provided metadata, the SUBINVENTORY column typically references valid codes from this master table, which defines all subinventories within the organization.
• Cycle Count Execution Tables: Data in MTL_CC_SUBINVENTORIES indirectly influences the creation of count entries (e.g., in MTL_CYCLE_COUNT_ENTRIES) for items within the listed subinventories.