Search Results csd_repairs_v




Overview
Explore in AI Chat

Overview

CSD_REPAIRS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the CSD (Depot Repair) product family. As its ETRM description states, the view is used "for getting repair orders," and it serves as the primary consolidated reporting interface for Depot Repair order headers and their most frequently referenced descriptive attributes. Because the view joins the transactional repair line table (CSD_REPAIRS) to a wide set of lookup, reference, and master-data objects, consumers can retrieve a fully denormalized picture of a repair order without reconstructing the dozens of foreign-key relationships themselves.

The view is present and VALID in both the 12.1.1 and 12.2.2 releases. Its role is primarily reporting, inquiry, and integration: it is commonly queried by custom concurrent programs, OBIEE/BI Publisher reports, and external integration layers that need repair order status, customer, item, contract, and project context in a single result set. It is not intended as a DML target; updates to repair orders must be performed against the base CSD_REPAIRS table or through the Depot Repair application APIs.

Underlying Base Objects

The view text performs an outer-driven SELECT based on CSD_REPAIRS (aliased DRA), the core Depot Repair line/order table, joined with SR (CS_INCIDENTS_B_SEC / service request data) for incident and customer context. The documented referenced base objects include:

Key Columns

Common Use Cases and Queries

A typical query retrieves open repair orders for an operating unit with customer and item detail:

  • SELECT repair_number, incident_number, customer_id, concatenated_segments, quantity, status FROM csd_repairs_v WHERE org_id = :p_org_id AND date_closed IS NULL;
  • Tracking WIP versus shipped quantities: SELECT repair_number, quantity, quantity_in_wip, quantity_shipped FROM csd_repairs_v WHERE quantity_shipped < quantity;
  • Joining to installed base context for serialized items: SELECT repair_number, instance_number, serial_number, lot_number FROM csd_repairs_v WHERE customer_product_id IS NOT NULL;

Because the view applies project security through the PA_* packages, results are automatically filtered by the user's project security profile. Reporting queries should always qualify by ORG_ID, and performance-sensitive extracts should filter on REPAIR_NUMBER or CREATION_DATE rather than scanning full attribute sets.