Düzenle: 00001_SON_ALIM_LISTESI

İlgili Uygulama

Nesne Türü

Nesne Adı

Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)

Genel Kullanım Amacı ve Notlar

Tam SQL Kodu

CREATE VIEW dbo.[00001_SON_ALIM_LISTESI]
AS
SELECT        STOCKREF, AMOUNT, DATE_, ROW_NUMBER() OVER (PARTITION BY STOCKREF
ORDER BY DATE_ DESC) AS [ORDER_], ROW_NUMBER() OVER (PARTITION BY STOCKREF
ORDER BY DATE_ ASC) AS [ORDER2_]
FROM            ((SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
                            FROM            LG_011_08_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                                                     LG_011_08_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
                            WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
                         UNION ALL
                         (SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
                          FROM            LG_011_07_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                                                   LG_011_07_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
                          WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_06_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_06_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_05_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_05_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_04_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_04_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_03_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_03_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_02_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_02_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)
UNION ALL
(SELECT        STL.STOCKREF, STL.AMOUNT, INV.DATE_
 FROM            LG_011_01_STLINE AS STL WITH (NOLOCK) LEFT OUTER JOIN
                          LG_011_01_STFICHE AS INV WITH (NOLOCK) ON INV.LOGICALREF = STL.STFICHEREF
 WHERE        STL.TRCODE = 1 AND STL.CANCELLED = 0 AND STL.LINETYPE = 0)) QQ

Oluşturulma: 23.12.2025 07:15 Son Güncelleme: 23.12.2025 17:28

İptal Nesneyi Sil