Results for “csd_ro_group_materials_v”

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

Overview

CSD_RO_GROUP_MATERIALS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the Depot Repair (CSD) product family. Its documented purpose is to summarize all charges for a given repair order group, aggregated by MLE (Multi-Language Engine) categories. In practical terms, the view collapses the material and labor cost detail recorded against repair estimates and estimate lines into a per-product, per-billing-type rollup, expressing total estimated charges and total quantities for each repair group.

The view is read-only and is intended for inquiry, reporting, and integration rather than transactional processing. Because it joins repair order groups to repair lines, estimates, estimate lines, and estimate detail rows, it provides a denormalized snapshot that is convenient for dashboards, charge summaries, and interfaces that need to present grouped repair costs without traversing the full Depot Repair data model. The BILLING_TYPE column is central to this view and is the attribute most frequently used to classify how each summarized charge is to be recovered — for example, whether it is billable to a customer, covered under warranty, or otherwise categorized by the billing type setup in Oracle Service.

Underlying Base Objects

The view is defined over the following documented base objects, all referenced through APPS synonyms:

• CSD_REPAIR_ORDER_GROUPS — the repair group header; supplies REPAIR_GROUP_ID.
• CSD_REPAIRS — individual repair lines linked to the group; supplies the row identifier (ROWID) and unit of measure.
• CSD_REPAIR_ESTIMATE — the estimate header associated with each repair line.
• CSD_REPAIR_ESTIMATE_LINES — estimate lines that tie to estimate details.
• CS_ESTIMATE_DETAILS — the detail charge rows; source of AFTER_WARRANTY_COST, QUANTITY_REQUIRED, INVENTORY_ITEM_ID, and TXN_BILLING_TYPE_ID.
• CS_TXN_BILLING_TYPES — resolves the billing type identifier to the descriptive BILLING_TYPE value.
• MTL_SYSTEM_ITEMS_KFV — the key flexfield item view supplying product concatenated segments and description; it is constrained by the package function CS_STD.GET_ITEM_VALDN_ORGZN_ID.
• CS_STD — the Service package whose function returns the item validation organization, ensuring items are resolved within the correct inventory organization.

The joins follow the chain repair group → repair line → estimate → estimate line → estimate detail, with the billing type and item master resolved as lookups. The result set is aggregated with GROUP BY over the row identifier, repair group, billing type, product segments, product description, and unit of measure.

Key Columns

• ROW_ID — the row identifier of the CSD_REPAIRS row, useful for drilling back to the repair line.
• REPAIR_GROUP_ID — identifier of the repair order group being summarized; the primary grouping key.
• BILLING_TYPE — the billing classification resolved from CS_TXN_BILLING_TYPES, indicating how the summarized charge is billed or recovered. This is the attribute most commonly used to filter or pivot charge summaries.
• PRODUCT — the concatenated key flexfield segments of the inventory item, providing the human-readable product identifier.
• PRODUCT_DESC — the item description from MTL_SYSTEM_ITEMS_KFV.
• UNIT_OF_MEASURE — the unit of measure recorded on the repair line.
• TOTAL_CHARGE — sum of AFTER_WARRANTY_COST across estimate details for the group, billing type, and product combination.
• TOTAL_QUANTITY — sum of QUANTITY_REQUIRED across the same grouping.

Common Use Cases and Queries

The view is typically queried to produce grouped cost summaries for a repair order group, to analyze charge distribution by billing type, or to feed downstream billing and reporting processes. A typical query listing all summarized charges for a specific group is:

• SELECT billing_type, product, product_desc, unit_of_measure, total_quantity, total_charge FROM csd_ro_group_materials_v WHERE repair_group_id = :p_group_id ORDER BY billing_type, product;

To analyze charges broken down by billing type across all groups:

• SELECT billing_type, SUM(total_charge) total_charge, SUM(total_quantity) total_quantity FROM csd_ro_group_materials_v GROUP BY billing_type ORDER BY billing_type;

To isolate billable material for a given product:

• SELECT repair_group_id, billing_type, total_charge FROM csd_ro_group_materials_v WHERE product = :p_product AND billing_type = :p_billing_type;

Because the view resolves the item through CS_STD.GET_ITEM_VALDN_ORGZN_ID, users should be aware that product rows are limited to the item validation organization; items not validated in that organization will not appear. The view exposes no date or status columns, so time-based or workflow-based filtering must be performed against the underlying base tables rather than this summary view.