UFN_OPPORTUNITY_GETLONGDESCRIPTIONFIELDS

CREATE function dbo.UFN_OPPORTUNITY_GETLONGDESCRIPTIONFIELDS(@ID uniqueidentifier)
returns table
as
  return
    select 
      NF.NAME as CONSTITUENTNAME, 
      OPPORTUNITY.TRANSACTIONASKAMOUNT as ASKAMOUNT, 
      OPPORTUNITY.ASKDATE, 
      OPPORTUNITY.STATUS, 
      OPPORTUNITY.TRANSACTIONCURRENCYID, 
      OPPORTUNITY.TRANSACTIONAMOUNT as TRANSACTIONAMOUNT 
    from 
      dbo.OPPORTUNITY 
    inner join 
      dbo.PROSPECTPLAN on PROSPECTPLAN.ID = OPPORTUNITY.PROSPECTPLANID 
    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECTPLAN.PROSPECTID ) NF
    where 
      OPPORTUNITY.ID = @ID;