select * 
  from ((select yx.task_oid taskOid,
                itsd.TASK_DATA_OID taskDataId,
                yx.FLD_BUS_REQ_NUMBER busReqNumber,
                yx.TASK_TITLE taskTitle,
                yx.FLD_DEMAND_SOURCES_PERSON,
                yx.fld_create_person demandSourcesPerson,
                yx.FLD_HOST_PERSON,
                rdmp.BOMC_USER_NO(yx.FLD_HOST_PERSON) hostPerson,
                yx.FLD_TASK_STATE,
                rdmp.FUNC_ITSM_CODE(99, yx.FLD_TASK_STATE) taskState,
                yx.FLD_TYPE,
                rdmp.FUNC_ITSM_CODE(76, yx.FLD_TYPE) type,
                yx.FLD_DEMAND_SOURCES_DEP_ID,
                rdmp.BOMC_DEPT(yx.FLD_DEMAND_SOURCES_DEP_ID) demandSourcesDep,
                '' oaReqNumber,
                yx.TASK_CREATE_TIME,
                to_char(yx.TASK_CREATE_TIME, 'yyyy-MM-dd hh24:mi:ss') taskCreateTime,
                yx.FLD_HOPE_FINISH_DATE,
                to_char(yx.FLD_HOPE_FINISH_DATE, 'yyyy-MM-dd hh24:mi:ss') hopeFinishDate,
                to_char(rx.FLD_ON_LINE_TIME, 'yyyy-MM-dd hh24:mi:ss') onlineTime,
                yx.FLD_BUS_ARCHIVING_TIME,
                to_char(yx.FLD_BUS_ARCHIVING_TIME, 'yyyy-MM-dd hh24:mi:ss') busArchivingTime,
                yx.FLD_HOST_DEP,
                rdmp.BOMC_DEPT(yx.FLD_HOST_DEP) hostDep,
                yx.FLD_URGENT,
                rdmp.FUNC_ITSM_CODE(111, yx.FLD_URGENT) urgent,
                yx.FLD_EVALUATION_GRADE,
                nvl2(yx.FLD_EVALUATION_GRADE, 0, 1) evaluationGrade,
                (select count(1)
                   from rdmp.FJ_REQ_SPLIT irs
                  where irs.task_oid = yx.task_oid
                    and irs.SOFTWARE_REQ_STASK_OID is not null) childNum,
                'N' as newOrOld
           from rdmp.ITSM_TASK_STAT_2105 yx,
                (select b.task_oid yx_task_oid, a.*
                   from rdmp.fj_itsm_task_stat_2111_stage a, rdmp.fj_req_split b
                  where a.task_oid = b.SOFTWARE_REQ_STASK_OID) rx,
                (select TASK_OID, max(TASK_DATA_OID) TASK_DATA_OID
                   from rdmp.ITSM_TASK_STAT_2105_DATA
                  group by TASK_OID) itsd
          where yx.task_oid = rx.yx_task_oid(+)
            and itsd.TASK_OID = yx.TASK_OID) union
        (select 0 as taskoid,
                0 as taskdataid,
                o.fld_bus_req_number as busReqNumber,
                o.fld_task_title as taskTitle,
                o.FLD_DEMAND_SOURCES_PERSON,
                o.FLD_DEMAND_SOURCES_PERSON demandSourcesPerson,
                o.FLD_HOST_PERSON,
                o.FLD_HOST_PERSON hostPerson,
                o.FLD_TASK_STATE,
                rdmp.FUNC_ITSM_CODE(99, o.FLD_TASK_STATE) taskState,
                o.FLD_TYPE,
                rdmp.FUNC_ITSM_CODE(76, o.FLD_TYPE) type,
                o.FLD_DEMAND_SOURCES_DEP FLD_DEMAND_SOURCES_DEP_ID,
                o.FLD_DEMAND_SOURCES_DEP as demandSourcesDep,
                o.oa_code oaReqNumber,
                o.fld_task_create_time TASK_CREATE_TIME,
                to_char(o.fld_task_create_time, 'yyyy-MM-dd hh24:mi:ss') taskCreateTime,
                o.FLD_HOPE_FINISH_DATE,
                to_char(o.FLD_HOPE_FINISH_DATE, 'yyyy-MM-dd hh24:mi:ss') hopeFinishDate,
                to_char(o.FLD_ON_LINE_TIME, 'yyyy-MM-dd hh24:mi:ss') onlineTime,
                o.FLD_BUS_ARCHIVING_TIME FLD_BUS_ARCHIVING_TIME,
                to_char(o.FLD_BUS_ARCHIVING_TIME, 'yyyy-MM-dd hh24:mi:ss') busArchivingTime,
                o.FLD_HOST_DEP,
                o.FLD_HOST_DEP hostDep,
                o.FLD_URGENT,
                o.FLD_URGENT urgent,
                '' FLD_EVALUATION_GRADE,
                0 evaluationGrade,
                0 childNum,
                'O' as newOrOld
           from rdmp.OLD_BUS_REQ o))
 where 1 = 1
   AND (instr(lower(busReqNumber), '111') > 0)
   AND (instr(lower(taskTitle), '11') > 0)
   AND FLD_TASK_STATE IN ('1', '2', '3', '4', '5', '6', '0')
   AND FLD_DEMAND_SOURCES_PERSON IN ('9990969')
   AND FLD_HOST_PERSON IN ('9990969')
   AND instr(demandSourcesDep, 'ʡ˾Ϣ֧') > 0
   AND task_create_time >=
       to_date('2018-06-21 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
   AND task_create_time <=
       to_date('2018-06-22 23:59:59', 'yyyy-mm-dd hh24:mi:ss')
   AND FLD_HOPE_FINISH_DATE >=
       to_date('2018-06-21 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
   AND FLD_HOPE_FINISH_DATE <=
       to_date('2018-06-22 23:59:59', 'yyyy-mm-dd hh24:mi:ss')
   AND FLD_BUS_ARCHIVING_TIME >=
       to_date('2018-06-21 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
   AND FLD_BUS_ARCHIVING_TIME <=
       to_date('2018-06-22 23:59:59', 'yyyy-mm-dd hh24:mi:ss')
   AND instr(hostDep, 'ʡ˾Ϣ֧') > 0
