USP_RECEIPTINGPROCESS_GETPARAMETERS

            CREATE procedure dbo.USP_RECEIPTINGPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier = null
            )
            as
                set nocount on;

                declare @DEFAULTRECEIPTSTACKID uniqueidentifier
                set @DEFAULTRECEIPTSTACKID = dbo.UFN_RECEIPTSTACKINFO_GETDEFAULTRECEIPTSTACKID()

                select 
                    RECEIPTINGPROCESS.NAME, 
                    IDSETREGISTERID, 
                    CREATEOUTPUTIDSET, 
                    OUTPUTIDSETRECORDTYPEID, 
                    OUTPUTIDSETNAME, 
                    OVERWRITEOUTPUTIDSET, 
                    BUSINESSPROCESSVIEWID,
                    MARKRECEIPTED,
                    RECEIPTDATETYPECODE,
                    RECEIPTDATE,
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFINCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'INCLUSION',
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'EXCLUSION',
                    BUSINESSPROCESSCOMMPREF.DATETYPECODE,
                    BUSINESSPROCESSCOMMPREF.ASOFDATE,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEDECEASED,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEINACTIVE,
                    RECEIPTINGPROCESS.CUSTOMPARAMETERDATAFORMITEM,
                    RECEIPTINGPROCESS.RECEIPTTYPECODE,
                    RECEIPTINGPROCESS.EXPORTDEFINITIONID,
                    RECEIPTSTACKINFO.ID as RECEIPTSTACKID,
                    RECEIPTSTACKINFO.SHORTNAME as RECEIPTSTACKSHORTNAME,
                    RERECEIPTSAMENUMBER,
                    RERECEIPTNEWNUMBER,
                    DUPLICATENUMBERACTIONCODE,
                    STARTINGNUMBERCREATESGAPACTIONCODE
                from 
                    dbo.RECEIPTINGPROCESS 
                    left outer join dbo.BUSINESSPROCESSCOMMPREF on RECEIPTINGPROCESS.id=BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                    inner join dbo.RECEIPTSTACKINFO on coalesce(RECEIPTINGPROCESS.RECEIPTSTACKINFOID,  @DEFAULTRECEIPTSTACKID) = RECEIPTSTACKINFO.ID
                where 
                    RECEIPTINGPROCESS.ID = @ID;