Search Results csd_repair_actual_lines




Overview
Explore in AI Chat

Overview

The CSD_REPAIR_ACTUAL_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 actual costs, charges, and material usage incurred during a repair transaction. This table is essential for capturing the granular financial and operational details of a repair job, enabling accurate cost tracking, billing, and variance analysis against the original repair estimate. Its existence is critical for the module's ability to manage repair profitability, inventory consumption, and service charge fulfillment.

Key Information Stored

While the provided metadata does not list specific columns beyond the keys, the table's description and relationships define its core data. Each record represents a single line item of actual cost associated with a repair. The primary identifier is the REPAIR_ACTUAL_LINE_ID. Crucially, each line is linked to a parent repair actuals header via the REPAIR_ACTUAL_ID foreign key. Furthermore, the ESTIMATE_DETAIL_ID column provides a direct relationship to the corresponding line in the original estimate (CS_ESTIMATE_DETAILS), allowing for precise line-by-line comparison between estimated and actual costs. Typical data stored in this table includes the actual quantity of parts consumed, actual labor hours expended, actual material costs, and any additional miscellaneous charges applied during the repair execution.

Common Use Cases and Queries

This table is central to several key business processes and reports. A primary use case is generating a repair cost variance report, which compares estimated costs to actuals. Analysts query this table joined to CS_ESTIMATE_DETAILS to identify significant cost overruns or savings on labor, parts, or overhead. Another critical use is in the posting of actual repair costs to inventory and general ledger modules, where the consumed quantities and values are sourced from this table. For technical support and data validation, a common query retrieves all actual lines for a specific repair order to audit completeness.

  • Sample Query (Variance Analysis): SELECT e.estimated_quantity, a.actual_quantity, e.estimated_cost, a.actual_cost FROM csd_repair_actual_lines a, cs_estimate_details e WHERE a.estimate_detail_id = e.estimate_detail_id AND a.repair_actual_id = :p_repair_actual_id;
  • Sample Query (Repair Line Details): SELECT * FROM csd_repair_actual_lines WHERE repair_actual_id = (SELECT repair_actual_id FROM csd_repair_actuals WHERE repair_line_id = :p_repair_line_id);

Related Objects

The CSD_REPAIR_ACTUAL_LINES table sits at the intersection of the repair execution and estimation sub-systems. Its documented foreign key relationships are fundamental to data integrity and application logic.

  • CSD_REPAIR_ACTUALS: This is the parent header table. The relationship is maintained via the column CSD_REPAIR_ACTUAL_LINES.REPAIR_ACTUAL_ID, which references CSD_REPAIR_ACTUALS. Every actual line must belong to a single repair actuals header record.
  • CS_ESTIMATE_DETAILS: This is the source estimate line table. The relationship is maintained via the column CSD_REPAIR_ACTUAL_LINES.ESTIMATE_DETAIL_ID, which references CS_ESTIMATE_DETAILS. This link enables the system to track which specific estimated line item the actual cost fulfills, forming the basis for variance reporting.