USP_SIMPLEDATALIST_POSTTOGLPROCESSBUSINESSPROCESS

CREATE procedure dbo.USP_SIMPLEDATALIST_POSTTOGLPROCESSBUSINESSPROCESS
(
  @BUSINESSPROCESSCATALOGID uniqueidentifier
) 
as                
    begin                    
        set nocount on

        select 
            ID as VALUE, CAPTION as LABEL 
        from 
            dbo.BUSINESSPROCESSVIEW 
        where 
            BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
        and QUERYVIEWCATALOGID not in ('04858FF2-D0BB-4B1C-9DBC-EBD8B5A67B7A','e6ff3b8d-c9e4-4fe7-9d54-e62a1bf4c4c4','0c30e5de-6b0e-43df-b988-5a45d3b3cd30','2a21dde9-f7c9-4dc9-9b8e-c449ccf33d86','add6036d-9b56-48cf-bdd2-1f48f74edd0a','44853ed6-6f1b-4cac-a38a-e00196b1d0c2')

        union 

        select 
            ID as VALUE, CAPTION as LABEL 
        from 
            dbo.BUSINESSPROCESSVIEW 
        where 
            BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
            and 
            (
                (
                    QUERYVIEWCATALOGID in ('04858FF2-D0BB-4B1C-9DBC-EBD8B5A67B7A','e6ff3b8d-c9e4-4fe7-9d54-e62a1bf4c4c4','0c30e5de-6b0e-43df-b988-5a45d3b3cd30','2a21dde9-f7c9-4dc9-9b8e-c449ccf33d86','add6036d-9b56-48cf-bdd2-1f48f74edd0a','44853ed6-6f1b-4cac-a38a-e00196b1d0c2')
                    and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0E85C527-E6E9-4C5F-A8E8-105FD0E18FE7') = 1
                    and dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('Multicurrency') = 0
                )
                or -- If multicurrency is on, do not show the two financial edge formats.

                (
                    QUERYVIEWCATALOGID in ('2a21dde9-f7c9-4dc9-9b8e-c449ccf33d86')
                    and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0E85C527-E6E9-4C5F-A8E8-105FD0E18FE7') = 1
                    and dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('Multicurrency') = 1
                )            
            )
        order by 
            CAPTION

    end