USP_DATALIST_AVAILABLEBATCHDESIGNSTOTALAMOUNT

Returns a list of all batch designs and their whether to display total amount.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_AVAILABLEBATCHDESIGNSTOTALAMOUNT(@CURRENTAPPUSERID uniqueidentifier)
as                
        select [BATCHTEMPLATE].[ID],
            case when len(BATCHTYPECATALOG.AMOUNTCOLUMN) > 0 then 1 else 0 end as DISPLAYAMOUNT
        from dbo.[BATCHTEMPLATE] inner join BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
        where dbo.UFN_SECURITY_APPUSER_GRANTED_BATCHPROCESSOR(@CURRENTAPPUSERID, BATCHTEMPLATE.ID) = 1
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
            (
                BATCHTYPECATALOG.SPECXML.query
                    (
                        'declare namespace common="bb_appfx_commontypes";
                        /*/common:InstalledProductList'
                    )
            )
        order by BATCHTEMPLATE.NAME;