USP_DATALIST_OPPORTUNITY_DESIGNATION

A datalist of designations for a given opportunity.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_OPPORTUNITY_DESIGNATION(@OPPORTUNITYID uniqueidentifier)
                as begin

                    select 
                        OPPORTUNITYDESIGNATION.ID as OPPORTUNITYDESIGNATIONID,
                        DESIGNATION.ID as DESIGNATIONID,
                        dbo.UFN_DESIGNATION_BUILDNAME(OPPORTUNITYDESIGNATION.DESIGNATIONID) as NAME,
                        OPPORTUNITYDESIGNATION.TRANSACTIONAMOUNT,
                        OPPORTUNITYDESIGNATION.TRANSACTIONCURRENCYID,
                        dbo.UFN_OPPORTUNITYDESIGNATIONFMCODE_GETDESCRIPTION(dbo.OPPORTUNITYDESIGNATION.FUNDINGMETHODCODEID) as FUNDINGMETHODCODEID,
                        dbo.UFN_PLANNEDGIFTDESCATEGORYCODE_GETDESCRIPTION(dbo.OPPORTUNITYDESIGNATION.CATEGORYCODEID) as CATEGORYCODEID,
                        dbo.UFN_OPPORTUNITYDESIGNATIONTYPECODE_GETDESCRIPTION(dbo.OPPORTUNITYDESIGNATION.TYPECODEID) as TYPECODEID,
                        dbo.UFN_DESIGNATIONUSECODE_GETDESCRIPTION(dbo.OPPORTUNITYDESIGNATION.USECODEID) as USECODEID
                    from
                        dbo.OPPORTUNITYDESIGNATION
                        left join dbo.DESIGNATION on DESIGNATION.ID = OPPORTUNITYDESIGNATION.DESIGNATIONID
                    where
                        OPPORTUNITYDESIGNATION.OPPORTUNITYID = @OPPORTUNITYID
                    order by
                        OPPORTUNITYDESIGNATION.SEQUENCE

                end