SELECT
F.DATE_,F.TRCODE,F.FICHENO FISNO,F.SPECODE OZELKOD,F.GENEXP1 ACK1,F.GENEXP2 ACK2,F.JOURNALNO YEVMIYENO,F.TOTALACTIVE BORCTOPLAM,F.TOTALPASSIVE ALACAKTOPLAM,F.CANCELLED IPTAL,L.TRNET SATIRNET,L.MONTH_ AY,L.YEAR_ YIL,
(SELECT CODE FROM LG_010_EMUHACC WHERE LOGICALREF=D.ACCOUNTREF) MUHASEBEKOD,
(SELECT DEFINITION_ FROM LG_010_EMCENTER WHERE LOGICALREF=D.CENTERREF) MASRAF,
(SELECT NAME FROM LG_010_PROJECT WHERE LOGICALREF=D.PROJECTREF) PROJE,
D.DISTRATE ORAN,D.CREDEBNET TUTAR,D.TRNET NETTUTAR
FROM
LG_010_01_EMFLINE L,LG_010_01_EMFICHE F,LG_010_01_ACCDISTDETLN D
WHERE
L.ACCFICHEREF=F.LOGICALREF
AND D.ACCFICHEREF=F.LOGICALREF AND D.ACCOUNTREF=L.ACCOUNTREF AND D.DATE_=L.DATE_ AND D.PREVLINEREF=L.LINENO_