1、Get the engineer list
SELECT C.*
     FROM ( SELECT B.*, ROWNUM INDEXID
                     FROM ( SELECT    A.*
                                     FROM ( SELECT NVL2(E.STARTDATE, 1, 0) MINEPROJ,
                                                             DECODE(E.IS_RECIEVED, 2, 1, 0) CHECKBOX,
                                                             E.*,
                                                             TO_CHAR(E.TOTALINVEST, 'FM9999999999990.00') AS JHRWSZTZ,
                                                             TO_CHAR(E.YEARINVEST, 'FM9999999999990.00') AS JHRWSNDTZ,
                                                             DECODE(E.ENG_SPECIALTY_TYPE,
                                                                             '1',
                                                                             '传输设备专业',
                                                                             '2',
                                                                             '通信设备专业',
                                                                             '3',
                                                                             '光缆线路专业',
                                                                             '4',
                                                                             '无线专业',
                                                                             '5',
                                                                             '通信管道专业',
                                                                             '6',
                                                                             '室内覆盖专业',
                                                                             '7',
                                                                             '建筑专业') AS ENG_SPECIALTY_TYPE_NAME,
                                                             TO_CHAR(E.PLANARRIVALDATE, 'yyyy-MM-dd') AS JHRWSJHXDDATE,
                                                             TO_CHAR(E.PLANSCHEDULE, 'yyyy-MM-dd') AS JHRWSJHYQWCDATE,
                                                             ( SELECT TO_CHAR(JHRWSJHYQWCDATE, 'yyyy-MM-dd')
                                                                     FROM BO_JHRWS_VER
                                                                 WHERE BO_PROJECT_ID = E.BO_PROJECT_ID
                                                                     AND VERIONNUMBER = '1.0') JHRWSJHYQTZDATE,
                                                             ( SELECT U.FULLNAME
                                                                     FROM V_USER U
                                                                 WHERE U.USERID = E.PLAN_MANAGER) PLAN_MANAGER_NAME,
                                                             ( SELECT V.ORGANIZATIONNAME
                                                                     FROM V_ORG V
                                                                 WHERE V.ORGANIZATIONID = E.SPECIALTYGROUP) SPECIALTYGROUP_NAME,
                                                             V1.FULLNAME LEADER_NAME,
                                                             '' BO_BLANKTEMPLATE_ID,
                                                             ( SELECT DECODE(COMMENTS, '2', '1', '2')
                                                                     FROM ORGANIZATION_
                                                                 WHERE ORGANIZATIONID = E.BUILD_DEPT) IS_SHUDI_PROJECT,
                                                             ( SELECT NAME
                                                                     FROM ORGANIZATION_
                                                                 WHERE ORGANIZATIONID = E.BUILD_DEPT) BUILD_DEPT_NAME,
                                                             TO_CHAR(s1.INVESTBUDGET, 'FM9999999999990.00') SJPFTZ,
                                                             TO_CHAR(S2.INVEST, 'FM9999999999990.00') SJPFTZTZ,
                                                             V2.FACTCOMPDATE PREDATE,
                                                             V3.FACTCOMPDATE FINALDATE,
                                                             V4.CHECK_COST_BUDGET CHECK_COST_BUDGET, /* F_GETLASTASSESSNAME(E.BO_ENGINEERING_ID, E.BUILD_DEPT)*/
                                                             '数据正在获取中...' LASTASSESSNAME
                                                     FROM V_BO_ENGINEERING E,
                                                             V_USER V1,
                                                             BO_DESIGNAPPROVE_VER S1,
                                                             V_LASTEFFECTED_DESIGNAGREE S2,
                                                             ( SELECT *
                                                                     FROM V_BO_TASK_ITEM1_2_PLAN T
                                                                 WHERE T.ASSESSCODE = 'WCCYSJ') V2,
                                                             ( SELECT *
                                                                     FROM V_BO_TASK_ITEM1_2_PLAN T
                                                                 WHERE T.ASSESSCODE = 'WCJGSJ') V3,
                                                             ( select * from ( SELECT distinct *
                                                                     FROM v_bo_designcheckup_2_eng T
                                                                 WHERE T.IS_PASS_DESIGNCHECK = '1'
                                                                 ORDER BY T.SGJDJYTIME DESC) where rownum=1) V4
                                                 WHERE E.ENGINEERING_STATE = 2
                                                     AND V1.USERID = E.LEADER(+)
                                                     AND S1.BO_PROJECT_ID(+) = E.BO_PROJECT_ID
                                                     AND S1.VERIONNUMBER(+) = '1.0'
                                                     AND S2.PROJECTID(+) = E.BO_PROJECT_ID
                                                     AND e.BO_ENGINEERING_ID = V2.BO_ENGINEERING_ID(+)
                                                     AND e.BO_ENGINEERING_ID = V3.BO_ENGINEERING_ID(+)
                                                     AND e.BO_ENGINEERING_ID = V4.BO_ENGINEERING_ID(+)
                                                     AND E.LEADER = 11402) A
                                 ORDER BY IS_RECIEVED         ASC,
                                                    PLANARRIVALDATE DESC,
                                                    PROJECT_CODE         ASC) B) C
