SELECT A.SALE_NO,D.SO_NO,D.SO_DT,B.SALE_QUANTITY,D.GOVT_BILL_NO,C.NET_AMOUNT FROM 
SALES.SALES_SALEADV_MASTER A,SALES_SALEADV_QUALITY B,SALES.SALES_FINAL_BILL_MASTER C,
SALES.SALES_FINAL_BILL_GOVT_INFO D
WHERE 
A.SALE_ADV_NO = B.SALE_ADV_NO
AND A.COMP_CODE = B.COMP_CODE
AND A.SALE_ADV_NO = C.MILL_ORDER_NO
AND A.COMP_CODE = C.COMP_CODE
AND C.FBILL_NO = D.FBILL_NO
AND C.COMP_CODE = D.COMP_CODE
AND A.SALE_TYPE_CODE = 4 
AND A.SALE_DATE >= '01-APR-09'
AND A.COMP_CODE = :CCODE
AND A.SALE_STATUS <> 'C'
ORDER BY 1