'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE||'&' LIKE ? || '%' ]]> 'PCC' AND A.CUR_LOAD_LOC LIKE '1%' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND SUBSTR(A.ORD_NO, 1, 2) IN ('41', '51', '50', '40') AND A.TOT_DEC_GRD = '1' ) UNION ( SELECT A.OLD_SAMPL_NO ,A.STL_GRD SPEC_STL_GRD ,'False' CHK ,DECODE(A.CR_PLANT_TRS_CLF,'Z','常化','') CR_PLANT_TRS_CLF ,A.COIL_THK ,A.COIL_WTH ,C.ORD_THK INSTR_COIL_THK ,C.ORD_WTH INSTR_COIL_WTH ,A.ACT_WGT ,A.COIL_INDIA ,A.COIL_OUTDIA ,A.FM_EXT_STRIP_TEMP_AVG ,A.DC_TEMP_AVG ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01010' AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD ,F.DCS_THK ,F.DCS_WTH ,A.FB_YN ,A.FB_REASON ,F.SPM_RMK --质检备注 ,A.ORI_ACT_WGT ,F.CPCJ_REMARK --成品车间备注 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD1) CRK_CD1 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD2) CRK_CD2 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD3) CRK_CD3 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD4) CRK_CD4 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD5) CRK_CD5 ,DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL ,ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM ,A.ORG_ORD_NO ,A.ORG_ORD_SEQ ,A.ORD_NO ,E.ORD_THK H_ORD_THK ,E.ORD_WTH H_ORD_WTH ,E.ORD_INDIA H_ORD_INDIA ,E.ORD_OUTDIA H_ORD_OUTDIA ,A.ORD_SEQ ,A.CUR_LOAD_LOC ,A.LZREMARK LZBZ ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD ,DECODE(A.INGR_DEC_GRD,'0','综合判定取消', '1','合格','2','不合格') INGR_DEC_GRD ,DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD ,DECODE(A.SIZE_DEC_RST, '1', '合格', '2', '不合格') SIZE_DEC_RST ,DECODE(A.EXTSHAPE_DEC_GRD, '1','合格','2','订单外合格','3','次品', '4','废品') EXTSHAPE_DEC_GRD ,DECODE(A.WGT_DEC_RST, '1', '合格', '2', '不合格') WGT_DEC_RST ,A.YARD_ENTRY_DTIME ,A.YARD_ENTRY_USE_TIME ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班', '1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT ,DECODE(A.YARD_ENTRY_GROUP,'0', '常白班','1', '甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP ,SUBSTR(A.SLAB_NO, 0, 10) CHARGE_NO ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP ,(SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD ,DECODE(A.CUR_PROG_CD,'PRC','基料卷充当待机','PCA','酸轧作业指示待机','PCB','酸轧轧制待机','PCC','酸轧卷取待机') CUR_PROG_CD ,C.ORD_DEVLMT_DATE ,A.MILL_DTIME ,C.XSQY ,C.ORD_PLAN_DATA ,(SELECT T1.SPM_RMK FROM TBH02_COIL_COMM T1 WHERE T1.OLD_SAMPL_NO=A.OLD_SAMPL_NO AND ROWNUM=1) RZBZ ,(SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ ,A.SPEC_STL_GRD C_SPEC_STL_GRD ,A.BEF_STL_GRD BEF_SPEC_STL_GRD ,(SELECT C_COIL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') C_COIL_NO ,(SELECT ROLL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') ROLL_NO FROM C_TBK02_COIL_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBE02_ORD_PRC E ,TBH02_COIL_COMM F WHERE '1' = '1' AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) AND A.COIL_NO = F.OLD_SAMPL_NO(+) AND A.COIL_STAT = '2' AND A.CUR_LOAD_LOC LIKE '1%' AND A.CUR_PROG_CD <> 'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ?|| '%' AND A.CUR_PROG_CD || '&' LIKE ?|| '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND (A.ORD_NO LIKE 'XGEC%' OR A.ORD_NO LIKE 'W%') AND A.TOT_DEC_GRD = '1' ) ]]> 'PCC' AND A.OLD_SAMPL_NO LIKE ?||'%' AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.CUR_LOAD_LOC LIKE ?||'%' --20130131修改垛位不能为空 AND A.COIL_THK >= NVL(?,'000') AND A.COIL_THK <= NVL(?,'999') AND A.COIL_WTH >= NVL(?,'00000') AND A.COIL_WTH <= NVL(?,'99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,99999999999999),1,8) >= NVL(?,0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,0),1,8) <= NVL(?,99999999999999) AND A.ORD_NO||'&' LIKE ?||'%' AND A.CUR_PROG_CD||'&' LIKE ?||'%' AND C.ORD_DEVLMT_DATE||'&' LIKE ?||'%' AND SUBSTR(A.ORD_NO,1,2) IN ('42','43','47','52','53') AND A.TOT_DEC_GRD = '1' --"AND E.SMP_SEND_DTIME||'&' LIKE ?||'%' --"AND A.PRODNM_CD LIKE ?||'%' --AND A.ORD_FL||'&' LIKE ? || '%' ) UNION ALL (SELECT A.OLD_SAMPL_NO --,XB_PACKAGE.GF_COMNNAME_FIND('A01004' , A.PRODNM_CD) PRODNM_CD ,A.STL_GRD SPEC_STL_GRD ,'False' CHK ,DECODE(A.CR_PLANT_TRS_CLF,'Z','常化','') CR_PLANT_TRS_CLF ,A.LZREMARK LZBZ ,A.COIL_THK ,A.COIL_WTH ,C.ORD_THK INSTR_COIL_THK ,C.ORD_WTH INSTR_COIL_WTH ,A.ACT_WGT ,A.COIL_INDIA ,A.COIL_OUTDIA ,A.FM_EXT_STRIP_TEMP_AVG,A.DC_TEMP_AVG ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01010' AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD ,F.DCS_THK ,F.DCS_WTH ,A.FB_YN ,A.FB_REASON ,F.SPM_RMK --质检备注 ,A.ORI_ACT_WGT ,B.YC_MEMO ,B.YC_GSDW ,ROUND(TO_NUMBER(SYSDATE - TO_DATE(A.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS')) * 24) ZKSJ ,F.CPCJ_REMARK --成品车间备注 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD1) CRK_CD1 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD2) CRK_CD2 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD3) CRK_CD3 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD4) CRK_CD4 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD5) CRK_CD5 ,DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL ,ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM --冷却时长 ,A.ORG_ORD_NO ,A.ORG_ORD_SEQ ,A.ORD_NO ,E.ORD_THK H_ORD_THK ,E.ORD_WTH H_ORD_WTH ,E.ORD_INDIA H_ORD_INDIA ,E.ORD_OUTDIA H_ORD_OUTDIA ,A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD ,DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD ,DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD ,DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST ,DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD ,DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST ,A.YARD_ENTRY_DTIME ,A.YARD_ENTRY_USE_TIME,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT ,DECODE(A.YARD_ENTRY_GROUP,'0','常白班','1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP ,SUBSTR(A.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP ,(SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD ,DECODE(A.CUR_PROG_CD,'PRC','基料卷充当待机','PCA','酸轧作业指示待机','PCB','酸轧轧制待机','PCC','酸轧卷取待机') CUR_PROG_CD ,C.ORD_DEVLMT_DATE --"E.SMP_SEND_DTIME,E.SMP_WORK_DTIME,E.QLTY_DCS_DTIME --"E.SMP_INTO_DTIME,to_char(ROUND(((to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) GET_SEND_DTIME --"to_char(ROUND(((to_date(E.QLTY_DCS_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) TO_YANG_DTIME ,A.MILL_DTIME ,C.XSQY --,''||'/'||'' AFFIRMTIME ,C.ORD_PLAN_DATA ,(SELECT T1.SPM_RMK FROM TBH02_COIL_COMM T1 WHERE T1.OLD_SAMPL_NO=A.OLD_SAMPL_NO AND ROWNUM=1) RZBZ ,(SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ ,A.SPEC_STL_GRD C_SPEC_STL_GRD ,A.BEF_SPEC_STL_GRD ,(SELECT C_COIL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') C_COIL_NO ,(SELECT ROLL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') ROLL_NO FROM C_TBK02_COIL_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBE02_ORD_PRC E ,TBH02_COIL_COMM F ,JB_YC B --",TBB02_LOT_COM E WHERE '1' = '1' AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) --"AND A.SAMPL_NO = E.SMP_NO(+) AND A.COIL_NO = F.OLD_SAMPL_NO(+) AND A.OLD_SAMPL_NO = B.OLD_SAMPL_NO(+) AND A.COIL_STAT = '2' AND A.CUR_LOAD_LOC LIKE '1%' AND A.CUR_PROG_CD <> 'PCC' AND A.OLD_SAMPL_NO LIKE ?||'%' AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.CUR_LOAD_LOC LIKE ?||'%' --20130131修改垛位不能为空 AND A.COIL_THK >= NVL(?,'000') AND A.COIL_THK <= NVL(?,'999') AND A.COIL_WTH >= NVL(?,'00000') AND A.COIL_WTH <= NVL(?,'99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,99999999999999),1,8) >= NVL(?,0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,0),1,8) <= NVL(?,99999999999999) AND A.ORD_NO||'&' LIKE ?||'%' AND A.CUR_PROG_CD||'&' LIKE ?||'%' AND C.ORD_DEVLMT_DATE||'&' LIKE ?||'%' AND A.ORD_FL = '1' AND A.ORD_NO IS NOT NULL AND A.TOT_DEC_GRD = '2' --"AND E.SMP_SEND_DTIME||'&' LIKE ?||'%' --"AND A.PRODNM_CD LIKE ?||'%' --AND A.ORD_FL||'&' LIKE ? || '%' ) UNION ALL ( SELECT A.OLD_SAMPL_NO --,XB_PACKAGE.GF_COMNNAME_FIND('A01004' , A.PRODNM_CD) PRODNM_CD ,A.STL_GRD SPEC_STL_GRD ,'False' CHK ,DECODE(A.CR_PLANT_TRS_CLF,'Z','常化','') CR_PLANT_TRS_CLF ,A.LZREMARK LZBZ ,A.COIL_THK ,A.COIL_WTH ,C.ORD_THK INSTR_COIL_THK ,C.ORD_WTH INSTR_COIL_WTH ,A.ACT_WGT ,A.COIL_INDIA ,A.COIL_OUTDIA ,A.FM_EXT_STRIP_TEMP_AVG,A.DC_TEMP_AVG ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01010' AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD ,F.DCS_THK ,F.DCS_WTH ,A.FB_YN ,A.FB_REASON ,F.SPM_RMK --质检备注 ,A.ORI_ACT_WGT ,B.YC_MEMO ,B.YC_GSDW ,ROUND(TO_NUMBER(SYSDATE - TO_DATE(A.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS')) * 24) ZKSJ ,F.CPCJ_REMARK --成品车间备注 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD1) CRK_CD1 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD2) CRK_CD2 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD3) CRK_CD3 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD4) CRK_CD4 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD5) CRK_CD5 ,DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL ,ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM --冷却时长 ,A.ORG_ORD_NO ,A.ORG_ORD_SEQ ,A.ORD_NO ,E.ORD_THK H_ORD_THK ,E.ORD_WTH H_ORD_WTH ,E.ORD_INDIA H_ORD_INDIA ,E.ORD_OUTDIA H_ORD_OUTDIA ,A.ORD_SEQ ,A.CUR_LOAD_LOC ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD ,DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD ,DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD ,DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST ,DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD ,DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST ,A.YARD_ENTRY_DTIME ,A.YARD_ENTRY_USE_TIME,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT ,DECODE(A.YARD_ENTRY_GROUP,'0','常白班','1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP ,SUBSTR(A.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP ,(SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD ,DECODE(A.CUR_PROG_CD,'PRC','基料卷充当待机','PCA','酸轧作业指示待机','PCB','酸轧轧制待机','PCC','酸轧卷取待机') CUR_PROG_CD ,C.ORD_DEVLMT_DATE --"E.SMP_SEND_DTIME,E.SMP_WORK_DTIME,E.QLTY_DCS_DTIME --"E.SMP_INTO_DTIME,to_char(ROUND(((to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) GET_SEND_DTIME --"to_char(ROUND(((to_date(E.QLTY_DCS_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) TO_YANG_DTIME ,A.MILL_DTIME ,C.XSQY --,''||'/'||'' AFFIRMTIME ,C.ORD_PLAN_DATA ,(SELECT T1.SPM_RMK FROM TBH02_COIL_COMM T1 WHERE T1.OLD_SAMPL_NO=A.OLD_SAMPL_NO AND ROWNUM=1) RZBZ ,(SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ ,A.SPEC_STL_GRD C_SPEC_STL_GRD ,A.BEF_SPEC_STL_GRD ,(SELECT C_COIL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO and STATUS_CD = 'A') C_COIL_NO ,(SELECT ROLL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO and STATUS_CD = 'A') ROLL_NO FROM C_TBK02_COIL_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBE02_ORD_PRC E ,TBH02_COIL_COMM F ,JB_YC B --",TBB02_LOT_COM E WHERE '1' = '1' AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) --"AND A.SAMPL_NO = E.SMP_NO(+) AND A.COIL_NO = F.OLD_SAMPL_NO(+) AND A.OLD_SAMPL_NO = B.OLD_SAMPL_NO(+) AND A.COIL_STAT = '2' AND A.CUR_LOAD_LOC LIKE '1%' AND A.CUR_PROG_CD <> 'PCC' AND A.OLD_SAMPL_NO LIKE ?||'%' AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.CUR_LOAD_LOC LIKE ?||'%' --20130131修改垛位不能为空 AND A.COIL_THK >= NVL(?,'000') AND A.COIL_THK <= NVL(?,'999') AND A.COIL_WTH >= NVL(?,'00000') AND A.COIL_WTH <= NVL(?,'99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,99999999999999),1,8) >= NVL(?,0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,0),1,8) <= NVL(?,99999999999999) AND A.ORD_NO||'&' LIKE ?||'%' AND A.CUR_PROG_CD||'&' LIKE ?||'%' AND C.ORD_DEVLMT_DATE||'&' LIKE ?||'%' AND A.ORD_FL = '1' AND A.ORD_NO IS NOT NULL AND A.TOT_DEC_GRD IS NULL --"AND E.SMP_SEND_DTIME||'&' LIKE ?||'%' --"AND A.PRODNM_CD LIKE ?||'%' --AND A.ORD_FL||'&' LIKE ? || '%' ) ]]> 'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND A.ORD_FL = '2' ]]> 'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE||'&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' ]]> 'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND SUBSTR(A.ORD_NO, 1, 2) IN ('41', '51', '50', '40') AND A.TOT_DEC_GRD = '1' AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' ) UNION ( SELECT A.OLD_SAMPL_NO ,A.STL_GRD SPEC_STL_GRD ,'False' CHK ,A.COIL_THK ,A.COIL_WTH ,C.ORD_THK INSTR_COIL_THK ,C.ORD_WTH INSTR_COIL_WTH ,A.ACT_WGT ,A.COIL_INDIA ,A.COIL_OUTDIA ,A.FM_EXT_STRIP_TEMP_AVG ,A.DC_TEMP_AVG ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01010' AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD ,F.DCS_THK ,F.DCS_WTH ,A.FB_YN ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD1) CRK_CD1 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD2) CRK_CD2 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD3) CRK_CD3 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD4) CRK_CD4 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD = 'H02001' AND WQ.SM_CD = A.CRK_CD5) CRK_CD5 ,DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL ,ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM ,A.ORG_ORD_NO ,A.ORG_ORD_SEQ ,A.ORD_NO ,E.ORD_THK H_ORD_THK ,E.ORD_WTH H_ORD_WTH ,E.ORD_INDIA H_ORD_INDIA ,E.ORD_OUTDIA H_ORD_OUTDIA ,A.ORD_SEQ ,A.CUR_LOAD_LOC ,A.LZREMARK LZBZ ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD ,DECODE(A.INGR_DEC_GRD,'0','综合判定取消', '1','合格','2','不合格') INGR_DEC_GRD ,DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD ,DECODE(A.SIZE_DEC_RST, '1', '合格', '2', '不合格') SIZE_DEC_RST ,DECODE(A.EXTSHAPE_DEC_GRD, '1','合格','2','订单外合格','3','次品', '4','废品') EXTSHAPE_DEC_GRD ,DECODE(A.WGT_DEC_RST, '1', '合格', '2', '不合格') WGT_DEC_RST ,A.YARD_ENTRY_DTIME ,A.YARD_ENTRY_USE_TIME ,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班', '1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT ,DECODE(A.YARD_ENTRY_GROUP,'0', '常白班','1', '甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP ,SUBSTR(A.SLAB_NO, 0, 10) CHARGE_NO ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP ,(SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD ,DECODE(A.CUR_PROG_CD,'PRC','基料卷充当待机','PCA','酸洗作业指示待机','PCB','酸洗轧制待机','PCC','酸洗卷取待机') CUR_PROG_CD ,C.ORD_DEVLMT_DATE ,A.MILL_DTIME ,C.XSQY ,C.ORD_PLAN_DATA ,(SELECT T1.SPM_RMK FROM TBH02_COIL_COMM T1 WHERE T1.OLD_SAMPL_NO=A.OLD_SAMPL_NO AND ROWNUM=1) RZBZ ,(SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ ,A.SPEC_STL_GRD C_SPEC_STL_GRD ,A.BEF_STL_GRD BEF_SPEC_STL_GRD ,(SELECT C_COIL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') C_COIL_NO ,(SELECT ROLL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') ROLL_NO FROM C_TBK02_COIL_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBE02_ORD_PRC E ,TBH02_COIL_COMM F WHERE '1' = '1' AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) AND A.COIL_NO = F.OLD_SAMPL_NO(+) AND A.COIL_STAT = '2' AND A.CUR_PROG_CD <> 'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ?|| '%' AND A.CUR_PROG_CD || '&' LIKE ?|| '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND (A.ORD_NO LIKE 'XGEC%' OR A.ORD_NO LIKE 'W%') AND A.TOT_DEC_GRD = '1' AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' ) ]]> 'PCC' AND A.OLD_SAMPL_NO LIKE ?||'%' AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.CUR_LOAD_LOC LIKE ?||'%' --20130131修改垛位不能为空 AND A.COIL_THK >= NVL(?,'000') AND A.COIL_THK <= NVL(?,'999') AND A.COIL_WTH >= NVL(?,'00000') AND A.COIL_WTH <= NVL(?,'99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,99999999999999),1,8) >= NVL(?,0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,0),1,8) <= NVL(?,99999999999999) AND A.ORD_NO||'&' LIKE ?||'%' AND A.CUR_PROG_CD||'&' LIKE ?||'%' AND C.ORD_DEVLMT_DATE||'&' LIKE ?||'%' AND SUBSTR(A.ORD_NO,1,2) IN ('42','43','47','52','53') AND A.TOT_DEC_GRD = '1' AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' --"AND E.SMP_SEND_DTIME||'&' LIKE ?||'%' --"AND A.PRODNM_CD LIKE ?||'%' --AND A.ORD_FL||'&' LIKE ? || '%' ) UNION ALL (SELECT A.OLD_SAMPL_NO --,XB_PACKAGE.GF_COMNNAME_FIND('A01004' , A.PRODNM_CD) PRODNM_CD ,A.STL_GRD SPEC_STL_GRD ,'False' CHK ,A.LZREMARK LZBZ ,A.COIL_THK ,A.COIL_WTH ,C.ORD_THK INSTR_COIL_THK ,C.ORD_WTH INSTR_COIL_WTH ,A.ACT_WGT ,A.COIL_INDIA ,A.COIL_OUTDIA ,A.FM_EXT_STRIP_TEMP_AVG,A.DC_TEMP_AVG ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01010' AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD ,F.DCS_THK ,F.DCS_WTH ,A.FB_YN ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD1) CRK_CD1 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD2) CRK_CD2 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD3) CRK_CD3 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD4) CRK_CD4 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD5) CRK_CD5 ,DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL ,ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM --冷却时长 ,A.ORG_ORD_NO ,A.ORG_ORD_SEQ ,A.ORD_NO ,E.ORD_THK H_ORD_THK ,E.ORD_WTH H_ORD_WTH ,E.ORD_INDIA H_ORD_INDIA ,E.ORD_OUTDIA H_ORD_OUTDIA ,A.ORD_SEQ,A.CUR_LOAD_LOC,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD ,DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD ,DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD ,DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST ,DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD ,DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST ,A.YARD_ENTRY_DTIME ,A.YARD_ENTRY_USE_TIME,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT ,DECODE(A.YARD_ENTRY_GROUP,'0','常白班','1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP ,SUBSTR(A.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP ,(SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD ,DECODE(A.CUR_PROG_CD,'PRC','基料卷充当待机','PCA','酸洗作业指示待机','PCB','酸洗轧制待机','PCC','酸洗卷取待机') CUR_PROG_CD ,C.ORD_DEVLMT_DATE --"E.SMP_SEND_DTIME,E.SMP_WORK_DTIME,E.QLTY_DCS_DTIME --"E.SMP_INTO_DTIME,to_char(ROUND(((to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) GET_SEND_DTIME --"to_char(ROUND(((to_date(E.QLTY_DCS_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) TO_YANG_DTIME ,A.MILL_DTIME ,C.XSQY --,''||'/'||'' AFFIRMTIME ,C.ORD_PLAN_DATA ,(SELECT T1.SPM_RMK FROM TBH02_COIL_COMM T1 WHERE T1.OLD_SAMPL_NO=A.OLD_SAMPL_NO AND ROWNUM=1) RZBZ ,(SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ ,A.SPEC_STL_GRD C_SPEC_STL_GRD ,A.BEF_SPEC_STL_GRD ,(SELECT C_COIL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') C_COIL_NO ,(SELECT ROLL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO AND STATUS_CD = 'A') ROLL_NO FROM C_TBK02_COIL_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBE02_ORD_PRC E ,TBH02_COIL_COMM F --",TBB02_LOT_COM E WHERE '1' = '1' AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) --"AND A.SAMPL_NO = E.SMP_NO(+) AND A.COIL_NO = F.OLD_SAMPL_NO(+) AND A.COIL_STAT = '2' AND A.CUR_PROG_CD <> 'PCC' AND A.OLD_SAMPL_NO LIKE ?||'%' AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.CUR_LOAD_LOC LIKE ?||'%' --20130131修改垛位不能为空 AND A.COIL_THK >= NVL(?,'000') AND A.COIL_THK <= NVL(?,'999') AND A.COIL_WTH >= NVL(?,'00000') AND A.COIL_WTH <= NVL(?,'99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,99999999999999),1,8) >= NVL(?,0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,0),1,8) <= NVL(?,99999999999999) AND A.ORD_NO||'&' LIKE ?||'%' AND A.CUR_PROG_CD||'&' LIKE ?||'%' AND C.ORD_DEVLMT_DATE||'&' LIKE ?||'%' AND A.ORD_FL = '1' AND A.ORD_NO IS NOT NULL AND A.TOT_DEC_GRD = '2' --"AND E.SMP_SEND_DTIME||'&' LIKE ?||'%' --"AND A.PRODNM_CD LIKE ?||'%' --AND A.ORD_FL||'&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' ) UNION ALL ( SELECT A.OLD_SAMPL_NO --,XB_PACKAGE.GF_COMNNAME_FIND('A01004' , A.PRODNM_CD) PRODNM_CD ,A.STL_GRD SPEC_STL_GRD ,'False' CHK ,A.LZREMARK LZBZ ,A.COIL_THK ,A.COIL_WTH ,C.ORD_THK INSTR_COIL_THK ,C.ORD_WTH INSTR_COIL_WTH ,A.ACT_WGT ,A.COIL_INDIA ,A.COIL_OUTDIA ,A.FM_EXT_STRIP_TEMP_AVG,A.DC_TEMP_AVG ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01010' AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD ,F.DCS_THK ,F.DCS_WTH ,A.FB_YN ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD1) CRK_CD1 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD2) CRK_CD2 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD3) CRK_CD3 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD4) CRK_CD4 ,(SELECT SM_CFNM FROM TBZ00_COMMCD WQ WHERE LG_CD='H02001' AND WQ.SM_CD = A.CRK_CD5) CRK_CD5 ,DECODE(A.ORD_FL,'1','订单材','2','余材','','未判') ORD_FL ,ROUND(SYSDATE-TO_DATE(A.MILL_DTIME,'YYYY-MM-DD HH24:MI:SS'),1) COLDTIM --冷却时长 ,A.ORG_ORD_NO ,A.ORG_ORD_SEQ ,A.ORD_NO ,E.ORD_THK H_ORD_THK ,E.ORD_WTH H_ORD_WTH ,E.ORD_INDIA H_ORD_INDIA ,E.ORD_OUTDIA H_ORD_OUTDIA ,A.ORD_SEQ ,A.CUR_LOAD_LOC ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD ,DECODE(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD ,DECODE(A.MATLQLTY_DEC_GRD,'0','无性能要求','1','合格','2','不合格') MATRL_END_CAUSE_CD ,DECODE(A.SIZE_DEC_RST,'1','合格','2','不合格') SIZE_DEC_RST ,DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD ,DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST ,A.YARD_ENTRY_DTIME ,A.YARD_ENTRY_USE_TIME,(SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG ,DECODE(A.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT ,DECODE(A.YARD_ENTRY_GROUP,'0','常白班','1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP ,SUBSTR(A.SLAB_NO,0,10) CHARGE_NO,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01012' AND T.SM_CD = C.DLIV_TP) DLIV_TP ,(SELECT T.CUST_NM FROM TBZ00_CUSTOMER T WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD ,DECODE(A.CUR_PROG_CD,'PRC','基料卷充当待机','PCA','酸洗作业指示待机','PCB','酸洗轧制待机','PCC','酸洗卷取待机') CUR_PROG_CD ,C.ORD_DEVLMT_DATE --"E.SMP_SEND_DTIME,E.SMP_WORK_DTIME,E.QLTY_DCS_DTIME --"E.SMP_INTO_DTIME,to_char(ROUND(((to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(A.MILL_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) GET_SEND_DTIME --"to_char(ROUND(((to_date(E.QLTY_DCS_DTIME,'yyyy-mm-dd hh24:mi:ss')-to_date(E.SMP_SEND_DTIME,'yyyy-mm-dd hh24:mi:ss'))*86400)/3600,1)) TO_YANG_DTIME ,A.MILL_DTIME ,C.XSQY --,''||'/'||'' AFFIRMTIME ,C.ORD_PLAN_DATA ,(SELECT T1.SPM_RMK FROM TBH02_COIL_COMM T1 WHERE T1.OLD_SAMPL_NO=A.OLD_SAMPL_NO AND ROWNUM=1) RZBZ ,(SELECT T1.SLAB_DCS_DETAIL FROM TBG02_SLAB_COMM T1 WHERE T1.SLAB_NO=A.SLAB_NO AND ROWNUM=1) BPBZ ,A.SPEC_STL_GRD C_SPEC_STL_GRD ,A.BEF_SPEC_STL_GRD ,(SELECT C_COIL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO and STATUS_CD = 'A') C_COIL_NO ,(SELECT ROLL_NO FROM C_TBF03_SPEC_MILL Q WHERE Q.COIL_NO = A.COIL_NO and STATUS_CD = 'A') ROLL_NO FROM C_TBK02_COIL_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBE02_ORD_PRC E ,TBH02_COIL_COMM F --",TBB02_LOT_COM E WHERE '1' = '1' AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = E.ORD_NO(+) AND A.ORD_SEQ = E.ORD_SEQ(+) --"AND A.SAMPL_NO = E.SMP_NO(+) AND A.COIL_NO = F.OLD_SAMPL_NO(+) AND A.COIL_STAT = '2' AND A.CUR_PROG_CD <> 'PCC' AND A.OLD_SAMPL_NO LIKE ?||'%' AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.CUR_LOAD_LOC LIKE ?||'%' --20130131修改垛位不能为空 AND A.COIL_THK >= NVL(?,'000') AND A.COIL_THK <= NVL(?,'999') AND A.COIL_WTH >= NVL(?,'00000') AND A.COIL_WTH <= NVL(?,'99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,99999999999999),1,8) >= NVL(?,0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME,0),1,8) <= NVL(?,99999999999999) AND A.ORD_NO||'&' LIKE ?||'%' AND A.CUR_PROG_CD||'&' LIKE ?||'%' AND C.ORD_DEVLMT_DATE||'&' LIKE ?||'%' AND A.ORD_FL = '1' AND A.ORD_NO IS NOT NULL AND A.TOT_DEC_GRD IS NULL AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' --"AND E.SMP_SEND_DTIME||'&' LIKE ?||'%' --"AND A.PRODNM_CD LIKE ?||'%' --AND A.ORD_FL||'&' LIKE ? || '%' ) ]]> 'PCC' AND A.OLD_SAMPL_NO LIKE ? || '%' AND A.SPEC_STL_GRD || '&' LIKE ? || '%' AND A.CUR_LOAD_LOC LIKE ? || '%' AND A.COIL_THK >= NVL(?, '000') AND A.COIL_THK <= NVL(?, '999') AND A.COIL_WTH >= NVL(?, '00000') AND A.COIL_WTH <= NVL(?, '99999') AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0) AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999) AND A.ORD_NO || '&' LIKE ? || '%' AND A.CUR_PROG_CD || '&' LIKE ? || '%' AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%' AND A.ORD_FL = '2' AND A.CUR_LOAD_LOC LIKE '6%' AND SUBSTR(A.OLD_SAMPL_NO,1,1) LIKE ?||'%' ]]>