SELECT wo.WORKORDERID "Request ID",
       wo.TITLE "Subject",
       ti.FIRST_NAME "Technician",
       pd.PRIORITYNAME "Priority",
       wo.CREATEDTIME "Created Time",
       wo.DUEBYTIME "DueBy Time",
       std.STATUSNAME "Request Status",
       CASE
           WHEN wos.ISOVERDUE='1' THEN 'Yes'
           ELSE 'No'
       END "Overdue Status",
       wodm.Dependsonid "Depends on" FROM WorkOrder wo
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
INNER JOIN WODependency wod ON wo.workorderid=wod.workorderid
INNER JOIN WODependencyMarking wodm ON wod.Reqdependencyid=wodm.Reqdependencyid
WHERE (wo.ISPARENT='1')