Search Results csd_ro_service_codes_pk1

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:

• RO_SERVICE_CODE_ID — The surrogate primary key, uniquely populated by the sequence-backed unique index CSD_RO_SERVICE_CODES_PK1 and duplicated as business-key candidate CSD_RO_SERVICE_CODES_U1. This column is the identifier referenced by downstream tables.
• REPAIR_LINE_ID — Foreign key to CSD_REPAIRS, identifying the repair order line to which the service code mapping applies.
• SERVICE_CODE_ID — Foreign key to CSD_SERVICE_CODES_B, identifying the service code being mapped.
• OBJECT_VERSION_NUMBER — Standard EBS optimistic locking column used by the OAF/ADF framework to detect concurrent updates.
• APPLICABLE_FLAG — Indicates whether the service code is applicable to the repair line.
• APPLIED_TO_EST_FLAG — Indicates whether the service code has been applied to the repair estimate.
• APPLIED_TO_WORK_FLAG — Indicates whether the service code has been applied to repair work execution.
• SOURCE_TYPE_CODE and SOURCE_SOLUTION_ID — Capture the origin of the mapping (for example, a solution or source document), supporting traceability of how the service code was attached.
• SERVICE_ITEM_ID — Links the mapping to an inventory service item where applicable.
• REC_TYPE_CODE — A record type discriminator used to distinguish categories of service code records.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) columns, available for customer-specific extensions.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the standard WHO audit trail.

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.