Search Results days_remaining

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:

• CSD_REPAIR_ORDER_GROUPS (synonym) — supplies the group identifier REPAIR_GROUP_ID and joins to CSD_REPAIRS on REPAIR_GROUP_ID and to CSD_REPAIR_TYPES_VL on REPAIR_TYPE_ID.
• CSD_REPAIRS (synonym, aliased DRA) — the primary repair line source, providing repair number, incident, inventory item, quantity, resource, repair type, approval, status, close date, promise date, and attribute columns.
• CSD_REPAIR_TYPES_VL (view) — yields the repair type NAME and REPAIR_TYPE_REF.
• FND_LOOKUPS (view) — outer-joined three times to resolve CSD_APPROVAL_STATUS, CSD_REPAIR_STATUS, and CSD_REASON codes to meanings.
• MTL_SYSTEM_ITEMS_VL (view) — provides concatenated segments and description for the inventory item.
• MTL_UNITS_OF_MEASURE_VL (view) — supplies the UOM name for the line's unit of measure.
• CS_STD (package) — resolves the item validation organization via CS_STD.GET_ITEM_VALDN_ORGZN_ID.

Key Columns

• REPAIR_LINE_ID, REPAIR_NUMBER — unique repair line identifier and display number.
• REPAIR_GROUP_ID — grouping key linking lines to a repair order group.
• REPAIR_TYPE_ID, REPAIR_TYPE, REPAIR_TYPE_REF — repair type key, name, and the reference value central to the searched term.
• PRODUCT, PRODUCT_DESC — concatenated item segments and item description.
• UNIT_OF_MEASURE, UNIT_OF_MEASURE_TL — UOM code and translated name.
• QUANTITY, RESOURCE_ID, INSTANCE_ID — line quantity and associated resource/instance identifiers.
• APPROVAL_REQUIRED_FLAG, APPROVAL_STATUS, APPROVAL_STATUS_MEANING — approval workflow state.
• STATUS, STATUS_MEANING, STATUS_REASON_CODE, REASON_CODE_MEANING — repair line status and reason descriptions.
• DATE_CLOSED, PROMISE_DATE, DAYS_REMAINING — closure and promise tracking; DAYS_REMAINING is TRUNC(PROMISE_DATE) − TRUNC(SYSDATE).
• ATTRIBUTE1..15, ATTRIBUTE_CATEGORY, OBJECT_VERSION_NUMBER, ROWID — descriptive flexfield values, concurrency control, and row identity.

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.