SELECT
"wo"."WORKORDERID" AS "ID de la solicitud",
"rtdef"."NAME" AS "Tipo de solicitud",
"cd"."CATEGORYNAME" AS "Categoría",
"scd"."NAME" AS "Subcategoría",
"wotodesc"."FULLDESCRIPTION" AS "Descripción",
"appStDef"."STATUSNAME" AS "Estado de la aprobación"
FROM
"WorkOrder" "wo"
LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID"
LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID"
LEFT JOIN "CategoryDefinition" "cd" ON "wos"."CATEGORYID"="cd"."CATEGORYID"
LEFT JOIN "SubCategoryDefinition" "scd" ON "wos"."SUBCATEGORYID"="scd"."SUBCATEGORYID"
LEFT JOIN "RequestTypeDefinition" "rtdef" ON "wos"."REQUESTTYPEID"="rtdef"."REQUESTTYPEID"
LEFT JOIN "ApprovalStatusDefinition" "appStDef" ON "wos"."APPR_STATUSID"="appStDef"."STATUSID"
WHERE
(((("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'Approved')
OR ("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'Denied'))
OR ("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'Pending Approval'))
OR ("appStDef"."STATUSNAME" COLLATE Traditional_Spanish_CI_AS = N'To Be Sent'))
AND wo.ISPARENT='1'
ORDER BY 6