step_04_max_vendor_632734_exp

select wonum
     , projectname
     , status
     , description
     , jpnum
     , supervisor
     , location
     , assetnum
     , actfinish
     , reportedby
     , reportdate
from workorder
where istask = 0
and commoditygroup = 'ENG'
and commodity = 'DES'
and status not in ('CAN', 'NWA')
and vendor = '632734'
and projectname IS NOT NULL
and (actfinish > DATEADD(year,-1,GETDATE()) OR actfinish IS NULL);