Birim Çevrimli Rapor

SELECT CODE,NAME,UNITSETREF,

(SELECT CODE FROM LG_058_UNITSETF WHERE LOGICALREF=ITM.UNITSETREF) AS BIRIMSETKODU,
(SELECT NAME FROM LG_058_UNITSETF WHERE LOGICALREF=ITM.UNITSETREF) AS BIRIMSETADI,
(SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=1) ANABIRIM,
(SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=2) [2.BIRIM],
(SELECT CONVFACT1 FROM LG_058_ITMUNITA WHERE ITEMREF=ITM.LOGICALREF AND UNITLINEREF=(SELECT LOGICALREF FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=2)) [2.BIRIM KATSAYI],
(SELECT CODE FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=3) [3.BIRIM],
(SELECT CONVFACT1 FROM LG_058_ITMUNITA WHERE ITEMREF=ITM.LOGICALREF AND UNITLINEREF=(SELECT LOGICALREF FROM LG_058_UNITSETL WHERE UNITSETREF=ITM.UNITSETREF AND LINENR=3)) [3.BIRIM KATSAYI]
FROM LG_058_ITEMS ITM WHERE ITM.LOGICALREF IN
(select STOCKREF FROM LG_058_01_ORFLINE WHERE ORDFICHEREF=3)

——————–
SELECT T.CONVFACT1,F.AMOUNT FROM LG_058_ITMUNITA T,LG_058_01_ORFLINE F
WHERE T.ITEMREF=F.STOCKREF AND T.LINENR=2 AND F.ORDFICHEREF=3