Search Results auto_process_rma




Overview
Explore in AI Chat

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

Overview

CSD.CSD_REPAIR_TYPES_B is the base configuration table within the Oracle E-Business Suite Depot Repair (CSD) module that stores all repair type definitions. In EBS 12.1.1 and 12.2.2, it functions as the master repository of repair type metadata that governs how a repair order flows through the depot repair lifecycle. Each row defines a distinct repair type, including its associated workflow, billing rules, pricing, and sales order integration behaviors. The table is seeded with Oracle-provided repair types and can be extended with user-defined entries.

From a Data Vault modeling perspective, the mined foreign-key structure classifies CSD_REPAIR_TYPES_B as hub-leaning. This suggests that the table acts primarily as a business entity hub, holding a stable, unique identifier (REPAIR_TYPE_ID) around which descriptive and transactional satellites and link tables cluster. It is not a pure transactional fact table but rather a reference/configuration entity that many downstream objects depend upon.

Key Information Stored

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

Common Use Cases and Queries

Typical reporting and configuration audits query this table to validate repair type setup before creating repair orders. A common pattern joins the translation table to present user-facing names:

  • Listing active repair types: SELECT REPAIR_TYPE_ID, REPAIR_TYPE_REF FROM CSD_REPAIR_TYPES_B WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE;
  • Resolving repair type names via CSD_REPAIR_TYPES_TL using REPAIR_TYPE_ID.
  • Auditing which repair types interface to Order Management by filtering on INTERFACE_TO_OM_FLAG.
  • Reconciling repair volume by type through CSD_REPAIRS.REPAIR_TYPE_ID.
  • Reviewing billing configuration by joining to CS_TXN_BILLING_TYPES.
  • Feeding reporting materialized views such as ISC_DR_CURR_01_MV and ISC_DR_COSTS_01_MV, which denormalize repair type attributes for analytics.

Related Objects

The most significant objects dependent on or referenced by this table include:

  • CSD_REPAIRS — Joins on REPAIR_TYPE_ID; the transactional repair order records.
  • CSD_REPAIR_TYPES_TL — Translation table keyed by REPAIR_TYPE_ID, providing multilingual descriptions.
  • CSD_REPAIR_TYPES_SAR — Sub-account/segment association table.
  • CSD_REPAIR_ORDER_GROUPS — Groups repair orders by REPAIR_TYPE_ID.
  • CSD_FLWSTS_TRANS_B — Flow status transitions keyed by REPAIR_TYPE_ID.
  • WF_ITEM_TYPES — Referenced via WORKFLOW_ITEM_TYPE.
  • CS_BUSINESS_PROCESSES — Referenced via BUSINESS_PROCESS_ID.
  • QP_LIST_HEADERS_B — Referenced via PRICE_LIST_HEADER_ID.
  • CS_TXN_BILLING_TYPES — Referenced via CPR_TXN_BILLING_TYPE_ID.
  • ISC_DR_*_MV materialized views — Analytic views (current, backlog, MTTR, costs, charges) keyed by REPAIR_TYPE_ID.