create view sysdba.SalesProcessPlugin
as
    select
          p.pluginid as SalesProcessPluginID
        , p.CreateUser
        , p.CreateDate
        , p.ModifyUser
        , p.ModifyDate
        , p.Name
        , p.Family
        , p.ReleasedDate
    from
        sysdba.plugin p
    where
        p.type = 1
        and
        p.basedon is not null
        and
        p.userid = 'SYST00000001'
go