CREATE  PROC SP_LISTE_FIYAT_KULLANIM_DISI(@KOD VARCHAR(100)) AS
BEGIN 
DECLARE @LOGREF INT 
SET @LOGREF = (SELECT LOGICALREF FROM LG_011_ITEMS WHERE CODE=@KOD)
UPDATE LG_011_ITEMS
SET ACTIVE = 1
WHERE LOGICALREF=@LOGREF
UPDATE LG_011_PRCLIST
SET ACTIVE = 1
WHERE CARDREF=@LOGREF AND PTYPE = 2
END