CREATE VIEW dbo.FIRMA_SIPARISLERI_FIS_TOPLAMLARI
AS
SELECT        COMPANYREF, FICHEREF, SUM(TOPLAM) AS TPL
FROM            (SELECT        FIS.COMPANYREF, FIS.FICHEREF, FIS.AMOUNT * PRC.PRICE * (CASE WHEN PRC.CURRENCY = 13 THEN 1 WHEN FIS.REPORTRATE IS NOT NULL AND FIS.REPORTRATE <> 1 AND 
                                                    FIS.REPORTRATE <> 0 THEN FIS.REPORTRATE WHEN FSS.REPORTRATE <> 0 THEN FSS.REPORTRATE ELSE
                                                        (SELECT        TOP (1) RATES1
                                                          FROM            [IHR].[dbo].[EXCHANGE]
                                                          ORDER BY REF DESC) END) AS TOPLAM
                          FROM            dbo.FICHE_LINES AS FIS LEFT OUTER JOIN
                                                    dbo.FICHES AS FSS ON FSS.REF = FIS.FICHEREF LEFT OUTER JOIN
                                                    dbo.PRCLIST AS PRC ON PRC.REF = FIS.PRICEREF
                          WHERE        (FIS.STATUS <> 2)) AS QQ
GROUP BY COMPANYREF, FICHEREF