CREATE VIEW dbo.SIPARIS_SATIRLARI_AKTIF
AS
SELECT        FCH.FICHENO, FCH.DATE_, ORS.DURUM, FLN.AMOUNT, ITM.CODE, ISNULL(ITT.CODE, '') AS CODE2, CASE WHEN ITT.[NAME] IS NULL THEN ITM.ITEMNAME ELSE ITT.[NAME] END AS ITEMNAME, ITM.ITEMNAME_EN, 
                         CASE WHEN ITT.STGRPCODE IS NULL THEN ITM.GROUPCODE ELSE ITT.STGRPCODE END AS GROUPCODE, PRD.PRODUCERCODE, CMP.DEFINITION_, FLN.LINEEXP1, FLN.LINEEXP2, PRC.PRICE, 
                         CASE WHEN PRC.CURRENCY = 1 THEN 'USD' WHEN PRC.CURRENCY = 13 THEN 'CNY' WHEN PRC.CURRENCY = 20 THEN 'EUR' WHEN PRC.CURRENCY = 160 THEN 'TL' ELSE 'USD' END AS CURRENCY, PRC.IHRSAT, 
                         CASE WHEN PRC.IHRCURRENCY = 1 THEN 'USD' WHEN PRC.IHRCURRENCY = 13 THEN 'CNY' WHEN PRC.IHRCURRENCY = 20 THEN 'EUR' WHEN PRC.IHRCURRENCY = 160 THEN 'TL' ELSE 'USD' END AS IHRCURRENCY, 
                         FLN.REF, ITM.BCOLOR
FROM            dbo.FICHE_LINES AS FLN LEFT OUTER JOIN
                         dbo.FICHES AS FCH ON FCH.REF = FLN.FICHEREF LEFT OUTER JOIN
                         dbo.COMPANIES AS CMP ON CMP.REF = FLN.COMPANYREF LEFT OUTER JOIN
                         dbo.ORDER_STATUS AS ORS ON ORS.REF = FLN.STATUS LEFT OUTER JOIN
                         dbo.ITEMS AS ITM ON ITM.REF = FLN.ITEMREF LEFT OUTER JOIN
                         UNIVERSALDB.dbo.LG_011_ITEMS AS ITT ON ITM.LOGICALREF = ITT.LOGICALREF LEFT OUTER JOIN
                         dbo.PRODUCERCODES AS PRD ON PRD.REF = FLN.PRODREF LEFT OUTER JOIN
                         dbo.PRCLIST AS PRC ON PRC.REF = FLN.PRICEREF
						 WHERE FCH.[STATUS] NOT IN (3)