SELECT C.PRODUCT_DESC||' (PACKING - '||A.PACK_COMPT_VALUE||')' QUALITY, A.QTY_UNIT, SUM(A.QTY) QTY, SUM(A.QTY_KG) QTY_KG, SUM(A.NOMINAL_WEIGHT) NOMINAL_WEIGHT, SUM(A.CONT_WEIGHT) CONT_WEIGHT
FROM SALES.SALES_STOCK_DTLS A, SALES.SALES_STOCK_MAST B, MREL.MREL_PRODUCT_MASTER C
WHERE A.STOCK_TRANS_NO = B.STOCK_TRANS_NO
AND A.PRODUCT_CODE = C.PRODUCT_CODE
AND B.COMP_CODE LIKE DECODE(:COMP_CODE, 4, '%', :COMP_CODE)
AND B.TRANS_TYPE IN(SELECT STK_TRANS_CODE FROM SALES.SALES_STOCK_TRANS_TYPE WHERE STK_REC_ISS = 'R')
GROUP BY C.PRODUCT_DESC, A.PACK_COMPT_VALUE, A.QTY_UNIT