Search Results csd_repair_estimate_lines




Overview
Explore in AI Chat

Overview

The CSD_REPAIR_ESTIMATE_LINES table is a core transactional entity within the Oracle E-Business Suite Depot Repair (CSD) module. It functions as the detailed line-level repository for cost estimates associated with a repair order. The table's primary role is to link the high-level repair estimate, defined in CSD_REPAIR_ESTIMATE, with the granular charge lines from the Service (CS) module's CS_ESTIMATE_DETAILS table. This design enables the Depot Repair application to manage and track estimated costs for parts, labor, and other expenses specific to the repair process while leveraging the centralized estimating engine of Oracle Service.

Key Information Stored

The table stores the linkage and contextual attributes for each estimated charge line on a repair. Its primary key, REPAIR_ESTIMATE_LINE_ID, uniquely identifies each record. The most critical foreign keys are REPAIR_ESTIMATE_ID, which ties the line to its parent estimate header, and ESTIMATE_DETAIL_ID, which references the specific charge detail in CS_ESTIMATE_DETAILS. Another significant foreign key is RESOURCE_ID, which links to the BOM_RESOURCES table, allowing the line to be associated with a specific labor or machine resource required for the repair task. This structure allows the table to store Depot-specific overrides or annotations to the standard service estimate details.

Common Use Cases and Queries

This table is central to reporting and auditing the estimated costs of repairs. Common operational queries involve listing all estimated lines for a given repair order to calculate a total estimated cost or to analyze cost breakdowns by part and labor. A typical reporting query would join to the parent estimate and repair order headers, as well as to the service estimate details to fetch charge descriptions and amounts.

  • Sample Query for Repair Estimate Lines:
    SELECT rel.repair_estimate_line_id,
          re.repair_estimate_id,
          ced.estimate_detail_id,
          ced.charge_type,
          ced.estimated_amount
    FROM csd_repair_estimate_lines rel,
          csd_repair_estimate re,
          cs_estimate_details ced
    WHERE rel.repair_estimate_id = re.repair_estimate_id
    AND rel.estimate_detail_id = ced.estimate_detail_id
    AND re.repair_order_id = :p_repair_order_id;

Related Objects

The CSD_REPAIR_ESTIMATE_LINES table is a dependent object with defined foreign key relationships to several key tables, as documented in the ETRM.

  • CSD_REPAIR_ESTIMATE: The parent header table. Joined via CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID = CSD_REPAIR_ESTIMATE.REPAIR_ESTIMATE_ID.
  • CS_ESTIMATE_DETAILS: The source for the charge line details. Joined via CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID = CS_ESTIMATE_DETAILS.ESTIMATE_DETAIL_ID.
  • BOM_RESOURCES: Provides resource information for labor or machine estimates. Joined via CSD_REPAIR_ESTIMATE_LINES.RESOURCE_ID = BOM_RESOURCES.RESOURCE_ID.