burdan yararlanarak yapabilirsin
select
CASE WHEN ORF.TRCODE=1 THEN 'Satış/Pazarlama Siparişleri'
WHEN ORF.TRCODE=2 THEN 'Alış/Satınalma Siparişleri'ELSE 'Diğer' END AS 'SİPARİŞ TÜRÜ',
ORF.DATE_ as 'SİPARİŞ TARİHİ',
ORF.FICHENO as 'SİPARİŞ NO',
ORF.DOCODE AS 'BELGE NO',
C.CODE AS 'CARI KODU',
C.DEFINITION_ AS 'CARİ ADI',
I.CODE as 'MALZEME STOK KODU',
I.NAME as 'MALZEME STOK ADI',
ORL.AMOUNT as 'SİPARİŞ MİKTARI',
ORL.SHIPPEDAMOUNT as 'SEVKEDİLEN MİKTAR',
ORL.AMOUNT - ORL.SHIPPEDAMOUNT as 'KALAN/BEKLEYEN MİKTAR',
BIRIM.CODE AS 'ANA BİRİM',
ORL.PRICE AS 'BRM.FIYATI_TL',
ORL.TOTAL AS 'TUTAR_TL',
ORL.DUEDATE AS 'TESLİM TARİHİ'
----ORF.LOGICALREF AS 'ORF.LOGICALREF',
----ORL.LOGICALREF AS 'ORL.LOGICALREF',
----I.LOGICALREF AS 'I.LOGICALREF',
----ORF.CLIENTREF AS 'ORF.CLIENTREF',
----ORL.STOCKREF AS 'ORL.STOCKREF',
----ORL.ORDFICHEREF AS 'ORL.ORDFICHEREF',
----ORF.PAYDEFREF AS 'ORF.PAYDEFREF',
----C.LOGICALREF AS 'C.LOGICALREF',
----BIRIM.UNITSETREF AS 'BIRIM.UNITSETREF',
----I.UNITSETREF AS 'I.UNITSETREF'
FROM
LG_043_ITEMS I
LEFT OUTER JOIN LG_043_01_ORFLINE ORL ON ORL.STOCKREF=I.LOGICALREF
LEFT OUTER JOIN LG_043_01_ORFICHE ORF ON ORF.LOGICALREF=ORL.ORDFICHEREF
LEFT OUTER JOIN LG_043_CLCARD C ON ORF.CLIENTREF=C.LOGICALREF
LEFT OUTER JOIN LG_043_PAYPLANS P ON P.LOGICALREF=ORF.PAYDEFREF
LEFT OUTER JOIN LG_043_UNITSETL AS BIRIM ON (BIRIM.UNITSETREF=I.UNITSETREF)
WHERE I.ACTIVE=0 AND ORF.CANCELLED=0 AND ORF.STATUS=4 AND
C.ACTIVE=0 AND ORL.TRCODE=2 AND ORL.CLOSED=0 AND ORL.AMOUNT - ORL.SHIPPEDAMOUNT>0 AND BIRIM.MAINUNIT=1 and I.CARDTYPE In (1,2,3,4,10,11,12,13,20,21)
ORDER BY ORF.DATE_,ORF.FICHENO,I.NAME
