UFN_ADDOPPORTUNITIESPROCESS_OPPORTUNITYDESIGNATIONS

Returns all opportunity designations for a given Add Opportunities process instance.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ADDOPPORTUNITIESPROCESSID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_ADDOPPORTUNITIESPROCESS_OPPORTUNITYDESIGNATIONS
(
    @ADDOPPORTUNITIESPROCESSID uniqueidentifier
)
returns table 
as return
    select 
        ID, 
        DESIGNATIONID, 
        AMOUNT, 
        SEQUENCE,
        TRANSACTIONCURRENCYID,
        FUNDINGMETHODCODEID,
        CATEGORYCODEID,
        TYPECODEID,
        USECODEID
    from 
        dbo.ADDOPPORTUNITIESPROCESSOPPORTUNITYDESIGNATION
    where
        ADDOPPORTUNITIESPROCESSID = @ADDOPPORTUNITIESPROCESSID;