UFN_SITEID_MAPFROM_OPPORTUNITYDESIGNATIONID

Maps an OPPORTUNITYDESIGNATIONID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@OPPORTUNITYDESIGNATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_OPPORTUNITYDESIGNATIONID(@OPPORTUNITYDESIGNATIONID uniqueidentifier)   
            returns table
            as  
            return
                select PROSPECTPLANSITE.SITEID   
                from dbo.OPPORTUNITYDESIGNATION OD  
                left outer join dbo.OPPORTUNITY O on OD.OPPORTUNITYID = O.ID  
                left outer join dbo.PROSPECTPLANSITE on O.PROSPECTPLANID = PROSPECTPLANSITE.PROSPECTPLANID  
                where OD.ID = @OPPORTUNITYDESIGNATIONID;