USP_SIMPLEDATALIST_RECEIPTOUTPUTQUERYVIEW

Returns a list of receipt output business process views.
Parameters

Parameter	Parameter Type	Mode	Description
@RECEIPTTYPECODE	tinyint	IN
Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_RECEIPTOUTPUTQUERYVIEW
                (
                    @RECEIPTTYPECODE tinyint
                )
                as

                    set nocount on;

                    declare @RECEIPTTAG nvarchar(10);
                    declare @AGGREGATETAG nvarchar(20);
                    set @RECEIPTTAG = 'Receipts'
                    set @AGGREGATETAG = 'AggregateReceipts'

                    if @RECEIPTTYPECODE = 0 
                        select 
                            BUSINESSPROCESSVIEW.ID as VALUE, 
                            BUSINESSPROCESSVIEW.CAPTION as LABEL
                        from 
                            dbo.QUERYVIEWCATALOG 
                        inner join 
                            dbo.BUSINESSPROCESSVIEW on QUERYVIEWCATALOG.ID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                        where 
                            QUERYVIEWSPEC.value('declare namespace bbafx="bb_appfx_queryview";
                                                declare namespace c="bb_appfx_commontypes";
                                                (bbafx:QueryViewSpec/c:MetaTags/attribute::*[local-name()=sql:variable("@RECEIPTTAG")])[1]','char(1)')='1' and
                            QUERYVIEWSPEC.value('declare namespace bbafx="bb_appfx_queryview";
                                                declare namespace c="bb_appfx_commontypes";
                                                (bbafx:QueryViewSpec/c:MetaTags/attribute::*[local-name()=sql:variable("@AGGREGATETAG")])[1]','char(1)') is null
                    else
                        select 
                            BUSINESSPROCESSVIEW.ID as VALUE, 
                            BUSINESSPROCESSVIEW.CAPTION as LABEL
                        from 
                            dbo.QUERYVIEWCATALOG 
                        inner join 
                            dbo.BUSINESSPROCESSVIEW on QUERYVIEWCATALOG.ID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID
                        where 
                            QUERYVIEWSPEC.value('declare namespace bbafx="bb_appfx_queryview";
                                                declare namespace c="bb_appfx_commontypes";
                                                (bbafx:QueryViewSpec/c:MetaTags/attribute::*[local-name()=sql:variable("@AGGREGATETAG")])[1]','char(1)')='1'