选择列表中的表达式无效（不包含在聚合函数或GROUP BY子句中）

[qq_39753204]

今天应客户需求我在sql中加了一个SUM（）但不知道为什么就不能执行了，求各位前辈指点一下，代码如下：
select POR.CO_ID,POR.MANU_NO,POR.MANU_DATE,POR.IN_END_DATE,POR.ID, POB.BOM_ID, PBB.BAG_NAME, CU.CUS_SHORT_NAME,CU.BTEAM_ID,
PIM.ITEM_NO, PIM.ITEM_NAME, PIM.ITEM_SPEC,PIM.ITEM_UNIT,PIM.ITEM_UNIT_WGT,ROUND(SUM(PIL.QTY),3)AA,
IT.ITEM_NO AS IT_ITEM_NO, IT.ITEM_NAME AS IT_ITEM_NAME, IT.ITEM_SPEC AS IT_ITEM_SPEC,
POB.LINE_NO,POB.BOM_ID,POB.IS_MAINCOM,
PBM.MATERIAL, PBM.MATERIAL_NAME,
PCS.COST_TYPE,PCS.ITEM_COST_SCRIPT,
PCS.QTY,PCS.TOTAL_WEIGHT,PCS.LENGTH_M,PCS.WASTE_RATE,
IIF ((PCS.TOTAL_WEIGHT IS NULL) OR(PCS.TOTAL_WEIGHT=0),PCS.QTY,PCS.TOTAL_WEIGHT)QQ,
PCS.WASTE_QTY, PCS.WEIGHT, PCS.WASTE_TOTAL_WEIGHT, PCS.WASTE_LENGTH_M,
PCS.MATERIEL_FROM, PCS.LINE_NO,PCS.BOM_ID,PCS.DETAIL_ID,PCS.REMARK,
(PCS.LENGTH_M + PCS.WASTE_LENGTH_M)A_LENGTH_M,
(case PCS.MATERIEL_FROM
when 1 then '原配料'
when 2 then '替代料'
when 3 then '其它'
end) FROM_NEME,
(case PCS.READY_KIND
when 1 then '库存'
when 2 then '采购'
when 3 then '分切'
when 4 then '自制'
end)READY_KIND,
(case when (UN.UNIT_TYPE in (1,3,4,7)) then (PCS.QTY + PCS.WASTE_QTY)
when (UN.UNIT_TYPE = 2) then PCS.TOTAL_WEIGHT
end)A_UN_QTY,
((case when (UN.UNIT_TYPE in (1,3,4,7)) then (PCS.QTY + PCS.WASTE_QTY)
when (UN.UNIT_TYPE = 2) then PCS.TOTAL_WEIGHT
end) - (select sum(QTY) from PB_INV_ALLOT_DTL where PRD_NOTE_NO = POR.MANU_NO and ITEM_ID =POB.ITEM_ID))PO_UN_QTY,

(case when PCS.TOTAL_WEIGHT >0 then PCS.TOTAL_WEIGHT else (PCS.QTY + PCS.WASTE_QTY) end )A_QTY,
(select sum(QTY) from PB_INV_ALLOT_DTL where PRD_NOTE_NO = POR.MANU_NO and ITEM_ID =POB.ITEM_ID)FP_QTY,
((case when PCS.TOTAL_WEIGHT >0 then PCS.TOTAL_WEIGHT else (PCS.QTY + PCS.WASTE_QTY) end )-(select sum(QTY) from PB_INV_ALLOT_DTL where PRD_NOTE_NO = POR.MANU_NO and ITEM_ID =POB.ITEM_ID))PO_QTY

from PB_PRD_ORDER POR
LEFT JOIN PB_PRD_ORDER_COST_MATERIALS PCS ON (PCS.ID = POR.ID)and (PCS.COST_TYPE= 1)
left join PB_PRD_ORDER_ITEM_BOM POB on (POB.BOM_ID = PCS.BOM_ID)
left join PB_ITEM_MASTER PIM on (PCS.MATERIEL_ID = PIM.ITEM_ID) and ((PIM.P_M = 1)or(PIM.P_M = 3))
left join PB_BASIC_UNIT UN ON (UN.UNIT_ID = PIM.ITEM_UNIT)
left join PB_BASIC_BAG PBB on (POB.COM_BAG_ID = PBB.ID)
left join PB_BASIC_MAT_FORMULA PMF on (PIM.FORMULA_ID = PMF.ID)
left join PB_BASIC_MAT PBM on (PMF.MAT_ID = PBM.ID)
left join PB_SALE_ORDER_DTL PSOD on (PSOD.DETAIL_ID = POR.SO_DETAIL_ID)
left join PB_SALE_ORDER S on (S.ID = PSOD.ID)
left join PB_CMN_CUSTOMER CU on (CU.CUS_ID = S.CUS_ID)
left join PB_ITEM_MASTER IT on (PSOD.ITEM_ID = IT.ITEM_ID) and ((IT.P_M = 2)or(IT.P_M = 3))
left join PB_INV_PICKING_LIST_DTL PIL ON (PIL.PRD_MTRL_DETAIL_ID=PCS.DETAIL_ID)

[楓VS痕]

报什么错误？

[qq_39753204]

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).
令牌无效。
动态SQL错误。
SQL错误代码= -104。
选择列表中的表达式无效（不包含在聚合函数或GROUP BY子句中）。