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