CREATE PROCEDURE SP_URUN_KONTROL
    @ProductCode VARCHAR(50)
AS
BEGIN
    SELECT 
        CASE 
            WHEN ITM.ACTIVE = 0 AND PRC.ACTIVE = 0 THEN 'VAR'
            ELSE 'YOK'
        END AS DURUM
    FROM 
        LG_011_ITEMS AS ITM
    LEFT JOIN 
        LG_011_PRCLIST AS PRC 
        ON PRC.CARDREF = ITM.LOGICALREF
    WHERE 
        ITM.CODE = @ProductCode
END