SELECT A.FBILL_SL,G.SALE_TYPE_DESC,A.FBILL_DATE,A.GROSS_AMOUNT, 
(SELECT INIT_AMT FROM SALES.SALES_FBILL_SALECHARGE_DTLS
WHERE FBILL_NO = A.FBILL_NO
AND COMP_CODE = A.COMP_CODE
AND PAY_CHARGE_CODE = 17) CESS,
(SELECT INIT_AMT FROM SALES.SALES_FBILL_SALECHARGE_DTLS
WHERE FBILL_NO = A.FBILL_NO
AND COMP_CODE = A.COMP_CODE
AND PAY_CHARGE_CODE = 18) EDU_CESS,
(SELECT INIT_AMT FROM SALES.SALES_FBILL_SALECHARGE_DTLS
WHERE FBILL_NO = A.FBILL_NO
AND COMP_CODE = A.COMP_CODE
AND PAY_CHARGE_CODE = 46) S_H_EDU_CESS,
A.NET_AMOUNT,a.buyer_code,C.BUYER_NAME,
--A.FBILL_NO,B.BROKER_NAME,
D.QTY_CODE,F.QTY_DESC,D.PRODUCT_CODE,MREL.FUNC_PRODUCT_DESPATCHDESC(D.PRODUCT_CODE,1) P_DESC, D.GROSS_WT,D.NET_WT,
(SELECT decode(X.rate_type,'R','Rate/Metric Ton','P','Price of Bag','B','Basis Price','M','Rate/100 Meter')
 FROM SALES.SALES_SALEADV_QUALITY X,SALES.SALES_DESPATCH_ADVICE_MASTER Y
WHERE X.SALE_ADV_NO = Y.MILL_ORDER_NO
AND X.COMP_CODE = Y.COMP_CODE
AND Y.DESPATCH_CODE = E.DESPATCH_CODE
AND Y.COMP_CODE = E.COMP_CODE
AND X.QTY_CODE = D.QTY_CODE
AND X.PRODUCT_CODE = D.PRODUCT_CODE) RATE_TYPE,
(SELECT RATE
 FROM SALES.SALES_SALEADV_QUALITY X,SALES.SALES_DESPATCH_ADVICE_MASTER Y
WHERE X.SALE_ADV_NO = Y.MILL_ORDER_NO
AND X.COMP_CODE = Y.COMP_CODE
AND Y.DESPATCH_CODE = E.DESPATCH_CODE
AND Y.COMP_CODE = E.COMP_CODE
AND X.QTY_CODE = D.QTY_CODE
AND X.PRODUCT_CODE = D.PRODUCT_CODE) RATE,
E.INV_DATE DESPATCH_DATE,
SALES.FUNC_RR_DATE(A.FBILL_NO,A.COMP_CODE) RR_DATE,
DECODE(INSTR(MREL.FUNC_PRODUCT_NEWDESC(D.PRODUCT_CODE,1,'Q'),'BAG WT.-',1,1),0,NULL,SUBSTR(MREL.FUNC_PRODUCT_NEWDESC(D.PRODUCT_CODE,1,'Q'),INSTR(MREL.FUNC_PRODUCT_NEWDESC(D.PRODUCT_CODE,1,'Q'),'WT.-',1,1)+4)) BAG_WT,
(SELECT X.SALE_NO FROM SALES.SALES_SALEADV_MASTER X,SALES.SALES_DESPATCH_ADVICE_MASTER Y
WHERE X.SALE_ADV_NO = Y.MILL_ORDER_NO
AND X.COMP_CODE = Y.COMP_CODE
AND Y.DESPATCH_CODE = E.DESPATCH_CODE
AND Y.COMP_CODE = E.COMP_CODE) SALE_NO,
(SELECT X.SALE_DATE FROM SALES.SALES_SALEADV_MASTER X,SALES.SALES_DESPATCH_ADVICE_MASTER Y
WHERE X.SALE_ADV_NO = Y.MILL_ORDER_NO
AND X.COMP_CODE = Y.COMP_CODE
AND Y.DESPATCH_CODE = E.DESPATCH_CODE
AND Y.COMP_CODE = E.COMP_CODE) SALE_DATE
FROM SALES.SALES_FINAL_BILL_MASTER A,MREL.MREL_SALES_BROKER_MAST B,
MREL.MREL_SALES_BUYER_MAST C,sales.sales_final_bill_quality d,SALES.SALES_EXCISE_INV_MASTER E,
MREL.MREL_QUALITY_MAST F,SALES.SALES_SALE_TYPE_MASTER G
WHERE A.COMP_CODE =:COMP_CODE
AND A.BROKER_CODE = B.BROKER_CODE
AND A.BUYER_CODE = C.BUYER_CODE
AND A.FBILL_NO = D.FBILL_NO
AND A.COMP_CODE = D.COMP_CODE
AND D.INV_CODE = E.INV_CODE
AND D.COMP_CODE = E.COMP_CODE
AND D.QTY_CODE = F.QTY_CODE
AND A.SALE_TYPE_CODE = G.SALE_TYPE_CODE
AND A.FBILL_DATE BETWEEN :STDT AND :ENDT
ORDER BY 1,2;