SELECT E.COMP_SHORT_DESC,C.BROKER_NAME,D.BUYER_NAME,
(SELECT Y.SALE_TYPE_DESC FROM SALES.SALES_SALEADV_MASTER X,SALES.SALES_SALE_TYPE_MASTER Y 
WHERE X.SALE_ADV_NO = A.MILL_ORDER_NO AND X.COMP_CODE = A.COMP_CODE AND X.SALE_TYPE_CODE=Y.SALE_TYPE_CODE) SALE_TYPE, 
A.FBILL_SL,
--A.FBILL_NO,
A.FBILL_DATE,
--A.BROKER_CODE,
A.GROSS_AMOUNT,
--B.BROKERAGE,
ROUND((A.GROSS_AMOUNT*B.BROKERAGE)/100,2) BROK_AMT,
--A.COMP_CODE,
(SELECT SALE_NO FROM SALES.SALES_SALEADV_MASTER WHERE SALE_ADV_NO = A.MILL_ORDER_NO AND COMP_CODE = A.COMP_CODE) SALE_NO 
FROM
SALES.SALES_FINAL_BILL_MASTER A,SALES.SALES_SALEADV_MASTER B,MREL.MREL_SALES_BROKER_MAST C,MREL.MREL_SALES_BUYER_MAST D,
MREL.MREL_COMPANY_MAST E 
WHERE A.BROKER_CODE LIKE DECODE(:BCODE,'ALL','%',:BCODE)
AND A.FBILL_DATE>= '01-APR-09'
AND A.MILL_ORDER_NO = B.SALE_ADV_NO
AND A.COMP_CODE = B.COMP_CODE
AND A.BROKER_CODE = C.BROKER_CODE
AND A.BUYER_CODE = D.BUYER_CODE
AND A.COMP_CODE = E.COMP_CODE
AND B.BROKERAGE_ALLOWED <> 'Y'
AND A.SALE_TYPE_CODE IN (1,2)
AND A.BROKER_CODE <> 16
--AND A.STAX_SL <> 38
AND A.FBILL_DATE BETWEEN :STDT AND :ENDT
ORDER BY A.COMP_CODE,C.BROKER_NAME,A.FBILL_SL