select t.ID,
t.PROJECT,
t.PARENT_TASK,
t.TASK_NAME,
t.STATUS,
t.ASSIGNED_TO,
p.project as PROJ_NAME,
case t.status
when 'Open' then 'fa-exclamation-circle-o'
when 'Closed' then 'fa-check-circle u-success-text'
when 'On-Hold' then 'fa-minus-circle u-danger-text'
when 'Pending' then 'fa-exclamation-triangle u-warning-text'
end BADGE_STATE
from EBA_UT_CHART_TASKS t,
EBA_UT_CHART_PROJECTS p
where t.project = p.id