= substr(?,1,6)||'01' AND SUBSTR(A.EXTRACT_DTIME,1,8) <= ? GROUP BY SLAB_RT ) b WHERE A.SLAB_RT(+) = B.SLAB_RT ]]> = SUBSTR(?,1,6)||'01' AND SUBSTR(MILL_DTIME,1,8) <= ? GROUP BY PRODNM_CD ) B WHERE A.COIL_RT(+) = B.COIL_RT ]]> = SUBSTR(?,1,6)||'01' AND SUBSTR(A.REG_DTIME,1,8) <= ? GROUP BY SLAB_RT ,A.MISSNO_CLF ) B WHERE A.SLAB_RT(+) = B.SLAB_RT AND A.MISSNO_CLF(+) = B.MISSNO_CLF GROUP BY B.SLAB_RT ]]> = SUBSTR(?,1,6) ||'01' AND SUBSTR(MILL_DTIME,1,8) <= ? GROUP BY A.PRODNM_CD ) B WHERE A.COIL_RT(+) = B.COIL_RT *************************************/ SELECT B.SLAB_RT ,TO_CHAR(MAX(DECODE(B.MISSNO_CLF ,'3',DAY_CNT,NULL))) DAY_CNT ,TO_CHAR(MAX(DECODE(B.MISSNO_CLF ,'3',DAY_WGT,NULL))) DAY_WGT ,TO_CHAR(MAX(DECODE(B.MISSNO_CLF ,'3',MON_CNT,NULL))) MON_CNT ,TO_CHAR(MAX(DECODE(B.MISSNO_CLF ,'3',MON_WGT,NULL))) MON_WGT FROM (SELECT SLAB_RT,A.MISSNO_CLF ,COUNT(A.SLAB_NO) DAY_CNT ,ROUND(SUM(NVL(SLAB_WGT,0))/1000,2) DAY_WGT FROM TBH02_RHF_MISSNO A, TBG02_SLAB_COMM B WHERE A.SLAB_NO = B.SLAB_NO AND SUBSTR(A.REG_DTIME,1,8) = ? GROUP BY SLAB_RT ,A.MISSNO_CLF ) A, ( SELECT SLAB_RT,A.MISSNO_CLF ,COUNT(A.SLAB_NO) MON_CNT ,ROUND(SUM(NVL(SLAB_WGT,0))/1000,2) MON_WGT FROM TBH02_RHF_MISSNO A, TBG02_SLAB_COMM B WHERE A.SLAB_NO = B.SLAB_NO AND SUBSTR(A.REG_DTIME,1,8) >= SUBSTR(?,1,6)||'01' AND SUBSTR(A.REG_DTIME,1,8) <= ? GROUP BY SLAB_RT ,A.MISSNO_CLF ) B WHERE A.SLAB_RT(+) = B.SLAB_RT AND A.MISSNO_CLF(+) = B.MISSNO_CLF GROUP BY B.SLAB_RT ]]> = SUBSTR(? ,1,6)||'01' AND SUBSTR(TRNF_DTIME,1,8) <= ? AND TRNF_DTIME IS NOT NULL ) B, ( SELECT COUNT(COIL_NO) COLD_DAY_CNT , SUM(nvl(decode(ACT_WGT,null,CAL_WGT, ACT_WGT),0)) COLD_DAY_WGT FROM TBH02_COIL_COMM WHERE SUBSTR(CR_PLANT_TRS_DTIME,1,8) = ? AND CR_PLANT_TRS_DTIME IS NOT NULL ) C , ( SELECT COUNT(COIL_NO) COLD_MON_CNT , SUM(nvl(decode(ACT_WGT,null,CAL_WGT, ACT_WGT),0)) COLD_MON_WGT FROM TBH02_COIL_COMM WHERE SUBSTR(CR_PLANT_TRS_DTIME,1,8) >= SUBSTR(? ,1,6)||'01' AND SUBSTR(CR_PLANT_TRS_DTIME,1,8) <= ? AND CR_PLANT_TRS_DTIME IS NOT NULL ) D ]]> = SUBSTR(? ,1,6)||'01' AND SUBSTR(MILL_DTIME,1,8) <= ? AND ORD_FL = '2' AND MILL_DTIME IS NOT NULL ) B, ( SELECT SUM(nvl(decode(ACT_WGT,null,CAL_WGT, ACT_WGT),0)) YC_DAY_WGT_T FROM TBH02_COIL_COMM WHERE SUBSTR(MILL_DTIME,1,8) = ? AND MILL_DTIME IS NOT NULL ) C, ( SELECT SUM(nvl(decode(ACT_WGT,null,CAL_WGT, ACT_WGT),0)) YC_MON_WGT_T FROM TBH02_COIL_COMM WHERE SUBSTR(MILL_DTIME,1,8) >= SUBSTR(? ,1,6)||'01' AND SUBSTR(MILL_DTIME,1,8) <= ? AND MILL_DTIME IS NOT NULL ) D ]]>