CREATE VIEW vwcopilotlicensedusers AS (
 SELECT l.userid,
    l.username,
    l.email,
    l.licenseid,
    l.licensename,
    l.licensetype,
    l.licenseassignmentdate,
    l.divisionid,
    l.updated,
    ud.name AS fullname,
    ud.state AS userstate,
    ud.department,
    ud.title,
    ud.manager AS managerid,
    md.name AS managername,
    dd.name AS divisionname
   FROM (((subuserlicensedata l
     LEFT JOIN userdetails ud ON (((l.userid)::text = (ud.id)::text)))
     LEFT JOIN userdetails md ON (((ud.manager)::text = (md.id)::text)))
     LEFT JOIN divisiondetails dd ON (((l.divisionid)::text = (dd.id)::text)))
  WHERE ((l.copilotlicense = true) AND (l.licenseactive = true) AND (ud.id IS NOT NULL) AND ((ud.state)::text IS DISTINCT FROM 'deleted'::text))
)