Results for “mtl_cc_subinventories”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_CC_SUBINVENTORIES is an Inventory (INV) module table that defines which subinventories participate in subinventory-level cycle counting. In Oracle EBS 12.1.1 and 12.2.2, cycle counting can be performed at the subinventory level rather than at the organization level, and this table acts as the association between a cycle count header and the specific subinventories included in that counting program. Each row answers the question: "For this cycle count definition, which subinventory is being counted, and on what schedule?"

From a Data Vault modeling perspective, the mined relationship classification is satellite-leaning. The table carries descriptive and scheduling attributes (disable flag, counts per year, last schedule date, schedule order) that qualify the parent cycle count definition, rather than functioning as an independent hub of business keys. It is best understood as an attribute-bearing child of the cycle count header.

Key Information Stored

The table is defined with 11 documented columns. Its structure emphasizes the association between a cycle count header and a subinventory, plus the scheduling parameters governing that association.

• CYCLE_COUNT_HEADER_ID — Foreign key to MTL_CYCLE_COUNT_HEADERS. Identifies the parent cycle count definition to which the subinventory belongs.
• SUBINVENTORY — The subinventory code included in the cycle count program. Together with CYCLE_COUNT_HEADER_ID it forms the business-key candidate.
• DISABLE_FLAG — Indicates whether the subinventory is currently disabled for cycle counting within this header.
• NUM_COUNTS_PER_YEAR — The number of counts scheduled annually for this subinventory.
• LOC_LAST_SCHEDULE_DATE — The last date on which a count was scheduled for this subinventory.
• SCHEDULE_ORDER — The ordinal position determining the sequence in which subinventories are scheduled for counting.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The surrogate primary key is MTL_CC_SUBINVENTORIES_PK, defined over (CYCLE_COUNT_HEADER_ID, SUBINVENTORY). A separate unique index, MTL_CC_SUBINVENTORIES_U1, is documented over the same column pair, confirming that pair as the business-key candidate. The remaining columns are descriptive rather than identifying.

Common Use Cases and Queries

Typical uses include reconciling which subinventories are enrolled in a cycle count program, auditing scheduling parameters, and reporting on count frequency configuration. A representative query joining the parent header is:

• SELECT s.CYCLE_COUNT_HEADER_ID, s.SUBINVENTORY, s.NUM_COUNTS_PER_YEAR, s.SCHEDULE_ORDER, s.DISABLE_FLAG FROM MTL_CC_SUBINVENTORIES s WHERE s.CYCLE_COUNT_HEADER_ID = :header_id ORDER BY s.SCHEDULE_ORDER;
• Identifying active subinventories: filter WHERE DISABLE_FLAG = 'N'.
• Reporting count cadence: aggregate SUM(NUM_COUNTS_PER_YEAR) grouped by SUBINVENTORY across headers.
• Audit trail queries using LAST_UPDATE_DATE and LAST_UPDATED_BY to track configuration changes.

Related Objects

• MTL_CYCLE_COUNT_HEADERS — Parent table referenced via MTL_CC_SUBINVENTORIES.CYCLE_COUNT_HEADER_ID. The documented foreign key relationship.
• MTL_CYCLE_COUNT_CLASSES — Defines the ABC classes and count parameters associated with the cycle count header, indirectly governing subinventory inclusion.
• MTL_SECONDARY_INVENTORIES — Master subinventory definition; MTL_CC_SUBINVENTORIES.SUBINVENTORY logically corresponds to its SUBINVENTORY_CODE.
• MTL_CYCLE_COUNT_ENTRIES — Individual count entries generated under the parent header for these subinventories.
• INV Cycle Count concurrent programs and the Cycle Counts window — Standard EBS forms and processes that read and maintain this table.