oracle 取视图字段,在oracle视图，取相同字段值的和

在oracle中写了一个试图，我想加一个字段，取得是相同RD.SKU行的QTYGOOD的和

CREATE OR REPLACE VIEW aaa AS

SELECT

R.WHSEID,

RD.STORERKEY,

RD.SKU,

CASE

WHEN  LOC.LOCATIONCATEGORY <> 'NG'  AND   RD.CONDITIONCODE = 'OK'

THEN   RD.QTYRECEIVED

ELSE  0

END   QTYGOOD

FROM RECEIPT R

LEFT JOIN RECEIPTDETAIL RD ON R.RECEIPTKEY = RD.RECEIPTKEY

LEFT JOIN RECEIPTDETAIL RD1 ON RD1.RECEIPTKEY = SUBSTR(RD.LOTTABLE03,1,10)

AND  RD1.RECEIPTLINENUMBER  =  SUBSTR(RD.LOTTABLE03,11,5)

LEFT JOIN SKU SKU ON SKU.STORERKEY = RD.STORERKEY

AND   SKU.SKU   =  RD.SKU

LEFT JOIN STORER S ON S.STORERKEY = RD.STORERKEY

AND   S.TYPE='1'

LEFT JOIN STORER S1 ON S1.STORERKEY = RD.LOTTABLE06

AND     S1.TYPE='1'

LEFT JOIN CODELKUP C ON C.CODE = R.TYPE

AND   C.LISTNAME='RECEIPTYPE'

LEFT JOIN CODELKUP C1 ON C1.CODE = RD.LOTTABLE11

AND   C1.LISTNAME='ISOCOUNTRY'

LEFT JOIN CODELKUP C2 ON C2.CODE = R.CUSTOMWAY

AND   C2.LISTNAME='CUSTOMWAY'

LEFT JOIN LOC LOC ON LOC.LOC = RD.TOLOC

LEFT JOIN ALTSKU A ON A.STORERKEY = RD.STORERKEY AND A.SKU = RD.SKU

AND A.VENDOR = RD.LOTTABLE06  AND A.ALTSKU = RD.LOTTABLE07

AND A.UDF7 = RD.LOTTABLE08 AND A.UDF8 = RD.LOTTABLE09

WHERE R.STATUS= ’11’ AND RD.QTYRECEIVED > 0