UFN_ADDPROSPECTPLANSPROCESS_OPPORTUNITYDESIGNATIONS_2

Returns all opportunity designations for a given Add Prospect Plans process instance (including multicurrency fields).

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ADDPROSPECTPLANSPROCESSID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ADDPROSPECTPLANSPROCESS_OPPORTUNITYDESIGNATIONS_2
            (
                @ADDPROSPECTPLANSPROCESSID uniqueidentifier
            )
            returns table 
            as return
                select 
                    ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION.ID, 
                    DESIGNATIONID, 
                    AMOUNT, 
                    SEQUENCE,
                    FUNDINGMETHODCODEID,
                    CATEGORYCODEID,
                    TYPECODEID,
                    USECODEID,
                    OPPORTUNITYTRANSACTIONCURRENCYID as TRANSACTIONCURRENCYID
                from 
                    dbo.ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION
                join
                    dbo.ADDPROSPECTPLANSPROCESS
                on
                    ADDPROSPECTPLANSPROCESS.ID = ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION.ADDPROSPECTPLANSPROCESSID
                where
                    ADDPROSPECTPLANSPROCESSID = @ADDPROSPECTPLANSPROCESSID;