Results for “reference_number”

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

Overview

CSD.CSD_MRO_SERIAL_NUMBERS is a transactional table within the Oracle E-Business Suite Depot Repair (CSD) module. Its documented purpose is to store the serial numbers of items belonging to a repair order group. In the Depot Repair flow, customers return defective or repairable units that are tracked by serial number; this table is the bridge that associates those tracked unit instances with the repair group under which they are processed. It therefore acts as the authoritative record linking a repair group to the specific customer product instances covered by that group.

Mined from its foreign key structure, the heuristic Data Vault classification for this object is a link. This is a modeling suggestion rather than a documented property: the table carries a surrogate key and resolves many-to-many style associations among repair groups, serialized customer products, and security groups, which is characteristic of a link entity rather than a hub or satellite.

Key Information Stored

The table contains 29 documented columns. The most significant include:

• MRO_SERIAL_NUMBER_ID — the surrogate primary key, enforced by CSD_MRO_SERIAL_NUMBER_PK1 and also backed by the unique index CSD_MRO_SERIAL_NUMBER_U1, making it the strongest business-key candidate.
• REPAIR_GROUP_ID — foreign key to CSD_REPAIR_ORDER_GROUPS, identifying the repair order group to which the serialized item belongs.
• CUSTOMER_PRODUCT_ID — foreign key to CSI_ITEM_INSTANCES, identifying the specific serialized customer product instance.
• SERIAL_NUMBER — the human-readable serial number value for the item.
• VALIDATE_LEVEL — controls the level at which serial number validation is applied during repair processing.
• REFERENCE_NUMBER — an auxiliary reference value associated with the serial record.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org data security.
• OBJECT_VERSION_NUMBER — supports optimistic locking during concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.
• CONTEXT and ATTRIBUTE1–15 — the standard descriptive flexfield (DFF) container columns for extensible customer attributes.

Common Use Cases and Queries

Typical scenarios include listing all serialized units in a repair group, tracing a serial number back to its repair group, and reconciling customer product instances against repair activity. A representative query joining to the referenced tables:

• SELECT s.MRO_SERIAL_NUMBER_ID, s.SERIAL_NUMBER, s.REPAIR_GROUP_ID, s.CUSTOMER_PRODUCT_ID FROM CSD.CSD_MRO_SERIAL_NUMBERS s WHERE s.REPAIR_GROUP_ID = :p_group_id;
• Join to CSD_REPAIR_ORDER_GROUPS on REPAIR_GROUP_ID to enrich serial records with group-level attributes.
• Join to CSI_ITEM_INSTANCES on CUSTOMER_PRODUCT_ID to retrieve the full item instance detail for each serial.

Reporting use cases include serial number validation audits (via VALIDATE_LEVEL) and security-scoped extracts filtered on SECURITY_GROUP_ID.

Related Objects

• CSD_REPAIR_ORDER_GROUPS — referenced via CSD_MRO_SERIAL_NUMBERS.REPAIR_GROUP_ID; the parent repair group for each serial record.
• CSI_ITEM_INSTANCES — referenced via CSD_MRO_SERIAL_NUMBERS.CUSTOMER_PRODUCT_ID; the serialized customer product instance.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; governs row-level security.
• The primary key CSD_MRO_SERIAL_NUMBER_PK1 and unique index CSD_MRO_SERIAL_NUMBER_U1 on MRO_SERIAL_NUMBER_ID define uniqueness and support dependent child references.
• Depot Repair forms and concurrent programs that manage repair order groups consume this table to resolve the serialized contents of a group.