Düzenle: WEBAPI_BYI340214

İ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.WEBAPI_BYI340214
AS
SELECT        ITM.LOGICALREF AS Ref, ITM.CODE AS SicilKodu, dbo.RepOzel(dbo.InitCap({ fn CONCAT({ fn CONCAT({ fn CONCAT(ITM.SPECODE2, ' ') }, dbo.RepLhRh(ITM.NAME)) }, dbo.RepLhRh(ITM.NAME3)) })) AS SicilAdi, 
                         CASE WHEN KR.LOGICALREF IS NULL THEN { fn CONCAT({ fn CONCAT('https://universaloto.com/foto/photos/', dbo.formatNumber(ITM.LOGICALREF)) }, '.jpg') } ELSE '' END AS Resim, 
                         CASE WHEN (GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED) > 10 THEN 10 ELSE ISNULL((GNT.ONHAND - GNT.TEMPIN - GNT.RESERVED), 0) END AS StokAdeti, ITM.GTIPCODE AS Kategori, ITM.SPECODE4 AS Marka, 
                         ISNULL(MAM.KAT1, '') AS Model, TLF.TL AS ListeFiyati, dbo.AracModelleri(ITM.SPECODE2) AS Brand, ITM.SPECODE2 AS Arac, ISNULL(MAM.KAT1, '') AS Kategori1, ISNULL(MAM.KAT2, '') AS Kategori2, ISNULL(MAM.KAT3, '') 
                         AS Kategori3, ISNULL(MAM.KAT4, '') AS Kategori4, ISNULL(MAM.KAT5, '') AS Kategori5, ISNULL(MAM.KAT6, '') AS Kategori6, ISNULL(MAM.KAT7, '') AS Kategori7, ISNULL(MAM.KAT8, '') AS Kategori8, ISNULL(MAM.KAT9, '') 
                         AS Kategori9, ISNULL(MAM.KAT10, '') AS Kategori10, ISNULL(MAM.KAT11, '') AS Kategori11, ISNULL(MAM.KAT12, '') AS Kategori12, ISNULL(MAM.KAT13, '') AS Kategori13, ISNULL(ITM.UNIVID, '') AS Kategori14, 
                         ITM.STGRPCODE AS UrunTipi
FROM            dbo.LG_011_ITEMS AS ITM LEFT OUTER JOIN
                         dbo.LV_011_08_GNTOTST AS GNT ON GNT.STOCKREF = ITM.LOGICALREF AND GNT.INVENNO = - 1 LEFT OUTER JOIN
                         dbo.UNI_TL_FIYAT AS TLF ON TLF.CARDREF = ITM.LOGICALREF LEFT OUTER JOIN
                         dbo.MALZEME_ARAC_MODELLERI AS MAM ON MAM.LOGREF = ITM.LOGICALREF LEFT OUTER JOIN
                         dbo.KirikResimler AS KR ON KR.LOGICALREF = ITM.LOGICALREF
WHERE        (ITM.ACTIVE = 0) AND (TLF.TL IS NOT NULL) AND (ITM.STGRPCODE IN ('DEPO', 'DÜGME', 'FAN', 'FAR', 'GÜNESLIK', 'GÖGÜS', 'IZALATÖR', 'KARTER', 'KILIT', 'KONTAK', 'KÖRÜK', 'KRIKO', 'LAMBA', 'MANIFOLD', 'MOTOR', 
                         'MUHAFAZA', 'PANJUR', 'SINYAL', 'SIS', 'STOP', 'SAMANDIRA', 'TOPUZ', 'TRAVERS', 'AYNA'))

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

İptal Nesneyi Sil