Results for “mtl_cc_sched_count_xrefs”

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

Overview

MTL_CC_SCHED_COUNT_XREFS is an Inventory (INV) module table that cross-references count entry requests within the Oracle E-Business Suite cycle counting framework. The table acts as the associative bridge that ties a scheduled cycle count request to the specific count entry generated against it, ensuring the relationship between a cycle count schedule and its resulting physical count records is preserved and queryable. The object is owned by the INV schema and is marked VALID in the ETRM data dictionary for both 12.1.1 and 12.2.2.

Because the table exists solely to resolve a many-to-many style association between two distinct entities, the heuristic Data Vault classification mined from its foreign key structure is link. This classification is a modeling suggestion rather than a functional constraint: MTL_CC_SCHED_COUNT_XREFS carries its own surrogate/compound primary key while referencing two parent hubs, which is the defining characteristic of a link entity.

Key Information Stored

The documented physical schema contains twelve columns. The most significant are the two key columns and the descriptive and audit attributes, as follows:

• CYCLE_COUNT_SCHEDULE_ID — Part of the compound primary key (MTL_CC_SCHED_COUNT_XREFS_PK) and the unique index (MTL_CC_SCHED_COUNT_XREFS_U1). Foreign key to MTL_CC_SCHEDULE_REQUESTS, identifying the parent cycle count schedule request.
• CYCLE_COUNT_ENTRY_ID — The second component of the compound primary key and unique index. Foreign key to MTL_CYCLE_COUNT_ENTRIES, identifying the count entry record produced for the schedule.
• COUNT_DUE_DATE — The date by which the referenced count entry is expected to be completed, supporting scheduling and follow-up reporting.
• REQUEST_ID — The concurrent request identifier associated with the count creation or processing activity.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program context columns identifying which program last updated the row and when.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard EBS audit columns recording who created and last modified the record and from which login session.

The surrogate primary key is the compound MTL_CC_SCHED_COUNT_XREFS_PK, which is also the business-key candidate via the unique index MTL_CC_SCHED_COUNT_XREFS_U1 on the same two columns. There is no single-column surrogate key documented; the identity of the row is defined entirely by the schedule/entry pairing.

Common Use Cases and Queries

The primary use case is tracing which count entries belong to a given cycle count schedule request, and conversely, determining the schedule that originated a particular count entry. Typical reporting scenarios include cycle count accuracy analysis, audit of count generation, and reconciliation of scheduled versus performed counts.

To retrieve all count entries for a given schedule:

• SELECT cce.* FROM mtl_cycle_count_entries cce, mtl_cc_sched_count_xrefs x WHERE x.cycle_count_schedule_id = :schedule_id AND cce.cycle_count_entry_id = x.cycle_count_entry_id;

To identify the originating schedule and due date for a count entry:

• SELECT x.cycle_count_schedule_id, x.count_due_date FROM mtl_cc_sched_count_xrefs x WHERE x.cycle_count_entry_id = :entry_id;

Because the table is narrow and purely associative, it is well suited to being joined into cycle count inquiry reports and data extraction routines used by warehouse and inventory control teams.

Related Objects

MTL_CC_SCHED_COUNT_XREFS depends on and is referenced by the following principal objects:

• MTL_CC_SCHEDULE_REQUESTS — Referenced through CYCLE_COUNT_SCHEDULE_ID; the parent schedule request record.
• MTL_CYCLE_COUNT_ENTRIES — Referenced through CYCLE_COUNT_ENTRY_ID; the count entry record created against the schedule.
• MTL_CC_SCHED_COUNT_XREFS_PK — The compound primary key constraint enforcing uniqueness of the schedule/entry pair.
• MTL_CC_SCHED_COUNT_XREFS_U1 — The unique index providing the business-key candidate on the same two columns.
• Related cycle counting objects such as MTL_CYCLE_COUNT_HEADERS and MTL_CC_SCHEDULES, which share the same scheduling and counting flow, are frequently joined when building complete cycle count reporting.