Search Results csd_ro_service_codes




Overview
Explore in AI Chat

Overview

CSD_RO_SERVICE_CODES is a Depot Repair (CSD) module table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. Its documented purpose is to store the mapping between Repair Orders and Service codes. In practical terms, each row associates a service code defined in the service code setup with the specific repair line (and therefore the repair order) on which that service is applicable or has been applied. This makes the table an intersection between the repair execution side of Depot Repair and the service catalog side of the module.

The ETRM metadata classifies this object heuristically as a standalone Data Vault structure. In Data Vault modeling terms, this heuristics suggests a link-style or reference table rather than a pure hub or satellite: the table captures a many-to-many style relationship (repair lines to service codes) and carries descriptive and state-bearing columns such as applicability flags and applied flags. Because the table has no foreign keys pointing outward to additional parent tables beyond the documented repair line and service code references, it is best modeled as a relationship carrier with light satellite attributes rather than a central hub.

All documented columns number 32, and the owner/schema is CSD. The object is reported as VALID in the ETRM metadata.

Key Information Stored

Although the table contains 32 documented columns, the following are the most significant for functional and reporting purposes:

Common Use Cases and Queries

Typical reporting scenarios include listing all service codes attached to a repair order, determining which service codes have been applied to estimates versus actual work, and reconciling repair job cross-references back to service code definitions.

A representative query joining the mapping to its parent repair and service code tables:

  • SELECT rsc.ro_service_code_id, rsc.repair_line_id, rsc.service_code_id, rsc.applicable_flag, rsc.applied_to_est_flag, rsc.applied_to_work_flag FROM csd.csd_ro_service_codes rsc, csd.csd_repairs rp, csd.csd_service_codes_b scb WHERE rsc.repair_line_id = rp.repair_line_id AND rsc.service_code_id = scb.service_code_id;

To find mappings that have not yet been applied to work, filter on APPLIED_TO_WORK_FLAG = 'N'. To audit changes, query on LAST_UPDATE_DATE and LAST_UPDATED_BY. Because the table participates in the OAF framework, updates to APPLICABLE_FLAG or the applied flags should typically be performed through the Depot Repair UI or the corresponding public APIs rather than direct DML, to preserve OBJECT_VERSION_NUMBER consistency.

Related Objects

The most significant objects related to CSD_RO_SERVICE_CODES, based on the documented foreign key relationships, are:

  • CSD_REPAIRS — Referenced by CSD_RO_SERVICE_CODES.REPAIR_LINE_ID; the primary parent identifying the repair line.
  • CSD_SERVICE_CODES_B — Referenced by CSD_RO_SERVICE_CODES.SERVICE_CODE_ID; holds the base service code definitions.
  • CSD_REPAIR_JOB_XREF — References CSD_RO_SERVICE_CODES.RO_SERVICE_CODE_ID, linking repair jobs to the service code mapping.
  • CSD_REPAIR_ESTIMATE_LINES — References CSD_RO_SERVICE_CODES.RO_SERVICE_CODE_ID, tying estimate lines back to the mapped service code.

These relationships establish CSD_RO_SERVICE_CODES as the bridge between repair execution structures (repairs, jobs, estimates) and the service code catalog, and they define the primary join paths used in Depot Repair reporting and data extracts.