USP_DATALIST_CONTACTREPORT_OPPORTUNITIES

List of opportunities for a contact report's prospect plan.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_CONTACTREPORT_OPPORTUNITIES(@INTERACTIONID uniqueidentifier)
            as begin
                set nocount on;
                select
                    OPPORTUNITY.ID,
                    OPPORTUNITY.STATUS,
                    OPPORTUNITY.TRANSACTIONEXPECTEDASKAMOUNT as EXPECTEDASKAMOUNT,
                    OPPORTUNITY.EXPECTEDASKDATE,
                    LIKELIHOODTYPECODE.DESCRIPTION LIKELIHOOD,
                    OPPORTUNITY.TRANSACTIONASKAMOUNT as ASKAMOUNT,
                    OPPORTUNITY.ASKDATE,
                    case OPPORTUNITY.STATUSCODE when 3 then OPPORTUNITY.TRANSACTIONAMOUNT else 0 end as ACCEPTEDAMOUNT,
                    OPPORTUNITY.RESPONSEDATE,
                    OPPORTUNITY.TRANSACTIONCURRENCYID
                from dbo.INTERACTION
                    inner join dbo.OPPORTUNITY on OPPORTUNITY.PROSPECTPLANID = INTERACTION.PROSPECTPLANID
                    left join dbo.LIKELIHOODTYPECODE on LIKELIHOODTYPECODE.ID = OPPORTUNITY.LIKELIHOODTYPECODEID
                where INTERACTION.ID = @INTERACTIONID
                order by OPPORTUNITY.DATEADDED;
            end