USP_DATALIST_NAMINGOPPORTUNITYRECOGNITION_REVENUESPLIT

Displays named recognitions associated with a revenue split.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_NAMINGOPPORTUNITYRECOGNITION_REVENUESPLIT
                (
                    @REVENUESPLITID uniqueidentifier
                )
                as
                set nocount on;

                select
                    NAMINGOPPORTUNITYRECOGNITION.ID,
                    NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.ID,
                    NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTID,
                    NAMINGOPPORTUNITY.NAME,
                    NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAME,
                    NAMINGOPPORTUNITYRECOGNITION.STARTDATE,
                    NAMINGOPPORTUNITYRECOGNITION.ENDDATE,
                    NAMINGOPPORTUNITYRECOGNITION.QUANTITY,
                    NAMINGOPPORTUNITYRECOGNITION.AMOUNT,
                    NAMINGOPPORTUNITYRECOGNITION.SPECIALREQUEST,
                    NAMINGOPPORTUNITYRECOGNITION.INSCRIPTION,
                    NAMINGOPPORTUNITYRECOGNITION.DATECHANGED,
                    NAMINGOPPORTUNITYRECOGNITION.BASECURRENCYID
                from
                    dbo.NAMINGOPPORTUNITYRECOGNITION
                    inner join dbo.NAMINGOPPORTUNITY on NAMINGOPPORTUNITY.ID = NAMINGOPPORTUNITYRECOGNITION.NAMINGOPPORTUNITYID
                    inner join dbo.NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT on NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.NAMINGOPPORTUNITYRECOGNITIONID = NAMINGOPPORTUNITYRECOGNITION.ID
                where
                    NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT.REVENUESPLITID = @REVENUESPLITID