Search Results csd_reason




Overview
Explore in AI Chat

Overview

APPS.CSD_RO_GROUP_DETAILS_V is a reporting and integration view in Oracle E-Business Suite 12.1.1 and 12.2.2 that presents the line-level detail of repair orders as grouped within Repair Order Groups. The view joins repair line data held in CSD_REPAIRS with repair order group headers in CSD_REPAIR_ORDER_GROUPS, and enriches each row with descriptive and lookup-driven values. It is used primarily by Depot Repair, Service, and Field Service reporting, as well as by integrations and custom concurrent programs that require a denormalized, human-readable view of repair activity without traversing multiple base tables directly.

The view corresponds to the "csd_reason" search term through its exposure of the CSD_REASON lookup. Each repair line carries a status_reason_code, and the view resolves that code to a translatable meaning column (reason_code_meaning) by joining to FND_LOOKUPS on lookup_type = 'CSD_REASON'. This allows reports to display the reason a repair line carries a given status without additional lookup joins by the caller.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following objects:

  • CSD_REPAIRS (synonym, aliased dra) — the driving table holding repair line records.
  • CSD_REPAIR_ORDER_GROUPS (synonym, aliased crog) — the repair order group header joined on repair_group_id.
  • CSD_REPAIR_TYPES_VL (view, aliased crtv) — supplies repair type name and reference, joined on repair_type_id.
  • FND_LOOKUPS (view, aliased fndl1, fndl2, fndl3) — resolves the lookup codes for approval status (CSD_APPROVAL_STATUS), repair status (CSD_REPAIR_STATUS), and the reason code (CSD_REASON).
  • MTL_SYSTEM_ITEMS_VL (view, aliased items) — provides the concatenated product segment and product description.
  • MTL_UNITS_OF_MEASURE_VL (view, aliased uom) — resolves the unit of measure description.
  • CS_STD (package) — invoked via cs_std.get_item_valdn_orgzn_id to constrain the item validation organization.
  • FND_GLOBAL (package) — referenced indirectly for session context, consistent with standard EBS views.

The view links repair lines to their group through repair_group_id, and to the group's repair type through the group header. Lookup joins to CSD_APPROVAL_STATUS and CSD_REASON are outer joins; the join to CSD_REPAIR_STATUS is inner, so only lines with a valid status code are returned.

Key Columns

  • repair_line_id, repair_number — identifiers of the repair line.
  • repair_group_id — the parent repair order group.
  • incident_id, instance_id — associated service request and installed base instance.
  • inventory_item_id, product, product_desc — the repaired item and its description.
  • quantity, unit_of_measure, unit_of_measure_tl — quantity and UOM details.
  • repair_type_id, repair_type, repair_type_ref — the type of repair.
  • approval_required_flag, approval_status, approval_status_meaning — approval workflow state.
  • status, status_meaning — the CSD_REPAIR_STATUS lookup meaning.
  • status_reason_code, reason_code_meaning — the CSD_REASON lookup code and its meaning; this is the column set relevant to the "csd_reason" search.
  • date_closed, promise_date, days_remaining — computed as trunc(promise_date) - trunc(sysdate).
  • attribute_category, attribute1–attribute15 — descriptive flexfield columns.
  • created_by, creation_date, last_updated_by, last_update_date, last_update_login, object_version_number — standard audit and concurrency columns.

Common Use Cases and Queries

Typical scenarios include reporting open repair lines with their status and reason, monitoring promise dates and aging, and extracting repair group detail for interfaces.

Sample query returning repair lines with the CSD_REASON meaning:

  • SELECT repair_number, product, status_meaning, status_reason_code, reason_code_meaning, promise_date, days_remaining FROM apps.csd_ro_group_details_v WHERE reason_code_meaning IS NOT NULL;

Sample query for approval and aging analysis:

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

Because the view resolves lookup meanings and item descriptions internally, it simplifies reporting consumed by BI Publisher, Oracle Reports, and OAF-based pages that need a single, readable repair-line record.