← Detay Sayfası
Nesne Düzenle
|
PLASIYER_TSI_LISTESI
İlgili Uygulama
-- Seçiniz --
SQL Server
Nesne Türü
View
Stored Procedure
Trigger
Job
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.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
Oluşturulma: 23.12.2025 07:15
Son Güncelleme: 24.12.2025 11:02
İptal
Nesneyi Sil
Değişiklikleri Kaydet