USP_DATALIST_NAMINGOPPORTUNITYRECOGNITIONASSOCIATEDREVENUE

This datalist returns all associated revenue for a naming opportunity recognition.

Parameters

Parameter	Parameter Type	Mode	Description
@RECOGNITIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_NAMINGOPPORTUNITYRECOGNITIONASSOCIATEDREVENUE
                (
                    @RECOGNITIONID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        REVENUE.ID,
                        REVENUESPLIT.TYPE,
                        REVENUE.DATE,
                        REVENUESPLIT.AMOUNT,
                        dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
                        NF.NAME as [CONSTITUENT],
                        (select dbo.UDA_BUILDLIST(REVENUEPAYMENTMETHOD.PAYMENTMETHOD) from dbo.REVENUEPAYMENTMETHOD where REVENUEPAYMENTMETHOD.REVENUEID = REVENUE.ID),
                        REVENUESPLIT.BASECURRENCYID
                    from dbo.NAMINGOPPORTUNITYRECOGNITION
                    inner join dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT on NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.NAMINGOPPORTUNITYRECOGNITIONID = NAMINGOPPORTUNITYRECOGNITION.ID
                    inner join dbo.REVENUESPLIT on REVENUESPLIT.ID = NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.REVENUESPLITID
                    inner join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUE.CONSTITUENTID) NF
                    where NAMINGOPPORTUNITYRECOGNITION.ID = @RECOGNITIONID
                    order by REVENUE.DATE, REVENUE.AMOUNT, CONSTITUENT