CREATE PROC dbo.STOK_BITEN_KARA_LISTE_SIL
AS
BEGIN
DECLARE @LOGREF INT
DECLARE @TOPLAM INT
DECLARE @SAYAC INT
DECLARE @MIKTAR INT
SET @SAYAC = 1
SET @TOPLAM = ISNULL((SELECT COUNT(*) FROM dbo.KARA_LISTE_SIRALI), 0)
WHILE @SAYAC <= @TOPLAM
BEGIN
SET @MIKTAR = ISNULL((SELECT ONHAND FROM dbo.KARA_LISTE_SIRALI WHERE SIRA=@SAYAC), 0)
IF @MIKTAR <= 0
BEGIN
SET @LOGREF = ISNULL((SELECT LOGICALREF FROM dbo.KARA_LISTE_SIRALI WHERE SIRA=@SAYAC), 0)
UPDATE LG_011_ITEMS SET ACTIVE=1 WHERE LOGICALREF=@LOGREF
UPDATE LG_011_PRCLIST SET ACTIVE=1 WHERE PTYPE=2 AND CARDREF=@LOGREF
END
SET @SAYAC = @SAYAC + 1
END
END