Search Results status_reason_code




Overview
Explore in AI Chat

Overview

CSD_RO_GROUP_DETAILS_V is an APPS-owned database view within the CSD (Depot Repair) product module of Oracle E-Business Suite, valid in 12.1.1 and 12.2.2. The view consolidates repair line details belonging to a repair order group, joining depot repair transactions with item, unit-of-measure, repair type, and lookup reference data. It is primarily used for reporting, group-level inquiry screens, and downstream integrations that require a denormalized, human-readable projection of repair group content. Because it exposes translated descriptions (product description, UOM name, status meaning) and a derived days-remaining calculation, the view is well suited to operational dashboards and interface extraction rather than transactional DML. The object supports queries for the field commonly searched as repair_type_ref through its REPAIR_TYPE_REF column.

Underlying Base Objects

The view is defined over the following documented objects:

Key Columns

Common Use Cases and Queries

Typical scenarios include group-level repair status reporting, aging and promise-date analysis, and interface extraction filtering by repair type reference.

List repair lines for a group by repair type reference:

SELECT repair_number, product, repair_type, repair_type_ref, status_meaning, days_remaining FROM apps.csd_ro_group_details_v WHERE repair_group_id = :p_group_id AND repair_type_ref = :p_repair_type_ref;

Approval and aging report:

SELECT repair_group_id, repair_number, approval_status_meaning, promise_date, days_remaining FROM apps.csd_ro_group_details_v WHERE approval_required_flag = 'Y' AND days_remaining < 0 ORDER BY days_remaining;

Repair type distribution across groups:

SELECT repair_type_ref, repair_type, COUNT(*) line_count, SUM(quantity) total_qty FROM apps.csd_ro_group_details_v GROUP BY repair_type_ref, repair_type ORDER BY 3 DESC;

Because the view joins translated and lookup tables, callers should constrain by REPAIR_GROUP_ID or REPAIR_TYPE_REF to keep result sets efficient, and must not attempt DML against the view.