Results for “csd_repair_order_groups_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.CSD_REPAIR_ORDER_GROUPS_V view is a Depot Repair (CSD) reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes repair order group records associated with service requests. A repair order group represents a logical collection of repair orders that share a common service request, repair type, and inventory item context, allowing depot repair operations to be managed and reported at the group level rather than line-by-line. The view is defined in the APPS schema and is marked VALID in the ETRM repository.

For users searching on group_approval_status, the view is significant because it is one of the documented exposures of the GROUP_APPROVAL_STATUS column. This column carries the approval state of the repair order group and is central to workflows that gate downstream processing — receipt, submission, completion, release, and shipment — on approval outcomes. The view also computes derived quantities, including REJECTED_QUANTITY, via a call to CSD_PROCESS_UTIL.GET_GROUP_REJECTED_QUANTITY, making it suitable for dashboards, operational reports, and integration extracts that must reflect both approval status and disposition quantities.

Underlying Base Objects

The documented view text joins the following base objects:

• CSD_REPAIR_ORDER_GROUPS (accessed via synonym CROG) — the driving table holding the repair group header, quantities, approval status, WIP entity reference, and descriptive flexfield attributes.
• CS_INCIDENTS_ALL_B (SR) — supplies the service request incident number, customer, and operating unit (ORG_ID).
• CSD_REPAIR_TYPES_VL (CRTV) — supplies the repair type name and reference.
• MTL_SYSTEM_ITEMS_VL (ITEMS) — supplies the product description and concatenated segments; joined using CS_STD.GET_ITEM_VALDN_ORGZN_ID to resolve the item validation organization.
• MTL_UNITS_OF_MEASURE_VL (UOM) — supplies the unit of measure description.
• CSD_PROCESS_UTIL — a package function returning the rejected quantity for a given REPAIR_GROUP_ID.
• CS_STD and FND_GLOBAL — utility packages referenced for item validation organization and session context.

The joins are inner joins keyed on INCIDENT_ID, REPAIR_TYPE_ID, INVENTORY_ITEM_ID, and UOM_CODE, so a repair order group will not appear in the view unless its related service request, repair type, item, and unit of measure rows are all resolvable.

Key Columns

• REPAIR_GROUP_ID — primary identifier of the repair order group; used as the input to the rejected-quantity function.
• REPAIR_GROUP_NUMBER — user-facing group reference.
• INCIDENT_ID / INCIDENT_NUMBER / CUSTOMER_ID / ORG_ID — service request and operating unit context.
• PRODUCT, PRODUCT_DESC, INVENTORY_ITEM_ID, UNIT_OF_MEASURE — item and UOM attributes.
• REPAIR_TYPE_ID / REPAIR_TYPE / REPAIR_TYPE_REF — repair type classification.
• GROUP_APPROVAL_STATUS — the approval state of the group; the column most directly relevant to approval-oriented reporting.
• GROUP_QUANTITY, REPAIR_ORDER_QUANTITY, RMA_QUANTITY, RECEIVED_QUANTITY, APPROVED_QUANTITY, SUBMITTED_QUANTITY, COMPLETED_QUANTITY, RELEASED_QUANTITY, SHIPPED_QUANTITY, REJECTED_QUANTITY — lifecycle quantity metrics across the repair group.
• GROUP_TXN_STATUS, REPAIR_MODE, WIP_ENTITY_ID — processing status, repair mode, and work-in-process linkage.
• ATTRIBUTE1–ATTRIBUTE15, CONTEXT — descriptive flexfield columns for extensibility.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID — standard audit and concurrency columns.

Common Use Cases and Queries

Typical uses include monitoring approval bottlenecks, reconciling group quantities, and feeding external systems with group-level status. A representative query listing groups pending approval for a given operating unit:

• SELECT REPAIR_GROUP_NUMBER, INCIDENT_NUMBER, PRODUCT, REPAIR_TYPE, GROUP_APPROVAL_STATUS, GROUP_QUANTITY, APPROVED_QUANTITY, REJECTED_QUANTITY FROM CSD_REPAIR_ORDER_GROUPS_V WHERE GROUP_APPROVAL_STATUS = 'PENDING' AND ORG_ID = :p_org_id ORDER BY CREATION_DATE DESC;
• Aggregate reconciliation by repair type: SELECT REPAIR_TYPE, GROUP_APPROVAL_STATUS, COUNT(*) GROUPS, SUM(GROUP_QUANTITY) TOTAL_QTY FROM CSD_REPAIR_ORDER_GROUPS_V GROUP BY REPAIR_TYPE, GROUP_APPROVAL_STATUS;
• Incident drill-down: SELECT REPAIR_GROUP_NUMBER, PRODUCT_DESC, GROUP_TXN_STATUS, RECEIVED_QUANTITY, SHIPPED_QUANTITY FROM CSD_REPAIR_ORDER_GROUPS_V WHERE INCIDENT_NUMBER = :p_incident;

Because the view is a join of multiple base objects and invokes a PL/SQL function per row for REJECTED_QUANTITY, high-volume extractions should filter aggressively on ORG_ID, INCIDENT_ID, or approval status to limit function execution overhead.