UFN_OPPORTUNITY_DESIGNATION

Returns the Designation for an opportunity.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_OPPORTUNITY_DESIGNATION(@OPPORTUNITYID uniqueidentifier)
            returns table
            as return
                select 
                    ID,
                    DESIGNATIONID,
                    AMOUNT,
                    SEQUENCE,
                    CONSTITUENTID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENTID) as CONSTITUENTNAME
                from
                    dbo.OPPORTUNITYDESIGNATION 
                where
                    OPPORTUNITYID=@OPPORTUNITYID