SELECT ALL 
             SALES_SALEADV_MASTER.SALE_NO, 
             SALES_SALEADV_MASTER.SALE_ADV_NO,
             SALES_SALEADV_MASTER.SALE_ADV_DATE, 
             MREL_SALES_BUYER_MAST.BUYER_NAME,
             NVL((SELECT SUM(NVL(AMOUNT,0)) FROM
             SALES.SALES_SALEADV_QUALITY 
             WHERE SALE_ADV_NO = SALES_SALEADV_MASTER.SALE_ADV_NO
             AND COMP_CODE = 3 ),0) SAMOUNT, 
             SUM(SALES_SALEADV_QUALITY.AMOUNT),
             NVL((SELECT SUM(NVL(B.AMOUNT,0)) FROM
             SALES.SALES_EXPORT_INVOICE_QUALITY B,SALES.SALES_EXPORT_INVOICE_MASTER A
             WHERE B.MILL_ORDER_NO = SALES_SALEADV_MASTER.SALE_ADV_NO
             AND B.COMP_CODE = 3
             AND A.DESPATCH_CODE = B.DESPATCH_CODE
             AND A.COMP_CODE = B.COMP_CODE
             AND A.FINAL_INVOICE_AMT> 0 ),0) DAMOUNT,
             NVL((SELECT SUM(NVL(AMOUNT,0)) FROM
             SALES.SALES_SALEADV_QUALITY 
             WHERE SALE_ADV_NO = SALES_SALEADV_MASTER.SALE_ADV_NO
             AND COMP_CODE = 3 ),0) - 
             NVL((SELECT SUM(NVL(B.AMOUNT,0)) FROM
             SALES.SALES_EXPORT_INVOICE_QUALITY B,SALES.SALES_EXPORT_INVOICE_MASTER A
             WHERE B.MILL_ORDER_NO = SALES_SALEADV_MASTER.SALE_ADV_NO
             AND B.COMP_CODE = 3
             AND A.DESPATCH_CODE = B.DESPATCH_CODE
             AND A.COMP_CODE = B.COMP_CODE
             AND A.FINAL_INVOICE_AMT> 0 ),0)  AS AMOUNT, 
             MREL_CURRENCY_MASTER.CUR_ABBR, 
             SALES_PAYMENT_TERMS_MAST.PTERMS_DESC, 
             SALES_SALEADV_QUALITY.DELIVERY_BY
FROM MREL.MREL_SALES_BUYER_MAST, MREL.MREL_CURRENCY_MASTER, SALES.SALES_SALEADV_QUALITY, 
SALES.SALES_SALEADV_MASTER, SALES.SALES_PAYMENT_TERMS_MAST
WHERE (
          (SALES.SALES_SALEADV_QUALITY.SALE_ADV_NO = SALES.SALES_SALEADV_MASTER.SALE_ADV_NO)
 AND (SALES.SALES_SALEADV_QUALITY.COMP_CODE = SALES.SALES_SALEADV_MASTER.COMP_CODE)
 AND (SALES.SALES_SALEADV_MASTER.SALE_STATUS <> 'C')
 AND (SALES.SALES_SALEADV_MASTER.BUYER_CODE = MREL_SALES_BUYER_MAST.BUYER_CODE)
 AND (SALES.SALES_PAYMENT_TERMS_MAST.PTERMS_SL = SALES.SALES_SALEADV_MASTER.PTERMS_SL)
 AND (SALES.SALES_SALEADV_MASTER.CURR_CODE = MREL_CURRENCY_MASTER.CURR_CODE)
 AND SALES.SALES_SALEADV_MASTER.COMP_CODE = 3
 AND SALES.SALES_SALEADV_MASTER.SALE_TYPE_CODE = 3 
AND SALES_SALEADV_QUALITY.SALE_QUANTITY - 
NVL((SELECT SUM(NVL(B.DESPATCH_QUANTITY,0)) FROM
             SALES.SALES_EXPORT_INVOICE_QUALITY B,SALES.SALES_EXPORT_INVOICE_MASTER A
             WHERE B.MILL_ORDER_NO = SALES.SALES_SALEADV_QUALITY.SALE_ADV_NO
             AND B.QTY_CODE = SALES.SALES_SALEADV_QUALITY.QTY_CODE
             AND B.PRODUCT_CODE = SALES.SALES_SALEADV_QUALITY.PRODUCT_CODE
             AND B.COMP_CODE = SALES.SALES_SALEADV_QUALITY.COMP_CODE
             AND B.COMP_CODE = SALES.SALES_SALEADV_MASTER.COMP_CODE
             AND A.DESPATCH_CODE = B.DESPATCH_CODE
             AND A.COMP_CODE = B.COMP_CODE
             AND A.FINAL_INVOICE_AMT> 0 ),0) >0)
GROUP BY              SALES_SALEADV_MASTER.SALE_NO,
             SALES_SALEADV_MASTER.SALE_ADV_NO, 
             SALES_SALEADV_MASTER.SALE_ADV_DATE, 
             MREL_SALES_BUYER_MAST.BUYER_NAME, 
             MREL_CURRENCY_MASTER.CUR_ABBR, 
             SALES_PAYMENT_TERMS_MAST.PTERMS_DESC, 
             SALES_SALEADV_QUALITY.DELIVERY_BY
ORDER BY 1