Search Results csd_repairs_non_sec_v




Overview
Explore in AI Chat

Overview

CSD_REPAIRS_NON_SEC_V is an APPS-owned database view in the Oracle E-Business Suite Depot Repair (CSD) module. As its name indicates, the view presents depot repair order data without applying Service Security. Its documented purpose is "the view for getting repair orders. It is without Service Security." This distinguishes it from security-enabled repair views that filter rows based on the operating unit, service organization, or user responsibility context using FND_PROFILE and PA_SECURITY logic.

Because the view omits Service Security predicates, it returns repair order lines across organizations and customers visible to the querying session at the database level, rather than restricting them by the Service Security profile. It therefore serves reporting, data extraction, and integration scenarios where a trusted or administrative session must access the complete repair population, or where security filtering is applied downstream by the consuming application. In Oracle EBS 12.1.1 and 12.2.2, the view remains a read-only construct owned by APPS and is commonly referenced by concurrent programs, custom reports, and interface extracts.

Underlying Base Objects

The view is defined over a substantial set of base objects. The documented referenced objects in the ETRM 12.2.2 metadata include:

The view text joins these objects using DECODE and NVL constructs to reconcile data between the customer product instance and the repair line where no instance exists.

Key Columns

Notable columns exposed by CSD_REPAIRS_NON_SEC_V include:

Note that the view metadata does not list a REWORK_CODE column; users searching for rework_code should verify whether it is exposed through a descriptive flexfield attribute (for example ATTRIBUTE columns) or an alternate repair view.

Common Use Cases and Queries

Typical usage includes open repair order reporting, aging analysis, and interface extraction. A representative query follows:

  • Extract open repairs with customer and item detail:
    SELECT REPAIR_NUMBER, INCIDENT_NUMBER, CUSTOMER_ID, CONCATENATED_SEGMENTS, SERIAL_NUMBER, STATUS, PROMISE_DATE FROM CSD_REPAIRS_NON_SEC_V WHERE STATUS NOT IN ('CLOSED','CANCELLED');
  • Repair volume by repair type:
    SELECT NAME, COUNT(*) FROM CSD_REPAIRS_NON_SEC_V GROUP BY NAME;
  • Quantity reconciliation of received versus shipped units:
    SELECT REPAIR_NUMBER, QUANTITY, QUANTITY_RCVD, QUANTITY_SHIPPED FROM CSD_REPAIRS_NON_SEC_V WHERE QUANTITY_RCVD <> QUANTITY_SHIPPED;

Because Service Security is not enforced, consumers must apply their own organizational or responsibility filtering when the query is exposed to non-administrative users.