SELECT A.OLD_SAMPL_NO COIL_NO,A.SLAB_NO,A.CUR_PROG_CD,A.SPEC_STL_GRD, A.COIL_THK,A.COIL_WTH,A.COIL_LEN, A.COIL_INDIA,A.COIL_OUTDIA,A.ACT_WGT, TO_DATE(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss') MILL_DTIME, DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','未判') TOT_DEC_GRD, C_PKG_UIF_CAL.F_FUN_GET_FACEBUG(A.CRK_CD1,A.CRK_CD2,A.CRK_CD3,A.CRK_CD4,A.CRK_CD5) BUG, A.CUR_LOAD_LOC, B.C_SPEC_STL_GRD,B.C_ORD_THK,B.C_ORD_THK_MIN,B.C_ORD_THK_MAX, B.C_ORD_WTH,B.C_ORD_WTH_MIN,B.C_ORD_WTH_MAX, B.C_ORD_LEN,B.C_ORD_LEN_MIN,B.C_ORD_LEN_MAX, B.ORD_UNIT_WGT,B.ORD_UNIT_WGT_MIN,B.ORD_UNIT_WGT_MAX, B.L_ORD_INDIA,B.C_EXTSHAPE_REQ,C.SM_CFNM L_ORD_USEAGE_CD,D.CUST_NM ORDCUST_CD, E.SM_CFNM PACK_METHOD,B.C_SPEC_ABBSYM,B.ANNOITA_YN,B.PLY_REQUEST,'FALSE' FLAG, B.ORD_NO,B.ORD_SEQ,B.DEL_TO_DATE,B.MK_CONTENT,B.C_PRODNM_CD || '/' || F.C_EXTSHAPE_REQ || '/' || SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010', F.PAKMTH_TP), 0, 1) || '/大于' || F.PROD_WGT_MIN || '小于' || F.PROD_WGT_MAX || '/' || PKG_QUALITY_COMM.FZ00_COMM('A01010', F.PAKMTH_TP) || '/厚度(' || B.C_ORD_THK_MIN || '~' || B.C_ORD_THK_MAX || ')/宽度(' || B.C_ORD_WTH_MIN || '~' || B.C_ORD_WTH_MAX || ')/内径(' || F.C_ORD_INDIA || ')' JISHUYAOQIU, DECODE(SUBSTR(A.OLD_SAMPL_NO,1,1),'L','返修','正常酸洗') coiltype, NVL(A.RCAL_CNT,0)+1 RCAL_CNT,A.FB_YN, ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM, (SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ FROM C_TBK02_COIL_COMM A,TBE02_ORD_PRC B,TBZ00_COMMCD C,TBZ00_CUSTOMER D,TBZ00_COMMCD E ,TBA01_ORD_LINE F WHERE A.COIL_STAT='2' AND A.ORD_NO=B.ORD_NO AND A.ORD_SEQ=B.ORD_SEQ AND A.ORD_NO=F.ORD_NO AND A.ORD_SEQ=F.ORD_SEQ AND A.ORD_FL='1' AND A.FL='0' AND B.L_ORD_USEAGE_CD=C.SM_CD(+) AND B.ORDCUST_CD=D.CUST_CD(+) AND A.CUR_LOAD_LOC LIKE '6%' AND B.PACK_METHOD=E.SM_CD(+) AND E.LG_CD(+)='A01010' SELECT A.OLD_SAMPL_NO COIL_NO,A.SLAB_NO,A.CUR_PROG_CD,A.SPEC_STL_GRD, A.COIL_THK,A.COIL_WTH,A.COIL_LEN, A.COIL_INDIA,A.COIL_OUTDIA,A.ACT_WGT, DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','未判') TOT_DEC_GRD, C_PKG_UIF_CAL.F_FUN_GET_FACEBUG(A.CRK_CD1,A.CRK_CD2,A.CRK_CD3,A.CRK_CD4,A.CRK_CD5) BUG, A.CUR_LOAD_LOC, B.C_SPEC_STL_GRD,B.C_ORD_THK,B.C_ORD_THK_MIN,B.C_ORD_THK_MAX, B.C_ORD_WTH,B.C_ORD_WTH_MIN,B.C_ORD_WTH_MAX, B.C_ORD_LEN,B.C_ORD_LEN_MIN,B.C_ORD_LEN_MAX, B.ORD_UNIT_WGT,B.ORD_UNIT_WGT_MIN,B.ORD_UNIT_WGT_MAX, B.L_ORD_INDIA,B.C_EXTSHAPE_REQ,C.SM_CFNM L_ORD_USEAGE_CD,D.CUST_NM ORDCUST_CD, E.SM_CFNM PACK_METHOD,B.C_SPEC_ABBSYM,B.ANNOITA_YN,B.PLY_REQUEST,'FALSE' FLAG, B.ORD_NO,B.ORD_SEQ,B.DEL_TO_DATE FROM C_TBL02_COIL_COMM A,TBE02_ORD_PRC B,TBZ00_COMMCD C,TBZ00_CUSTOMER D,TBZ00_COMMCD E WHERE A.COIL_STAT='2' AND A.FB_YN='N'AND A.ORD_NO=B.ORD_NO AND A.ORD_SEQ=B.ORD_SEQ AND A.CUR_PROG_CD='DBA' AND A.FL='0' AND B.L_ORD_USEAGE_CD=C.SM_CD(+) AND B.ORDCUST_CD=D.CUST_CD(+) AND B.PACK_METHOD=E.SM_CD(+) AND E.LG_CD(+)='A01010' SELECT 'REEL计划号' TYPE_,MAX(CAL_NO) CAPTION FROM L_TBF03_SCH_CAL UNION SELECT '个数(个)' TYPE_,TO_CHAR(MAX(CAL_COIL_CNT)) CAPTION FROM L_TBF03_SCH_REEL UNION SELECT '重量(Ton)' TYPE_,TO_CHAR(MAX(CAL_COIL_WGT)) CAPTION FROM L_TBF03_SCH_REEL SELECT A.COIL_NO C_COIL_NO, A.COIL_NO, A.ROLL_NO CAL_NO, F.SLAB_NO, F.CUR_PROG_CD, F.STL_GRD, F.COIL_THK, F.COIL_WTH, F.COIL_LEN, F.COIL_INDIA, F.COIL_OUTDIA, F.ACT_WGT COIL_WGT, DECODE(F.TOT_DEC_GRD, '1', '合格', '2', '不合格', '未判') TOT_DEC_GRD, NULL BUG, B.C_SPEC_STL_GRD, B.C_ORD_THK, B.C_ORD_THK_MIN, B.C_ORD_THK_MAX, B.C_ORD_WTH, B.C_ORD_WTH_MIN, B.C_ORD_WTH_MAX, B.C_ORD_LEN, B.C_ORD_LEN_MIN, B.C_ORD_LEN_MAX, B.ORD_UNIT_WGT, B.ORD_UNIT_WGT_MIN, B.ORD_UNIT_WGT_MAX, B.L_ORD_INDIA, B.C_EXTSHAPE_REQ, C.SM_CFNM L_ORD_USEAGE_CD, D.CUST_NM ORDCUST_CD, E.SM_CFNM PACK_METHOD, B.C_SPEC_ABBSYM, B.ANNOITA_YN, B.PLY_REQUEST, --LPAD(TO_CHAR(A.COIL_EDT_SEQ), 3, '0') COIL_EDT_SEQ, A.ROLL_COIL_SEQ COIL_EDT_SEQ, B.ORD_NO, B.ORD_SEQ, B.DEL_TO_DATE, '' MERGE_FL, DECODE(SUBSTR(F.OLD_SAMPL_NO, 1, 1), 'L', '返修', '正常酸洗') coiltype, NVL(F.RCAL_CNT, 0) + 1 RCAL_CNT, ROUND(SYSDATE - TO_DATE(F.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS'), 1) COLDTIM, F.CUR_LOAD_LOC FROM S_tbf03_sch_mill A, TBE02_ORD_PRC B, TBZ00_COMMCD C, TBZ00_CUSTOMER D, TBZ00_COMMCD E, C_TBK02_COIL_COMM F WHERE A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.COIL_NO = F.OLD_SAMPL_NO AND B.L_ORD_USEAGE_CD = C.SM_CD(+) AND B.ORDCUST_CD = D.CUST_CD(+) AND B.PACK_METHOD = E.SM_CD(+) AND E.LG_CD(+) = 'A01010' -- AND A.L2_SEND = 'N' and a.ROLL_NO like 'Z%' ORDER BY A.ROLL_COIL_SEQ SELECT A.C_COIL_NO, A.COIL_NO, F.SLAB_NO, F.CUR_PROG_CD, F.STL_GRD, F.COIL_THK, F.COIL_WTH, F.COIL_LEN, F.COIL_INDIA, F.COIL_OUTDIA, F.ACT_WGT COIL_WGT, DECODE(F.TOT_DEC_GRD, '1', '合格', '2', '不合格', '未判') TOT_DEC_GRD, NULL BUG, A.CUR_LOAD_LOC, B.C_SPEC_STL_GRD, B.C_ORD_THK, B.C_ORD_THK_MIN, B.C_ORD_THK_MAX, B.C_ORD_WTH, B.C_ORD_WTH_MIN, B.C_ORD_WTH_MAX, B.C_ORD_LEN, B.C_ORD_LEN_MIN, B.C_ORD_LEN_MAX, B.ORD_UNIT_WGT, B.ORD_UNIT_WGT_MIN, B.ORD_UNIT_WGT_MAX, B.L_ORD_INDIA, B.C_EXTSHAPE_REQ, C.SM_CFNM L_ORD_USEAGE_CD, D.CUST_NM ORDCUST_CD, E.SM_CFNM PACK_METHOD, B.C_SPEC_ABBSYM, B.ANNOITA_YN, B.PLY_REQUEST, LPAD(TO_CHAR(A.COIL_EDT_SEQ), 3, '0') COIL_EDT_SEQ, B.ORD_NO, B.ORD_SEQ, B.DEL_TO_DATE, DECODE(A.SLEEVE, '', NULL, '√') SLEEVE, S.NAME_ SLEEVE_CODE, '' SPM_MODE, '' SPM_WET, DECODE(A.PULL, '1', '√', NULL) PULL, A.CAL_MEMO, A.CAL_NO, '' MERGE_FL FROM L_TBF03_SPEC_REEL A, TBE02_ORD_PRC B, TBZ00_COMMCD C, TBZ00_CUSTOMER D, TBZ00_COMMCD E, C_TBL02_COIL_COMM F, (SELECT SLEEVE_GRP_CD ID_, TO_CHAR(SLEEVE_INDIA) || '/' || TO_CHAR(SLEEVE_INDIA + SLEEVE_THK) NAME_ FROM TBF03_SLEEVE_GRP) S WHERE A.ORD_NO = B.ORD_NO AND A.ORD_SEQ = B.ORD_SEQ AND A.C_COIL_NO = F.OLD_SAMPL_NO AND B.L_ORD_USEAGE_CD = C.SM_CD(+) AND B.ORDCUST_CD = D.CUST_CD(+) AND B.PACK_METHOD = E.SM_CD(+) AND A.SLEEVE = S.ID_(+) AND E.LG_CD(+) = 'A01010' AND A.L2_SEND = 'N' ORDER BY LPAD(TO_CHAR(A.COIL_EDT_SEQ), 3, '0') SELECT 'FALSE' FLAG, SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01118' AND CD_DESC = 'C' SELECT 'FALSE' FLAG, SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01016' SELECT SLEEVE_GRP_CD ID_, TO_CHAR(SLEEVE_INDIA) || '/' || TO_CHAR(SLEEVE_INDIA + SLEEVE_THK) NAME_ FROM TBF03_SLEEVE_GRP SELECT SM_CD ID_, SM_CFNM NAME_ FROM TBZ00_COMMCD WHERE LG_CD = 'F02002' ORDER BY CD_SEQ SELECT SM_CD ID_, SM_CFNM NAME_ FROM TBZ00_COMMCD WHERE LG_CD = 'F02003' ORDER BY CD_SEQ SELECT 'REEL计划号' TYPE_,MAX(ROLL_NO) CAPTION FROM S_TBF03_SCH_ROLL UNION SELECT '个数(个)' TYPE_,TO_CHAR(MAX(ROLL_COIL_SEQ)) CAPTION FROM S_TBF03_SCH_MILL UNION SELECT '重量(Ton)' TYPE_,TO_CHAR(MAX(COIL_WGT)) CAPTION FROM S_TBF03_SCH_MILL