wonum IN (SELECT report1.wonum FROM (SELECT report.wonum, TO_DATE(CONCAT(CONCAT(TO_CHAR(report.fecha, 'DD/MM/YY'), ' '), TO_CHAR(calendar.starttime, 'HH24:MI')), 'DD/MM/YY HH24:MI') AS fechainicio, TO_DATE(CONCAT(CONCAT(TO_CHAR(report.fecha, 'DD/MM/YY'), ' '), TO_CHAR(calendar.starttime, 'HH24:MI')), 'DD/MM/YY HH24:MI') AS fechafin FROM (SELECT wonum, TO_DATE(TO_CHAR(reportdate, 'DD/MM/YY'), 'DD/MM/YY') AS fecha FROM workorder WHERE
historyflag = 0
AND istask = 0
AND siteid  = '6334'
AND woclass IN ('WORKORDER', 'ACTIVITY')
AND location LIKE (CONCAT((SELECT SUBSTR(person.location, 1, (INSTR(person.location, '.') - 1)) FROM person WHERE person.personid = 'HZRTFT'),'%'))
AND worktype = 'EM'
AND woeq8 = (SELECT SUBSTR(person.location, (INSTR(person.location, '.') + 1)) FROM person WHERE person.personid = 'HZRTFT')
AND status NOT IN ('COMP')
AND reportdate >= ADD_MONTHS (TRUNC (SYSDATE,'MM'),0)
AND reportdate <= ADD_MONTHS(TRUNC (SYSDATE, 'MM'), 1)) report
full join(SELECT workdate, starttime, endtime FROM workperiod WHERE
    calnum = 'ROSARIO'
    AND orgid = 'LAAS1002'
    AND shiftnum = (SELECT shiftnum FROM labor WHERE personid = 'HZRTFT')
    ) calendar
ON report.fecha = calendar.workdate
) subjoin,
(SELECT wonum, reportdate FROM workorder WHERE
historyflag = 0
AND istask = 0
AND siteid  = '6334'
AND woclass IN ('WORKORDER', 'ACTIVITY')
AND location LIKE (CONCAT((SELECT SUBSTR(person.location, 1, (INSTR(person.location, '.') - 1)) FROM person WHERE person.personid = 'HZRTFT'),'%'))
AND worktype = 'EM'
AND woeq8 = (SELECT SUBSTR(person.location, (INSTR(person.location, '.') + 1)) FROM person WHERE person.personid = 'HZRTFT')
AND status NOT IN ('COMP')
AND reportdate >= ADD_MONTHS (TRUNC (SYSDATE,'MM'),0)
AND reportdate <= ADD_MONTHS(TRUNC (SYSDATE, 'MM'), 1)) report1
WHERE
report1.wonum = subjoin.wonum
)