PLASIYER_TSI_LISTESI

Genel Bilgiler

Uygulama SQL Server

Nesne Türü View

Dönem Hassasiyeti ⚠️ Devirde Güncellenmeli

Oluşturulma 23.12.2025 07:15

Son Güncelleme 23.12.2025 16:10

Notlar

Düzenle

Henüz not eklenmemiş.

+ Not ekle

İstatistikler

Kod Analizi

Satır

Kullandığı

Kullanan

→ Kullandığı Nesneler (1)

📄 CLFLINE

REFERENCES

← Kullanan Nesneler (6)

👁️ CARI_DURUM_TSI

USES_VIEW

👁️ PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI

USES_VIEW

👁️ PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEB

USES_VIEW

👁️ PLASIYER_TSI_SIRALI

USES_VIEW

👁️ PLASIYER_TSI_TAHSILAT_TUR_TOPLAMLARI

USES_VIEW

⚡ SP_PLASIYER_TSI_AYLARA_GORE_KALEM_TOPLAM_TABLOSU

USES_VIEW

→ Bağımlılık Ağacı

📄CLFLINEREFERENCES

← Etki Ağacı

👁️PLASIYER_TSI_SIRALIUSES_VIEW
- ⚡SP_PLASIYER_TSI_AYLARA_GORE_KALEM_TOPLAM_TABLOSUUSES_VIEW
👁️PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARIUSES_VIEW
- 👁️PLAS_LIST_TSIUSES_VIEW
👁️CARI_DURUM_TSIUSES_VIEW
- 👁️PLAS_LIST_TSIUSES_VIEW
- 👁️PLAS_LIST_TSI_WEBUSES_VIEW
👁️PLASIYER_TSI_TAHSILAT_TUR_TOPLAMLARIUSES_VIEW
👁️PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI_WEBUSES_VIEW
- 👁️PLAS_LIST_TSI_WEBUSES_VIEW
⚡SP_PLASIYER_TSI_AYLARA_GORE_KALEM_TOPLAM_TABLOSUUSES_VIEW

Tam SQL Kodu

Düzenle

CREATE VIEW dbo.PLASIYER_TSI_LISTESI
AS
SELECT   *
FROM         ((SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, 
                                                      CAST(CLF.DATE_ AS DATE) AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 1 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, 
                                                      CLF.SALESMANREF AS PLAS, CLF.CLIENTREF, CC.SPECODE2
                            FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                      LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                      LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                            WHERE     CLF.TRCODE IN (1, 20, 61, 62, 70) AND CLF.CANCELLED = 0)
                         UNION ALL
                         (SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, 
                                                    CAST(CLF.DATE_ AS DATE) AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 2 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, 
                                                    CLF.SALESMANREF AS PLAS, CLF.CLIENTREF, CC.SPECODE2
                          FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                    LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                    LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                          WHERE     CLF.TRCODE IN (38) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 3 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (33) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 1 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (1, 20, 61, 62, 70) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 2 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (38) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 3 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (33) AND CLF.CANCELLED = 0)) AS CCLF

Devir Edilmiş Kod

011_08 → 011_09 (1 değişiklik)

ALTER VIEW dbo.PLASIYER_TSI_LISTESI
AS
SELECT   *
FROM         ((SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, 
                                                      CAST(CLF.DATE_ AS DATE) AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 1 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, 
                                                      CLF.SALESMANREF AS PLAS, CLF.CLIENTREF, CC.SPECODE2
                            FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                      LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                      LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                            WHERE     CLF.TRCODE IN (1, 20, 61, 62, 70) AND CLF.CANCELLED = 0)
                         UNION ALL
                         (SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, 
                                                    CAST(CLF.DATE_ AS DATE) AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 2 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, 
                                                    CLF.SALESMANREF AS PLAS, CLF.CLIENTREF, CC.SPECODE2
                          FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                    LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                    LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                          WHERE     CLF.TRCODE IN (38) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 3 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (33) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 1 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_09_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (1, 20, 61, 62, 70)
                         UNION ALL
                         (SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, 
                                                      CAST(CLF.DATE_ AS DATE) AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 1 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, 
                                                      CLF.SALESMANREF AS PLAS, CLF.CLIENTREF, CC.SPECODE2
                            FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                      LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                      LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                            WHERE     CLF.TRCODE IN (1, 20, 61, 62, 70) AND CLF.CANCELLED = 0)
                         UNION ALL
                         (SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, 
                                                    CAST(CLF.DATE_ AS DATE) AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 2 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, 
                                                    CLF.SALESMANREF AS PLAS, CLF.CLIENTREF, CC.SPECODE2
                          FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                                                    LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                                                    LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
                          WHERE     CLF.TRCODE IN (38) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 3 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_07_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (33) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 1 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (1, 20, 61, 62, 70) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 2 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (38) AND CLF.CANCELLED = 0)
UNION ALL
(SELECT   REPLACE(SLS.DEFINITION_, ' WEB', '') AS PDEF2, SLS.CODE AS PCODE, SLS.DEFINITION_ AS PDEF, CC.CODE, CC.DEFINITION_, CC.CITY, CLF.TRCODE, CAST(CLF.DATE_ AS DATE) 
                           AS TARIH, dbo.fn_trcode('Clfline', CLF.TRCODE, '', '') AS [ISLEM], CLF.TRNET, 3 AS TUR, YEAR(CLF.DATE_) AS YIL, MONTH(CLF.DATE_) AS AY, CLF.SALESMANREF AS PLAS, 
                           CLF.CLIENTREF, CC.SPECODE2
 FROM         LG_011_08_CLFLINE AS CLF LEFT OUTER JOIN
                           LG_011_CLCARD AS CC ON CC.LOGICALREF = CLF.CLIENTREF LEFT OUTER JOIN
                           LG_SLSMAN AS SLS ON SLS.LOGICALREF = CLF.SALESMANREF
 WHERE     CLF.TRCODE IN (33) AND CLF.CANCELLED = 0)) AS CCLF

Kodun Çalışma Mantığı (Adım Adım)

Analiz Ekle/Düzenle

Henüz bu nesne için bir analiz girilmemiş.

İlk Analizi Ekle