C.C_ORD_THK' CONDITION_ FROM TBF02_ROLL_THK_GRP WHERE PLT='C' GROUP BY TYPE_ ) B WHERE B.MINI<=C.C_ORD_THK AND B.MAXI>C.C_ORD_THK AND A.COIL_STAT='2' AND A.ORD_FL='1' AND A.FL='0' AND A.ORD_NO=C.ORD_NO AND A.ORD_SEQ=C.ORD_SEQ AND C.PROD_LINE IN('C','P') GROUP BY B.TYPE_,B.CONDITION_ ) T2 ON T1.TYPE_ = T2.TYPE_ ]]> C.C_ORD_WTH' CONDITION_ FROM TBF02_ROLL_WTH_GRP WHERE PLT='C' ) B WHERE B.MINI<=C.C_ORD_WTH AND B.MAXI>C.C_ORD_WTH AND A.COIL_STAT='2' AND A.ORD_FL='1' AND A.FL='0' AND A.ORD_NO=C.ORD_NO AND A.ORD_SEQ=C.ORD_SEQ AND C.PROD_LINE IN('C','P') GROUP BY B.TYPE_,B.CONDITION_ ) T2 ON T1.TYPE_=T2.TYPE_ ORDER BY INDEX_ ]]> =1 AND SYSDATE-TO_DATE(A.MILL_DTIME,'||'''YYYYMMDDHH24MISS'''||')<;2' CONDITION_ FROM C_TBL02_COIL_COMM A,TBE02_ORD_PRC C WHERE COIL_STAT='2' AND A.ORD_FL='1' AND SYSDATE-TO_DATE(MILL_DTIME,'YYYYMMDDHH24MISS')>=1 AND SYSDATE-TO_DATE(MILL_DTIME,'YYYYMMDDHH24MISS')<2 AND A.ORD_NO=C.ORD_NO AND A.ORD_SEQ=C.ORD_SEQ AND C.PROD_LINE IN('C','P') AND A.FL='0' UNION SELECT '03' INDEX_,'未到3日~4日' TYPE_,SUM(1) QUANTITY,SUM(ACT_WGT) WEIGHT,SUM(COIL_LEN) LENGTH, 'SYSDATE-TO_DATE(A.MILL_DTIME,'||'''YYYYMMDDHH24MISS'''||')>=2 AND SYSDATE-TO_DATE(A.MILL_DTIME,'||'''YYYYMMDDHH24MISS'''||')<3' CONDITION_ FROM C_TBL02_COIL_COMM A,TBE02_ORD_PRC C WHERE COIL_STAT='2' AND A.ORD_FL='1' AND SYSDATE-TO_DATE(MILL_DTIME,'YYYYMMDDHH24MISS')>=2 AND SYSDATE-TO_DATE(MILL_DTIME,'YYYYMMDDHH24MISS')<3 AND A.ORD_NO=C.ORD_NO AND A.ORD_SEQ=C.ORD_SEQ AND C.PROD_LINE IN('C','P') AND A.FL='0' UNION SELECT '04' INDEX_,'5日以上' TYPE_,SUM(1) QUANTITY,SUM(ACT_WGT) WEIGHT,SUM(COIL_LEN) LENGTH, 'SYSDATE-TO_DATE(A.MILL_DTIME,'||'''YYYYMMDDHH24MISS'''||')>5' CONDITION_ FROM C_TBL02_COIL_COMM A,TBE02_ORD_PRC C WHERE COIL_STAT='2' AND A.ORD_FL='1' AND SYSDATE-TO_DATE(MILL_DTIME,'YYYYMMDDHH24MISS')>5 AND A.ORD_NO=C.ORD_NO AND A.ORD_SEQ=C.ORD_SEQ AND C.PROD_LINE IN('C','P') AND A.FL='0' ]]> SELECT B.C_SPEC_STL_GRD TYPE_ ,SUM(1) QUANTITY ,SUM(A.ACT_WGT) WEIGHT ,SUM(A.COIL_LEN) LENGTH ,'C.C_SPEC_STL_GRD='''||NVL(B.C_SPEC_STL_GRD,'NULL')||'''' CONDITION_ FROM C_TBL02_COIL_COMM A ,TBE02_ORD_PRC B WHERE A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.FL = '0' AND A.COIL_STAT = '2' AND A.ORD_FL = '1' AND B.PROD_LINE IN ('C','P') GROUP BY B.C_SPEC_STL_GRD SELECT B.PRODNM_CD TYPE_ ,SUM(1) QUANTITY ,SUM(A.ACT_WGT) WEIGHT ,SUM(A.COIL_LEN) LENGTH ,'C.PRODNM_CD='''||NVL(B.PRODNM_CD,'NULL')||'''' CONDITION_ FROM C_TBL02_COIL_COMM A ,TBE02_ORD_PRC B WHERE A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.FL = '0' AND A.COIL_STAT = '2' AND A.ORD_FL = '1' AND B.PROD_LINE IN ('C','P') GROUP BY B.PRODNM_CD