Search Results csd_repair_types_b




Overview
Explore in AI Chat

Overview

The CSD_REPAIR_TYPES_B table is a core master data table within the Oracle E-Business Suite Depot Repair (CSD) module. It serves as the central repository for defining and storing all valid repair types that can be performed within the application. A repair type is a fundamental classification that dictates the business process, workflow, pricing, and billing rules for a repair order. Its primary role is to provide a controlled list of repair classifications, ensuring consistency and enforcing business logic across all repair transactions. The table's integrity is maintained through its primary key and its relationships with numerous other transactional and setup tables in the CSD, Service (CS), and Order Management (QP) modules.

Key Information Stored

The table's structure is designed to link a repair type to its associated business rules. The most critical column is the primary key, REPAIR_TYPE_ID, which uniquely identifies each repair type definition. Other significant columns establish key relationships that govern the repair process. The BUSINESS_PROCESS_ID links to CS_BUSINESS_PROCESSES, defining the service process flow. The WORKFLOW_ITEM_TYPE references WF_ITEM_TYPES, specifying the Oracle Workflow for the repair. The PRICE_LIST_HEADER_ID connects to QP_LIST_HEADERS_B to determine the applicable pricing schedule, while the CPR_TXN_BILLING_TYPE_ID ties to CS_TXN_BILLING_TYPES to control billing behavior. Collectively, these columns make the repair type a central control point for repair execution.

Common Use Cases and Queries

This table is essential for setup, reporting, and data validation. Administrators use it to configure available repair types during implementation. Common operational queries include listing all active repair types for a LOV in the repair order form or identifying the business process associated with a specific type. A typical reporting query joins the table to transactional data to analyze repair volumes by type.

  • Sample Query for Repair Type Setup:
    SELECT rtb.repair_type_id, rtt.name, rtb.business_process_id, rtb.price_list_header_id FROM csd_repair_types_b rtb, csd_repair_types_tl rtt WHERE rtb.repair_type_id = rtt.repair_type_id AND rtt.language = USERENV('LANG');
  • Integration Point: When a user creates a repair order (CSD_REPAIRS), they must select a REPAIR_TYPE_ID. The system then automatically applies the linked workflow, pricing list, and billing rules defined in CSD_REPAIR_TYPES_B to that order.

Related Objects

As indicated by its foreign key relationships, CSD_REPAIR_TYPES_B is a pivotal hub within the Depot Repair schema. The primary transactional table, CSD_REPAIRS, references it to classify every repair order. Setup and grouping tables like CSD_REPAIR_ORDER_GROUPS and CSD_REPAIR_TYPES_SAR also depend on it. The translated descriptions are stored in the related TL table, CSD_REPAIR_TYPES_TL. Furthermore, its dependencies extend outside the CSD module to key setup tables: WF_ITEM_TYPES (Workflow), CS_BUSINESS_PROCESSES (Service), QP_LIST_HEADERS_B (Pricing), and CS_TXN_BILLING_TYPES (Billing), highlighting its integrative role in the service management ecosystem.