UFN_PROSPECTSEARCH_GET_AVAILABLETILES

create function dbo.UFN_PROSPECTSEARCH_GET_AVAILABLETILES()
returns table
as return (
  select 
      tile.ID,
    tile.DATAFORMINSTANCECATALOGID as TILEID,
    tile.TILENAME,
    tile.SEQUENCE
  from
      PROSPECTSEARCHAVAILABLETILE tile
  left join
      PROSPECTSEARCHAVAILABLETILEFORACCOUNTTYPE account on tile.ID = account.PROSPECTSEARCHAVAILABLETILEID
  inner join
    WEALTHPOINTCONFIGURATION config on config.ACCOUNTTYPECODE = account.ACCOUNTTYPECODE
)