View: CSD_RO_GROUP_MATERIALS_V

Product:	CSD - Depot Repair
Description:	View to summarize all the charges for a given repair ordergroup by MLE categories.
Implementation/DBA Data:	APPS.CSD_RO_GROUP_MATERIALS_V

View Text

SELECT CR.ROWID
, CROG.REPAIR_GROUP_ID
, CTBT.BILLING_TYPE
, MSI.CONCATENATED_SEGMENTS PRODUCT
, MSI.DESCRIPTION PRODUCT_DESC
, CR.UNIT_OF_MEASURE
, SUM(CED.AFTER_WARRANTY_COST) TOTAL_CHARGE
, SUM(CED.QUANTITY_REQUIRED) TOTAL_QUANTITY
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CSD_REPAIRS CR
, CSD_REPAIR_ESTIMATE CRE
, CSD_REPAIR_ESTIMATE_LINES CREL
, CS_TXN_BILLING_TYPES CTBT
, CS_ESTIMATE_DETAILS CED
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE CROG.REPAIR_GROUP_ID = CR.REPAIR_GROUP_ID
AND CR.REPAIR_LINE_ID = CRE.REPAIR_LINE_ID
AND CRE.REPAIR_ESTIMATE_ID = CREL.REPAIR_ESTIMATE_ID
AND CED.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CTBT.TXN_BILLING_TYPE_ID = CED.TXN_BILLING_TYPE_ID
AND CREL.ESTIMATE_DETAIL_ID = CED.ESTIMATE_DETAIL_ID GROUP BY CR.ROWID
, CROG.REPAIR_GROUP_ID
, CTBT.BILLING_TYPE
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, CR.UNIT_OF_MEASURE

Columns