cust_CCIW_funct_luid_to_value

USE [ArenaDB]
GO

/****** Object:  UserDefinedFunction [dbo].[cust_CCIW_funct_luid_to_value]    Script Date: 2/17/2022 2:16:28 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO







CREATE       function [dbo].[cust_CCIW_funct_luid_to_value](@LUID int)
    RETURNS varchar(50)

AS

BEGIN

    DECLARE @LValue varchar(50)

    SET @LValue = (SELECT lookup_value
                FROM core_lookup
                WHERE lookup_id = @LUID and organization_id = 1)
    RETURN @LValue
END




GO