Düzenle: STOK_RAPOR_SIPARIS_VERILDI

İ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.STOK_RAPOR_SIPARIS_VERILDI
AS
SELECT STOCKREF, USERID, SUM(CAST(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(AMOUNT, '?', ''), 'BEKLEMEDE', ''), 'ARIZALI', ''), 'YANLIS', ''), 'ÜRÜN DOGRU', ''), 'KONTROL EDILECEK', ''), 
                  'ÜRETIM HATASI', ''), 'UYUMSUZ', ''), 'dikkat', '') AS int)) AS AMOUNT, TYPE_
FROM     dbo.STOK_RAPOR_SIPARISLER
WHERE  (DEL_ = 0) AND (ORDERDATE IS NOT NULL) AND (ORDERDATE <> '') AND (STOCKREF IS NOT NULL) AND (STOCKREF <> 0) AND (STOCKREF NOT IN
                      (SELECT LOGICALREF
                       FROM      dbo.LG_011_ITEMS
                       WHERE   (ACTIVE = 1))) AND (STOCKREF IN
                      (SELECT CARDREF
                       FROM      dbo.LG_011_PRCLIST
                       WHERE   (PTYPE = 2))) AND (STOCKREF NOT IN
                      (SELECT CARDREF
                       FROM      dbo.LG_011_PRCLIST AS LG_011_PRCLIST_1
                       WHERE   (ACTIVE = 1))) AND (TYPE_ <> 2)
GROUP BY STOCKREF, USERID, TYPE_

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

İptal Nesneyi Sil