USP_SIMPLEDATALIST_LETTERCODE_ASSIGNLETTERCODEPROCESS

Returns a list of revenue letters along with revenue letters linked to an assign letter code process.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@ASSIGNLETTERCODEPROCESSID	uniqueidentifier	IN

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_LETTERCODE_ASSIGNLETTERCODEPROCESS
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null,
                    @ASSIGNLETTERCODEPROCESSID uniqueidentifier
                )
                as
                    set nocount on;


                    select 
                        LETTERCODE.ID as VALUE,
                        LETTERCODE.NAME as LABEL
                    from
                        dbo.LETTERCODE
                    left join 
                        dbo.LETTERCODESITE on LETTERCODE.ID = LETTERCODESITE.LETTERCODEID
                    where
                        ISACTIVE = 1
                        and IDSETREGISTERID is not null
                        and ISSYSTEM = 0
                        and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[LETTERCODESITE].[SITEID] or (SITEID is null and [LETTERCODESITE].[SITEID] is null)))

                    union

                    select
                        LETTERCODE.ID as VALUE,
                        LETTERCODE.NAME as LABEL
                    from dbo.UFN_ASSIGNLETTERCODESPROCESS_GETLETTERCODES(@ASSIGNLETTERCODEPROCESSID) LETTERCODES
                    inner join LETTERCODE on LETTERCODES.LETTERCODEID = LETTERCODE.ID
                    where
                        ISACTIVE = 1
                        and IDSETREGISTERID is not null
                        and ISSYSTEM = 0
                    order by
                        NAME;