VIEW: APPS.CSD_RO_GROUP_MATERIALS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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