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