(SELECT
                                     X.DESPATCH_CODE,
                                     DESPATCH_QUANTITY,
                                     DESPATCH_QUANTITY_UNIT,
                                     CASE WHEN X.qty_code in (37,38) OR X.DESPATCH_QUANTITY_UNIT = 'MT' THEN
                                         NVL((SELECT SUM(NVL(NET_WT,0))
                                            FROM
                                              SALES.SALES_EXCISE_INV_QUALITY
                                         WHERE
                                              COMP_CODE =:COMP_CODE
                                         AND 
                                              DESPATCH_CODE = X.DESPATCH_CODE
                                         GROUP BY
                                              DESPATCH_CODE),0)
                                     ELSE
                                         NVL((SELECT SUM(NVL(DESPATCH_QUANTITY,0))
                                            FROM
                                              SALES.SALES_EXCISE_INV_QUALITY
                                         WHERE
                                              COMP_CODE =:COMP_CODE
                                         AND 
                                              DESPATCH_CODE = X.DESPATCH_CODE
                                         GROUP BY
                                              DESPATCH_CODE),0)
                                     END DLV_QUANTITY,                                                                          
                                     NVL(X.DESPATCH_QUANTITY,0)
                                      - 
                                     CASE WHEN X.qty_code in (37,38) OR X.DESPATCH_QUANTITY_UNIT = 'MT' THEN
                                         NVL((SELECT SUM(NVL(NET_WT,0))
                                            FROM
                                              SALES.SALES_EXCISE_INV_QUALITY
                                         WHERE
                                              COMP_CODE =:COMP_CODE
                                         AND 
                                              DESPATCH_CODE = X.DESPATCH_CODE
                                         GROUP BY
                                              DESPATCH_CODE),0)
                                     ELSE
                                         NVL((SELECT SUM(NVL(DESPATCH_QUANTITY,0))
                                            FROM
                                              SALES.SALES_EXCISE_INV_QUALITY
                                         WHERE
                                              COMP_CODE =:COMP_CODE
                                         AND 
                                              DESPATCH_CODE = X.DESPATCH_CODE
                                         GROUP BY
                                              DESPATCH_CODE),0)
                                     END INV_QUANTITY
                                FROM
                                          SALES.SALES_DESPATCH_ADVICE_QUALITY X
                                     WHERE
                                          X.TOTAL_QUANTITY > 0
                                     AND
                                      NVL(X.DESPATCH_QUANTITY,0)
                                      - 
                                     CASE WHEN X.qty_code in (37,38) OR X.DESPATCH_QUANTITY_UNIT = 'MT' THEN
                                           NVL((SELECT SUM(NVL(NET_WT,0))
                                            FROM
                                              SALES.SALES_EXCISE_INV_QUALITY
                                            WHERE
                                              COMP_CODE =:COMP_CODE
                                         AND 
                                              DESPATCH_CODE = X.DESPATCH_CODE
                                         GROUP BY
                                              DESPATCH_CODE),0)
                                     ELSE
                                         NVL((SELECT SUM(NVL(DESPATCH_QUANTITY,0))
                                            FROM
                                              SALES.SALES_EXCISE_INV_QUALITY
                                         WHERE
                                              COMP_CODE =:COMP_CODE
                                         AND 
                                              DESPATCH_CODE = X.DESPATCH_CODE
                                         GROUP BY
                                              DESPATCH_CODE),0)
                                     END > 0
                                     AND
                                          X.COMP_CODE =:COMP_CODE 
                                 )