UFN_OPPORTUNITY_PROSPECTPLAN
Returns the parent plan for an opportunity.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OPPORTUNITYID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_OPPORTUNITY_PROSPECTPLAN(@OPPORTUNITYID uniqueidentifier)
returns uniqueidentifier
as begin
return (
select PROSPECTPLANID from dbo.OPPORTUNITY where ID=@OPPORTUNITYID
)
end