129: ciab.creation_date,
130: ced.currency_code,
131: sum(ced.after_warranty_cost) Total_Charges
132: FROM cs_incidents_all_b ciab,
133: cs_incident_types cit,
134: cs_estimate_details ced
135: WHERE ciab.incident_id = ced.incident_id
136: AND ciab.incident_type_id = cit.incident_type_id
137: AND ced.charge_line_type IN ('ACTUAL','IN_PROGRESS')