gm working

SELECT * FROM workorder WHERE
wonum IN (SELECT woshift.wonum FROM
(SELECT report.wonum, report.reportdate, 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.endtime, 'HH24:MI')), 'DD/MM/YY HH24:MI') AS fechafin FROM (
                SELECT wonum, reportdate, 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
                inner 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) woshift
WHERE
woshift.reportdate >= woshift.fechainicio
AND
woshift.reportdate <= woshift.fechafin)
ORDER BY reportdate
;