SELECT status_id id ,work_order_status value ,case system_status when 1 then 1 when 3 then 1 when 6 then 1 when 17 then 1 else 0 end area_flag from eam_wo_statuses_v
View Text - HTML Formatted
SELECT STATUS_ID ID , WORK_ORDER_STATUS VALUE , CASE SYSTEM_STATUS WHEN 1 THEN 1 WHEN 3 THEN 1 WHEN 6 THEN 1 WHEN 17 THEN 1 ELSE 0 END AREA_FLAG FROM EAM_WO_STATUSES_V