Results for “estimate_reason_code”

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

Overview

CSD_REPAIR_ESTIMATE is the header table for estimate lines within an Oracle E-Business Suite Depot Repair repair order. Owned by the CSD schema and valid in both 12.1.1 and 12.2.2, it anchors the estimate structure that field service and depot organizations use to quote labor, materials, and turnaround commitments to customers before authorizing repair work. Each row represents one estimate header tied to a repair line on a repair order, capturing the commercial and logistical terms proposed to the customer.

From a Data Vault modeling perspective, the object's foreign key topology classifies it heuristically as satellite-leaning. It carries the natural business context of the estimate (status, dates, terms, attributes) rather than serving as a pure hub of independent business keys or a pure link resolving many-to-many relationships between entities. The single-parent dependency on CSD_REPAIRS and the child lines in CSD_REPAIR_ESTIMATE_LINES reinforce this satellite-oriented reading, though the object also functions practically as a transactional header.

Key Information Stored

The primary key is the surrogate REPAIR_ESTIMATE_ID, enforced by CSD_REPAIR_ESTIMATE_PK and also backed by the unique index CSD_REPAIR_ESTIMATE_U1. No separate business-key column is documented beyond this identifier, so it serves as both the technical and effective business key.

The most consequential columns include:

• REPAIR_LINE_ID — foreign key to CSD_REPAIRS, tying the estimate to a specific repair line on the repair order.
• ESTIMATE_STATUS — lifecycle state of the estimate (for example, pending, approved, rejected, or expired).
• ESTIMATE_DATE — date the estimate was produced.
• NOT_TO_EXCEED — ceiling amount the customer is willing to authorize.
• ESTIMATE_FREEZE_FLAG — indicates whether the estimate is locked from further modification.
• ESTIMATE_REASON_CODE — coded reason associated with the estimate.
• WORK_SUMMARY — narrative description of the proposed repair scope.
• PO_NUMBER — customer purchase order reference supporting the estimate.
• LEAD_TIME and LEAD_TIME_UOM — promised turnaround and its unit of measure.
• ROUTING_SEQUENCE_ID — routing reference for the repair workflow.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS enforcing row-level security.
• OBJECT_VERSION_NUMBER — optimistic locking column for concurrent updates.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield and extensibility columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include reporting open estimates by status, tracking estimates awaiting customer approval, reconciling authorized estimates against repair lines, and monitoring lead-time commitments. A representative query joins the estimate header to its repair line:

SELECT e.repair_estimate_id, e.estimate_status, e.estimate_date,
  e.not_to_exceed, e.lead_time, e.lead_time_uom, e.po_number
FROM csd.csd_repair_estimate e, csd.csd_repairs r
WHERE e.repair_line_id = r.repair_line_id
  AND e.estimate_status = :status;

To count estimate lines per header, aggregate through the child table:

SELECT l.repair_estimate_id, COUNT(*)
FROM csd.csd_repair_estimate_lines l
GROUP BY l.repair_estimate_id;

Reporting is typically filtered by ESTIMATE_DATE ranges, ESTIMATE_STATUS, and SECURITY_GROUP_ID to respect organizational access. The ATTRIBUTE columns are frequently surfaced in custom descriptive flexfield reports.

Related Objects

• CSD_REPAIRS — parent repair order line; joined via CSD_REPAIR_ESTIMATE.REPAIR_LINE_ID.
• CSD_REPAIR_ESTIMATE_LINES — child detail lines; joined via REPAIR_ESTIMATE_ID.
• FND_SECURITY_GROUPS — security grouping referenced by SECURITY_GROUP_ID.
• CSD_REPAIR_ESTIMATE_PK / CSD_REPAIR_ESTIMATE_U1 — primary key constraint and unique index on REPAIR_ESTIMATE_ID.
• CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID — inbound foreign key documenting the parent-child relationship.