CREATE VIEW dbo.MALZEME_SIPARIS_GECMISI_HEPSI
AS
SELECT        TOP (100) PERCENT FCL.ITEMREF, FCL.STATUS, FCL.AMOUNT AS MIKTAR, FCH.FICHENO, FCH.GENEXP, OST.DURUM, CPN.DEFINITION_ AS SCOMP, ITM.LOGICALREF, FCH.CREATE_DATE, 
                         ITM.LOGICALREF AS STOCKREF
FROM            dbo.FICHE_LINES AS FCL LEFT OUTER JOIN
                         dbo.FICHES AS FCH ON FCH.REF = FCL.FICHEREF LEFT OUTER JOIN
                         dbo.ORDER_STATUS AS OST ON OST.REF = FCL.STATUS LEFT OUTER JOIN
                         dbo.ITEMS AS ITM ON FCL.ITEMREF = ITM.REF LEFT OUTER JOIN
                         dbo.COMPANIES AS CPN ON FCL.COMPANYREF = CPN.REF
ORDER BY FCL.ITEMREF, FCH.CREATE_DATE