Search Results csd_repair_order_groups




Overview
Explore in AI Chat

Overview

The CSD_REPAIR_ORDER_GROUPS table is a core transactional entity within the Oracle E-Business Suite (EBS) Depot Repair (CSD) module, specifically in versions 12.1.1 and 12.2.2. It serves as the master definition table for repair order groups, a fundamental concept in the repair workflow. A repair order group acts as a logical container that aggregates one or more individual repair order lines. This grouping mechanism is essential for managing complex repairs where a single service incident may require multiple, distinct repair actions on the same item. The table is central to the repair order lifecycle, linking the initial service request to specific repair types and the subsequent manufacturing work order created in the Work in Process (WIP) module.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the critical data stored. The primary identifier is the REPAIR_GROUP_ID. The table stores foreign keys that establish its core business relationships: the INCIDENT_ID links the group to a specific service request or case in the Service module (CS_INCIDENTS_ALL_B). The REPAIR_TYPE_ID defines the classification of repair being performed, referencing the CSD_REPAIR_TYPES_B table. Finally, the WIP_ENTITY_ID is a crucial column that stores a reference to the discrete job created in the WIP_DISCRETE_JOBS table when the repair order is released for execution, bridging the service and manufacturing execution processes.

Common Use Cases and Queries

This table is pivotal for reporting and process tracking in Depot Repair. Common use cases include generating a summary of all repair groups for a specific service incident, tracking the status of repairs by joining to the WIP job, and analyzing repair volumes by type. A typical query would join CSD_REPAIR_ORDER_GROUPS to CS_INCIDENTS_ALL_B to report on all repair groups for open cases. Another critical query involves joining to WIP_DISCRETE_JOBS to identify repair groups that have been released to the shop floor but are not yet complete. Data from this table is also essential for process flows that create repair lines from the defined group and for managing serial number tracking (via CSD_MRO_SERIAL_NUMBERS) for items under repair.

Related Objects

The CSD_REPAIR_ORDER_GROUPS table is a central hub within the Depot Repair schema, with documented relationships to several key objects.

  • Referenced Tables (Foreign Keys from CSD_REPAIR_ORDER_GROUPS):
    • CS_INCIDENTS_ALL_B: Joined via INCIDENT_ID. Links the repair group to the originating service request.
    • CSD_REPAIR_TYPES_B: Joined via REPAIR_TYPE_ID. Defines the classification of the repair.
    • WIP_DISCRETE_JOBS: Joined via WIP_ENTITY_ID. Links to the manufacturing work order created for the repair.
  • Dependent Tables (Foreign Keys to CSD_REPAIR_ORDER_GROUPS):
    • CSD_GROUP_JOB_PARAM_TEMP: References REPAIR_GROUP_ID. Likely a temporary table for job parameter processing.
    • CSD_MRO_SERIAL_NUMBERS: References REPAIR_GROUP_ID. Tracks serial numbers associated with the repair group.
    • CSD_REPAIRS: References REPAIR_GROUP_ID. This is a critical relationship where the individual repair order lines are stored, directly implementing the "one group to many repair lines" model.