Results for “csd_repair_estimate_v”

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

Overview

CSD_REPAIR_ESTIMATE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the CSD – Depot Repair product. It carries a VALID status and is documented for both 12.1.1 and 12.2.2 environments. The view fetches the estimate header for repair orders, joining repair line records to their associated estimate and incident details. Its principal role is to present a denormalized, read-only projection that supports depot repair estimate inquiries, reporting, and integration extracts without requiring consumers to reconstruct the relationship between repair lines, estimate headers, and service incidents.

The view is particularly relevant to users searching for "not_to_exceed," which is exposed directly as the NOT_TO_EXCEED column. This column corresponds to the estimate amount ceiling authorized for a repair order, a control used during approval and billing review to prevent charges from exceeding the customer-authorized limit.

Underlying Base Objects

The documented base objects referenced by the view are CSD_REPAIRS (SYNONYM), CSD_REPAIR_ESTIMATE (SYNONYM), and CS_INCIDENTS_B_SEC (VIEW). CSD_REPAIRS supplies the repair order header and line context, including repair number, repair mode, repair type, approval flags, and status. CSD_REPAIR_ESTIMATE supplies the estimate header attributes, such as estimate date, estimate status, work summary, lead time, freeze flag, reason code, purchase order number, and the not-to-exceed amount. CS_INCIDENTS_B_SEC is the secure incidents view that provides the incident number associated with the repair record.

The view definition joins CSD_REPAIRS (CR) to CSD_REPAIR_ESTIMATE (CRE) on REPAIR_LINE_ID, and to CS_INCIDENTS_B_SEC (CIA) on INCIDENT_ID. Because it references these base synonyms and a security-based incidents view, access to rows is influenced by the underlying security model applied to incidents.

Key Columns

• ROW_ID – the ROWID of the estimate record, useful for row identification in certain operations.
• REPAIR_LINE_ID – the repair line identifier, the primary join key to the repair order.
• REPAIR_NUMBER – the human-readable depot repair order number.
• REPAIR_ESTIMATE_ID – unique identifier of the estimate header.
• ESTIMATE_DATE, ESTIMATE_STATUS, ESTIMATE_FREEZE_FLAG, ESTIMATE_REASON_CODE – estimate lifecycle attributes, including whether the estimate is frozen and the reason recorded for it.
• REPAIR_MODE, REPAIR_TYPE_ID, REPAIR_QUANTITY, STATUS, APPROVAL_REQUIRED_FLAG, APPROVAL_STATUS – repair order context and approval state.
• INCIDENT_ID, INCIDENT_NUMBER – the associated service incident.
• WORK_SUMMARY, LEAD_TIME, LEAD_TIME_UOM – descriptive and scheduling information for the estimate.
• PO_NUMBER – purchase order reference linked to the estimate.
• NOT_TO_EXCEED – the authorized estimate ceiling amount, central to approval and billing control.
• ROUTING_SEQUENCE_ID, OBJECT_VERSION_NUMBER – routing reference and optimistic locking version.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – descriptive flexfield context and standard audit columns.

Common Use Cases and Queries

The view is commonly used to list estimates for open repair orders, to review approval status and authorized ceilings, and to extract estimate data into reporting or integration layers. A typical query retrieving not-to-exceed amounts and approval status for active repairs follows:

SELECT repair_number, repair_estimate_id, estimate_status, approval_status, not_to_exceed, po_number FROM csd_repair_estimate_v WHERE estimate_status = 'APPROVED' ORDER BY estimate_date DESC;

Another frequent pattern filters estimates whose revision or freeze status must be reviewed before billing, for example returning work_summary, lead_time, and estimate_reason_code for a specific repair_number. Because the view joins the secure incidents object, users should expect incident security to constrain visible rows.