WHERE INDEXID >= 1
     AND INDEXID <= 10
 
 
2、Get the every date of some engineer
SELECT ROWNUM, PP.*
     FROM ( SELECT TT.*
                     FROM ( SELECT T.ASSESSCODE,
                                             T.ASSESSNAME,
                                             T.PLANCOMPDATE,
                                             DECODE(T.ASSESSCODE,
                                                             'GCJSWZSQ',
                                                            WZCODE.ENDDATE,
                                                             'GCZTB',
                                                            DECODE(LEAST(NVL(BZTBCODE.ENDDATE,
                                                                                             TO_DATE( '9999-12-31',
                                                                                                             'YYYY-MM-DD')),
                                                                                     NVL(XZTBCODE.ENDDATE,
                                                                                             TO_DATE( '9999-12-31',
                                                                                                             'YYYY-MM-DD')),
                                                                                     NVL(LSZTBCODE.ENDDATE,
                                                                                             TO_DATE( '9999-12-31',
                                                                                                             'YYYY-MM-DD'))),
                                                                         TO_DATE( '9999-12-31', 'YYYY-MM-DD'),
                                                                         NULL,
                                                                         LEAST(NVL(BZTBCODE.ENDDATE,
                                                                                             TO_DATE( '9999-12-31',
                                                                                                             'YYYY-MM-DD')),
                                                                                     NVL(XZTBCODE.ENDDATE,
                                                                                             TO_DATE( '9999-12-31', 'YYYY-MM-DD')),
                                                                                     NVL(LSZTBCODE.ENDDATE,
                                                                                             TO_DATE( '9999-12-31', 'YYYY-MM-DD')))),
                                                            T.FACTCOMPDATE) FACTCOMPDATE,
                                             T.NEEDCOMPDATE,
                                             T.PHASENAME,
                                             T.ISEDITPLANDATE,
                                             T.SERIALNUM,
                                             T.ISEMPTY
                                     FROM BO_TASK_ITEM1 T,
                                             BO_ENG_PLAN M,
                                             BO_ENGINEERING V,
                                             ( SELECT TRUNC( MIN(A.ENDDATE), 'DD') ENDDATE,
                                                             'GCJSWZSQ' CODE
                                                     FROM BPM_WORKLIST A
                                                 WHERE A.INSTID IN
                                                             ( SELECT V.INSTID
                                                                     FROM BPM_PROCVAR V
                                                                 WHERE V.KEYNAME = 'APPID'
                                                                     AND V.VALUESTRING IN
                                                                             ( SELECT TT.BO_MATERIALAPLLY_ID
                                                                                     FROM BO_ENG_MATERIALAPLLY TT
                                                                                 WHERE TT.BO_ENGINEERING_ID =
                                                                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'))) WZCODE,
                                             ( SELECT TRUNC( MIN(A.ENDDATE), 'DD') ENDDATE,
                                                             'GCZTB' CODE
                                                     FROM BPM_WORKLIST A
                                                 WHERE A.INSTID IN
                                                             ( SELECT V.INSTID
                                                                     FROM BPM_PROCVAR V
                                                                 WHERE V.KEYNAME = 'APPID'
                                                                     AND V.VALUESTRING IN
                                                                             ( SELECT TT.BO_SUPPLYCONFIRM_ID
                                                                                     FROM BO_SUPPLYCONFIRM TT
                                                                                 WHERE TT.BO_ENGINEERING_ID =
                                                                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'))) BZTBCODE,
                                             ( SELECT TRUNC( MIN(A.ENDDATE), 'DD') ENDDATE,
                                                             'GCZTB' CODE
                                                     FROM BPM_WORKLIST A
                                                 WHERE A.INSTID IN
                                                             ( SELECT V.INSTID
                                                                     FROM BPM_PROCVAR V
                                                                 WHERE V.KEYNAME = 'APPID'
                                                                     AND V.VALUESTRING IN
                                                                             ( SELECT TT.BO_BIDAPPLY_ID
                                                                                     FROM BO_BIDAPPLY TT
                                                                                 WHERE TT.BO_ENGINEERING_ID =
                                                                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'))) XZTBCODE,
                                             ( SELECT TRUNC( MIN(A.ENDDATE), 'DD') ENDDATE,
                                                             'GCZTB' CODE
                                                     FROM BPM_WORKLIST A
                                                 WHERE A.INSTID IN
                                                             ( SELECT V.INSTID
                                                                     FROM BPM_PROCVAR V
                                                                 WHERE V.KEYNAME = 'APPID'
                                                                     AND V.VALUESTRING IN
                                                                             ( SELECT TT.BO_TEMPORARYAPPLY_ID
                                                                                     FROM BO_TEMPORARYAPPLY TT
                                                                                 WHERE TT.BO_ENGINEERING_ID =
                                                                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'))) LSZTBCODE
                                 WHERE T.ASSESSCODE != 'ZZJHJD'
                                     AND M.BO_ENGINEERING_ID =
                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'
                                     AND T.BO_ENG_PLAN_ID = M.BO_ENG_PLAN_ID
                                     AND M.BO_ENGINEERING_ID = V.BO_ENGINEERING_ID
                                     AND T.ASSESSCODE = WZCODE.CODE(+)
                                     AND T.ASSESSCODE = BZTBCODE.CODE(+)
                                     AND T.ASSESSCODE = XZTBCODE.CODE(+)
                                     AND T.ASSESSCODE = LSZTBCODE.CODE(+)
                                     AND (T.ISEDITPLANDATE = 1 OR
                                             (T.ASSESSCODE = 'JSJHRWS' OR T.ASSESSCODE = 'MQXMFZR'))
                                 UNION
                                 SELECT 'SJPF' ASSESSCODE,
                                             '设计批复' ASSESSNAME,
                                             NULL PLANCOMPDATE,
                                             ( SELECT DV.CREATEDATE
                                                     FROM BO_DESIGNAPPROVE_VER DV, V_BO_ENGINEERING VE
                                                 WHERE DV.BO_PROJECT_ID = VE.BO_PROJECT_ID(+)
                                                     AND VE.BO_ENGINEERING_ID =
                                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'
                                                     AND DV.VERIONNUMBER = '1.0') FACTCOMPDATE,
                                             ( SELECT T1.NEEDCOMPDATE
                                                     FROM BO_TASK_ITEM1        T1,
                                                             BO_ENG_PLAN            M1,
                                                             V_BO_ENGINEERING V1
                                                 WHERE M1.BO_ENGINEERING_ID =
                                                             '7cb1cce7-48d5-4e37-aae7-e07dcaa8107c'
                                                     AND T1.BO_ENG_PLAN_ID = M1.BO_ENG_PLAN_ID
                                                     AND M1.BO_ENGINEERING_ID = V1.BO_ENGINEERING_ID
                                                     AND (T1.ASSESSCODE = 'SJPF')) NEEDCOMPDATE,
                                             '工程前期' PHASENAME,
                                             '2' ISEDITPLANDATE,
                                             12 SERIALNUM,
                                             '' ISEMPTY
                                     FROM DUAL) TT
                 ORDER BY TT.SERIALNUM) PP