XinYu_RZMES/.svn/pristine/04/043cbb5cd82bbe32d11f91a032d09c20d43e6a28.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH052400_01.select" desc="冷轧转运量查询-订单材">
        <![CDATA[
			SELECT 'N' CHK,H.CUR_PROG_CD, H.OLD_SAMPL_NO,H.STL_GRD,H.ORD_NO,H.ORD_SEQ,H.COIL_WTH,
     		 H.COIL_THK,H.COIL_LEN,H.ACT_WGT,H.CUR_LOAD_LOC,H.CR_PLANT_TRS_SEQ,H.COIL_NO
			,DECODE(H.CUR_PROG_CD,'SGB','移送待机','SFA','发货指示待机','SED','综合判定待机','SRC','充当待机') CUR_PROG_CD_NM
			,H.CUR_PROG_CD
			 ,SUBSTR(H.SLAB_NO,1,10) CHARGE_NO,H.INSTR_COIL_THK,H.INSTR_COIL_WTH
			,H.COIL_INDIA,H.COIL_OUTDIA,decode(H.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD
			  FROM TBH02_COIL_COMM H,TBA01_ORD_LINE A WHERE 
			  A.ORD_NO = H.ORD_NO
			  AND A.ORD_SEQ = H.ORD_SEQ
			  AND H.COIL_STAT = '2'
			  AND H.EXTSHAPE_DEC_GRD = '1'
			  AND H.SIZE_DEC_RST = '1'
			  AND NVL (H.FB_YN, 'N') = 'N' --封闭卷无法移送 20200720
			  AND nvl(A.RZHQX,'N')<>'Z'  --常化卷屏蔽  20220909
			  AND ((A.PROD_LINE IN ('C','L')
			  AND H.CUR_PROG_CD = 'SGB')
			  OR (H.CUR_PROG_CD in ('SED') AND SUBSTR(H.ORD_NO,0,1) IN ('4','5')) 
			  OR (SUBSTR(H.ORD_NO, 0, 2) IN ('W4', 'W5')) OR
       			(SUBSTR(H.ORD_NO, 0, 6) IN ('XGEC-L')))
			  AND H.ORD_NO||'&' like ? || '%'
			  AND H.ORD_SEQ||'&' like ? || '%'
			  AND H.OLD_SAMPL_NO||'&' LIKE ? || '%'
		]]>
    </query>
	<query id="UIH052400_11.select" desc="冷轧转运量查询-余材">
        <![CDATA[
			SELECT 'N' CHK,H.CUR_PROG_CD, H.OLD_SAMPL_NO,H.STL_GRD,H.ORD_NO,H.ORD_SEQ,H.COIL_WTH,
			H.COIL_THK,H.COIL_LEN,H.ACT_WGT,H.CUR_LOAD_LOC,H.CR_PLANT_TRS_SEQ,H.COIL_NO
			,DECODE(H.CUR_PROG_CD,'SGB','移送待机','SFA','发货指示待机','SED','综合判定待机','SRC','充当待机') CUR_PROG_CD_NM
			,SUBSTR(H.SLAB_NO,1,10) CHARGE_NO,H.INSTR_COIL_THK,H.INSTR_COIL_WTH
			,H.COIL_INDIA,H.COIL_OUTDIA,decode(H.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD
			FROM TBH02_COIL_COMM H WHERE 
			H.COIL_STAT = '2'
			AND H.CUR_PROG_CD = 'SRC'
			 AND NVL (H.FB_YN, 'N') = 'N' --封闭卷无法移送 20200720
			AND H.OLD_SAMPL_NO||'&' LIKE ?||'%'
		]]>
    </query>
	<query id="UIH052400_02.select" desc="查询冷轧原料库是否已经存在转运的钢卷信息">
		<![CDATA[
			SELECT COUNT(1) COUNT FROM C_TBK02_COIL_COMM WHERE COIL_NO = ?
		]]>
	</query>
	<query id="UIH052400_03.select" desc="查询热轧卷订单信息">
		<![CDATA[
			SELECT ORD_NO FROM TBH02_COIL_COMM WHERE OLD_SAMPL_NO = ?
		]]>
	</query>
	<query id="UIH052400_04.select" desc="冷轧移送实绩查询">
		<![CDATA[
			select 'N' CHK, h.old_sampl_no,h.SPEC_STL_GRD stl_grd,h.ord_no,h.ord_seq,
			 h.coil_wth,h.coil_thk,h.coil_len,h.act_wgt,
			 DECODE(h.cr_plant_trs_clf,'B','冷轧厂','C','其他转运') cr_plant_trs_clf,
			 h.cr_plant_trs_no,H.CR_PLANT_TRS_SEQ cr_plant_trs_cd,h.cur_load_loc,
			 TO_CHAR(TO_DATE(h.cr_plant_trs_dtime,'YYYYMMDD'),'YYYY-MM-DD') AS cr_plant_trs_dtime,
			 k.YARD_ENTRY_REG receive_reg,
			 TO_CHAR(TO_DATE(k.YARD_ENTRY_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS receive_time,
			 k.trnf_reg,TO_CHAR(TO_DATE(k.trnf_dtime,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS trnf_dtime
			 from tbh02_coil_comm h,c_tbk02_coil_comm k where h.old_sampl_no = k.coil_no(+)
			 and h.coil_stat = '3' and h.cur_prog_cd = 'SGF' and (k.coil_stat = '1' or (k.coil_stat = 3 and k.out_yard_kind = 2))
			 and h.cr_plant_trs_dtime like '%'||trim(?)||'%'
			 and h.cr_plant_trs_no like '%'||trim(?)||'%' order by h.cr_plant_trs_dtime desc,H.CR_PLANT_TRS_SEQ desc
		]]>
	</query>
	<query id="UIH052400_05.select" desc="判断c_tbk02_coil_comm_d是否存在冷轧订单信息">
		 <![CDATA[
			select coil_no from c_tbk02_coil_comm_d where coil_no = ?
			 ]]>
	</query>
	
	<query id="UIH052400_09.select" desc="判断c_tbk02_coil_comm_d是否存cut信息">
		 <![CDATA[
			select d.CUT_SEQ
		     from tbh02_coil_comm_d d,tbh02_coil_comm h
		    where d.coil_no = h.coil_no
		      and h.old_sampl_no = ?
			 ]]>
	</query>
	
	<query id="UIH052400_06.select" desc="查询冷轧订单信息">
		<![CDATA[
			select d.c_ord_thk ord_thk
			,d.c_ord_wth ord_wth,d.c_ord_len ord_len
			,d.c_ord_wgt ord_wgt,d.c_ord_wgt_min ord_wgt_min
			,d.c_ord_wgt_max ord_wgt_max,d.c_ord_india ord_india
			,d.c_ord_outdia ord_outdia,d.ord_no ord_no
			,d.ord_seq ord_seq,d.ord_fl ord_fl
			from tbh02_coil_comm_d d 
			where d.coil_no = (
			select coil_no from tbh02_coil_comm where 
			old_sampl_no = ?
			)
			]]>
	</query>
	<query id="UIH052400_07.select" desc="查询原料库钢卷信息">
		<![CDATA[
			SELECT H.SLAB_NO,H.CUR_PROG_CD,H.CUR_PROG_CD_DTIME,H.CUR_PROG_CD_PGM,H.INSTR_COIL_THK
			,H.INSTR_COIL_WTH,H.INSTR_COIL_LEN,H.INSTR_COIL_INDIA,H.INSTR_COIL_OUTDIA,H.INSTR_COIL_WGT
			,H.DEVLMT_DTIME,H.DEST_CD,H.ORDCUST_CD,H.CUST_CD,H.COIL_LEN,H.COIL_INDIA
			--,(CASE WHEN(H.COIL_OUTDIA IS NOT NULL OR H.COIL_OUTDIA <> '' or H.COIL_OUTDIA <> 0)THEN H.COIL_OUTDIA ELSE C_PKG_UIF.F_FUN_GET_OUTSIDE(H.COIL_INDIA,H.ACT_WGT,H.COIL_WTH)end) COIL_OUTDIA
			,H.COIL_OUTDIA
			,H.COIL_THK,H.COIL_WTH,H.ACT_WGT,H.ORD_FL,H.ORD_NO,H.ORD_SEQ,P.C_PRODNM_CD PRODNM_CD,H.SPEC_ABBSYM
			,P.C_SPEC_STL_GRD SPEC_STL_GRD,H.ORD_USE_CD,H.SPEC_STL_GRD STL_GRD,H.PATH_MILL_CD,H.INGR_DEC_GRD,H.EXTSHAPE_DEC_GRD
			,H.SIZE_DEC_RST,H.WGT_DEC_RST,H.PROC_DEC_RST,H.MATLQLTY_DEC_GRD,H.TOT_DEC_GRD,H.MILL_DTIME
			,H.CRK_CD1,H.CRK_CD2,H.CRK_CD3,H.CRK_CD4,H.CRK_CD5,H.CAL_WGT,H.OLD_SAMPL_NO
			,H.YARD_ENTRY_DTIME
			,H.SAMPL_NO,H.SAMPL_CUT_LOC
			,R.FM_EXT_STRIP_THK_AVG ,R.FM_EXT_STRIP_TEMP_AVG,R.DC_TEMP_AVG,R.FM_EXT_STRIP_CROWN_AVG
            FROM TBH02_COIL_COMM H,TBH02_MILL_RESULT R,TBE02_ORD_PRC P
            WHERE H.COIL_NO = R.COIL_NO AND H.ORD_NO = P.ORD_NO(+) AND H.ORD_SEQ = P.ORD_SEQ(+)
            AND H.OLD_SAMPL_NO = ?
			]]>
	</query>
	<query id="UIH052400_01.insert" desc="冷轧原料钢卷基础信息插入">
		<![CDATA[
			INSERT INTO C_TBK02_COIL_COMM
  (COIL_NO,
   SLAB_NO,
   COIL_STAT,
   CUR_PROG_CD,
   CUR_PROG_CD_DTIME,
   CUR_PROG_CD_PGM,
   BEF_PROG_CD,
   BEF_PROG_CD_DTIME,
   BEF_PROG_CD_PGM,
   INSTR_COIL_THK,
   INSTR_COIL_WTH,
   INSTR_COIL_LEN,
   INSTR_COIL_INDIA,
   INSTR_COIL_OUTDIA,
   INSTR_COIL_WGT,
   DEVLMT_DTIME,
   DEST_CD,
   ORDCUST_CD,
   CUST_CD,
   COIL_LEN,
   COIL_INDIA,
   COIL_OUTDIA,
   COIL_THK,
   COIL_WTH,
   ACT_WGT,
   ORD_FL,
   ORD_NO,
   ORD_SEQ,
   PRODNM_CD,
   SPEC_ABBSYM,
   SPEC_STL_GRD,
   ORD_USE_CD,
   STL_GRD,
   PATH_MILL_CD,
   INGR_DEC_GRD,
   EXTSHAPE_DEC_GRD,
   SIZE_DEC_RST,
   WGT_DEC_RST,
   PROC_DEC_RST,
   MATLQLTY_DEC_GRD,
   TOT_DEC_GRD,
   MILL_DTIME,
   CRK_CD1,
   CRK_CD2,
   CRK_CD3,
   CRK_CD4,
   CRK_CD5,
   CAL_WGT,
   OLD_SAMPL_NO,
   CR_PLANT_TRS_CLF,
   CR_PLANT_TRS_NO,
   CR_PLANT_TRS_DTIME,
   FM_EXT_STRIP_THK_AVG,
   FM_EXT_STRIP_TEMP_AVG,
   DC_TEMP_AVG,
   FM_EXT_STRIP_CROWN_AVG,
   RECEIVE_TIME,
   SMP_NO,
   SMP_CUT_LOC,
   OLD_ORD_NO,
   OLD_ORD_SEQ,
   OLD_ORD_FL,
   CR_PLANT_TRS_SEQ,
   BEF_STL_GRD)
  SELECT H.OLD_SAMPL_NO COIL_NO,
         H.SLAB_NO,
         '1' COIL_STAT,
         'PAB' CUR_PROG_CD,
         TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') CUR_PROG_CD_DTIME,
         'UIH052400' CUR_PROG_CD_PGM,
         CUR_PROG_CD BEF_PROG_CD,
         CUR_PROG_CD_DTIME BEF_PROG_CD_DTIME,
         CUR_PROG_CD_PGM BEF_PROG_CD_PGM,
         H.INSTR_COIL_THK,
         H.INSTR_COIL_WTH,
         H.INSTR_COIL_LEN,
         H.INSTR_COIL_INDIA,
         H.INSTR_COIL_OUTDIA,
         H.INSTR_COIL_WGT,
         H.DEVLMT_DTIME,
         H.DEST_CD,
         H.ORDCUST_CD,
         H.CUST_CD,
         H.COIL_LEN,
         H.COIL_INDIA
         --,(CASE WHEN(H.COIL_OUTDIA IS NOT NULL OR H.COIL_OUTDIA <> '' or H.COIL_OUTDIA <> 0)THEN H.COIL_OUTDIA ELSE C_PKG_UIF.F_FUN_GET_OUTSIDE(H.COIL_INDIA,H.ACT_WGT,H.COIL_WTH)end) COIL_OUTDIA
        ,
         H.COIL_OUTDIA,
         H.COIL_THK,
         H.COIL_WTH,
         H.ACT_WGT,
         H.ORD_FL,
         H.ORD_NO,
         H.ORD_SEQ,
         P.C_PRODNM_CD            PRODNM_CD,
         H.SPEC_ABBSYM,
         P.C_SPEC_STL_GRD         SPEC_STL_GRD,
         H.ORD_USE_CD,
         H.SPEC_STL_GRD           STL_GRD,
         H.PATH_MILL_CD,
         H.INGR_DEC_GRD,
         H.EXTSHAPE_DEC_GRD,
         H.SIZE_DEC_RST,
         H.WGT_DEC_RST,
         H.PROC_DEC_RST,
         H.MATLQLTY_DEC_GRD,
         H.TOT_DEC_GRD,
         H.MILL_DTIME,
         H.CRK_CD1,
         H.CRK_CD2,
         H.CRK_CD3,
         H.CRK_CD4,
         H.CRK_CD5,
         H.CAL_WGT,
         H.OLD_SAMPL_NO,
         ?                        CR_PLANT_TRS_CLF,
         ?                        CR_PLANT_TRS_NO,
         ?                        CR_PLANT_TRS_DTIME,
         R.FM_EXT_STRIP_THK_AVG,
         R.FM_EXT_STRIP_TEMP_AVG,
         R.DC_TEMP_AVG,
         R.FM_EXT_STRIP_CROWN_AVG,
         H.MILL_DTIME,
         H.SAMPL_NO,
         H.SAMPL_CUT_LOC,
         H.ORD_NO,
         H.ORD_SEQ,
         H.ORD_FL,
         ?                        CR_PLANT_TRS_SEQ,
         H.SPEC_STL_GRD           BEF_STL_GRD
    FROM TBH02_COIL_COMM H, TBH02_MILL_RESULT R, TBE02_ORD_PRC P
   WHERE H.COIL_NO = R.COIL_NO
     AND H.ORD_NO = P.ORD_NO(+)
     AND H.ORD_SEQ = P.ORD_SEQ(+)
     AND H.COIL_NO =
         (SELECT COIL_NO FROM TBH02_COIL_COMM WHERE OLD_SAMPL_NO = ?)

		]]>
	</query>
	<query id="UIH052400_02.insert" desc="插入c_tbk02_comm_d">
		<![CDATA[
			insert into c_tbk02_coil_comm_d
			(coil_no,cut_seq,ord_thk
			,ord_wth,ord_len,ord_wgt,ord_wgt_min,ord_wgt_max
			  ,ord_india,ord_outdia,ord_no,ord_seq,ord_fl)
			select h.old_sampl_no coil_no,d.cut_seq cut_seq,d.c_ord_thk ord_thk
			,d.c_ord_wth ord_wth,d.c_ord_len ord_len
			,d.ord_wgt ord_wgt,d.ord_wgt_min ord_wgt_min
			,d.ord_wgt_max ord_wgt_max,d.c_ord_india ord_india
			,d.c_ord_outdia ord_outdia,d.ord_no ord_no
			,d.ord_seq ord_seq,d.ord_fl ord_fl
			from tbh02_coil_comm_d d
			,tbh02_coil_comm h
			where d.coil_no = h.coil_no
			and h.old_sampl_no = ?
			]]>
	</query>
	<query id="UIH052400_03.insert" desc="新增移送记录">
		<![CDATA[
			insert into tbh02_coil_trans t 
			(
			t.TRANS_NO,t.COIL_NO,t.TRANS_FLAG,t.YARD_ADDR
			,t.REG_ID,t.REG_ORDER,t.REG_GROUP,t.REG_DTIME,t.REG_USER_TIME
			,t.cr_plant_trs_clf,t.cr_plant_trs_no,t.cr_plant_trs_seq
			)
			values
			(
			 (select nvl(max(t1.TRANS_NO),0)+1 from tbh02_coil_trans t1) 
			 ,?,'0',(select max(h.BEF_LOAD_LOC) from tbh02_coil_comm h where h.OLD_SAMPL_NO = ?)
			 ,?,?,?,?,to_char(sysdate,'YYYYMMDDHH24MISS')
			 ,?,?,?
			)
			]]>
	</query>
	<query id="UIH052400_04.insert" desc="新增退回记录">
		<![CDATA[
			insert into tbh02_coil_trans t 
			(
			t.TRANS_NO,t.COIL_NO,t.TRANS_FLAG,t.YARD_ADDR
			,t.REG_ID,t.REG_ORDER,t.REG_GROUP,t.REG_DTIME,t.REG_USER_TIME
			)
			values
			(
			 (select nvl(max(t1.TRANS_NO),0)+1 from tbh02_coil_trans t1) 
			 ,?,'1',?
			 ,?,?,?,?,to_char(sysdate,'YYYYMMDDHH24MISS')
			)
			]]>
	</query>
	<query id="UIH052400_05.insert" desc="插入步进梁接口表">
		<![CDATA[
			INSERT INTO TBS02_L3_IC_TAKE_COIL I(
			SEQ_NO                 --记录顺序号
			,COIL_NO               --钢卷号
			,WB_NO                 --步进梁编号
			,SADDLE_NO             --鞍座号
			,DIRECT                --方向
			,PROC_NAME             --进程名称
			)
			VALUES(?,?,nvl(?,'4'),nvl(?,'1'),'0','UIH052400')
			]]>
	</query>
	<query id="UIH052400_01.update" desc="c_tbk02_comm_d订单信息修改">
		<![CDATA[
			update c_tbk02_coil_comm_d d set
			 d.ord_thk = ?
			,d.ord_wth = ?
			,d.ord_len = ?
			,d.ord_wgt = ?
			,d.ord_wgt_min = ?
			,d.ord_wgt_max = ?
			,d.ord_india = ?
			,d.ord_outdia = ?
			,d.ord_no = ?
			,d.ord_seq = ?
			,d.ord_fl = ? 
			where d.coil_no = ?
			AND   d.CUT_SEQ = ?
		]]>
	</query>
	<query id="UIH052400_02.update" desc="原料公共表转运更新">
		<![CDATA[
			UPDATE C_TBK02_COIL_COMM K set K.SLAB_NO = ?,K.COIL_STAT = '1',K.CUR_PROG_CD ='PAB'
			,K.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),K.CUR_PROG_CD_PGM = 'UIH052400'
			,K.BEF_PROG_CD = ?,K.BEF_PROG_CD_DTIME= ?,K.BEF_PROG_CD_PGM= ?
			,K.INSTR_COIL_THK = ?,K.INSTR_COIL_WTH = ?,K.INSTR_COIL_LEN = ?
			,K.INSTR_COIL_INDIA = ?,K.INSTR_COIL_OUTDIA = ?,K.INSTR_COIL_WGT = ?
			,K.DEVLMT_DTIME = ?,K.DEST_CD = ?,K.ORDCUST_CD = ?,K.CUST_CD = ?
			,K.COIL_LEN = ?,K.COIL_INDIA = ?,K.COIL_OUTDIA = ?,K.COIL_THK = ?,
			K.COIL_WTH = ?,K.ACT_WGT = ?,K.ORD_FL = ?,K.ORD_NO = ?,K.ORD_SEQ = ?
			,K.PRODNM_CD = ?,K.SPEC_ABBSYM = ?,K.SPEC_STL_GRD = ?,K.ORD_USE_CD = ?
			,K.STL_GRD = ?,K.PATH_MILL_CD = ?,K.INGR_DEC_GRD = ?,K.EXTSHAPE_DEC_GRD = ?
			,K.SIZE_DEC_RST = ?,K.WGT_DEC_RST = ?,K.PROC_DEC_RST = ?,K.MATLQLTY_DEC_GRD = ?
			,K.TOT_DEC_GRD = ?,K.MILL_DTIME = ?,K.CRK_CD1 = ?,K.CRK_CD2 = ?,K.CRK_CD3 = ?
			,K.CRK_CD4 = ?,K.CRK_CD5 = ?,K.CAL_WGT = ?,K.OLD_SAMPL_NO = ?
			,K.CR_PLANT_TRS_CLF = ?,K.CR_PLANT_TRS_NO = ?,K.CR_PLANT_TRS_DTIME = ?
			,K.FM_EXT_STRIP_THK_AVG = ?,K.FM_EXT_STRIP_TEMP_AVG = ?,K.DC_TEMP_AVG = ?
			,K.FM_EXT_STRIP_CROWN_AVG = ?
			,K.RECEIVE_TIME = ?,K.SMP_NO = ?,K.SMP_CUT_LOC = ?
			,k.OLD_ORD_FL = ?,k.OLD_ORD_NO = ?,k.OLD_ORD_SEQ = ?
			,k.CR_PLANT_TRS_SEQ = ?
			WHERE K.COIL_NO = ?		
		]]>
	</query>
	<query id="UIH052400_03.update" desc="更新热轧库移送出库状态">
		<![CDATA[
			UPDATE TBH02_COIL_COMM H SET H.COIL_STAT = '3',H.BEF_PROG_CD = H.CUR_PROG_CD,
			H.BEF_PROG_CD_DTIME = H.CUR_PROG_CD_DTIME,H.BEF_PROG_CD_PGM = H.CUR_PROG_CD_PGM,
			H.CUR_PROG_CD = 'SGF', H.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), 
			H.CUR_PROG_CD_PGM = 'UIH052400',H.BEF_LOAD_LOC = H.CUR_LOAD_LOC,
			 H.TRNF_SHIFT = ?, H.TRNF_GROUP = ?, H.TRNF_REG = ?,H.CUR_LOAD_LOC = 'L',
			 H.TRNF_DTIME = ?, H.TRNF_USE_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), 
			 H.CR_PLANT_TRS_CLF = ?, H.CR_PLANT_TRS_NO = ?, H.CR_PLANT_TRS_DTIME = ?
			 ,H.DLIV_TP = 'L',H.CR_PLANT_TRS_SEQ = ?,H.CR_PLANT_TRS_FLAG = ?
			 WHERE H.OLD_SAMPL_NO = ?	
		]]>
	</query>
	<query id="UIH052400_04.update" desc="更新热轧库存表  ">
        <![CDATA[
			UPDATE TBH05_COIL_YARD T SET 
				   T.COIL_NO = '',
				   T.REG_ID = '',
				   T.REG_DTIME = '' 
				   WHERE T.COIL_NO = ?
		]]>
    </query>
	<query id="UIH052400_05.update" desc="更新热轧库退回状态">
		<![CDATA[
			UPDATE TBH02_COIL_COMM H SET H.COIL_STAT = '2',H.CUR_PROG_CD = decode(H.ORD_FL,'1','SGB','SRC'),H.CUR_PROG_CD_PGM = 'UIH052400',
			 H.YARD_ENTRY_SHIFT = ?, H.YARD_ENTRY_GROUP = ?, H.YARD_ENTRY_REG = ?,H.CUR_LOAD_LOC = ?,
			 H.YARD_ENTRY_DTIME = ?, H.YARD_ENTRY_USE_TIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
			 WHERE H.OLD_SAMPL_NO = ?	
		]]>
	</query>
	<query id="UIH052400_06.update" desc="更新热轧库退回入库垛位">
		<![CDATA[
			UPDATE TBH05_COIL_YARD T SET 
				   T.COIL_NO = ?,
				   T.REG_ID = ?,
				   T.REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') 
                    where t.YARD_CLF = substr(?,0,5) 
                    and t.STEP_CLF = substr(?,6,2)
                    and t.STORELAY = substr(?,8,1)
                    and t.STORE_SEQ = substr(?,9,1)  
		]]>
	</query>
	<query id="UIH052401_01.select" desc="查询待判移送钢卷">
		<![CDATA[
			SELECT 'N' CHK, H.COIL_NO,H.OLD_SAMPL_NO,H.CR_PLANT_TRS_DTIME,H.CR_PLANT_TRS_SEQ
			,decode(H.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD
			,H.SPEC_STL_GRD,TO_CHAR(H.COIL_THK,'FM990.099')||'*'||H.COIL_WTH T_W
			,TO_CHAR(H.INSTR_COIL_THK,'FM990.099')||'*'||H.INSTR_COIL_WTH IT_IW
			,H.ACT_WGT,H.ORD_NO,H.ORD_SEQ,H.CR_PLANT_TRS_CLF,H.CR_PLANT_TRS_NO
			 FROM TBH02_COIL_COMM H WHERE H.CR_PLANT_TRS_FLAG = 'N'
			ORDER BY H.CR_PLANT_TRS_DTIME,H.CR_PLANT_TRS_SEQ
			]]>
	</query>
	<query id="UIH052401_01.update" desc="更改热轧成口移送确认状态">
		<![CDATA[
			UPDATE TBH02_COIL_COMM H SET H.CR_PLANT_TRS_FLAG = ? WHERE H.OLD_SAMPL_NO = ?
			]]>
	</query>
	<query id="UIH052400_01.delete" desc="删除冷轧数据">
		<![CDATA[
			
			delete from c_tbk02_coil_comm t where t.OLD_SAMPL_NO=? and t.COIL_STAT='1' and t.CUR_LOAD_LOC is null
			]]>
	</query>
	
	<query id="UIH052400_08.select" desc="查询移送钢卷，外观判定和尺寸判定">
		<![CDATA[
			select t.EXTSHAPE_DEC_GRD,t.SIZE_DEC_RST from tbh02_coil_comm t where t.OLD_SAMPL_NO  = ?
		]]>
	</query>
</queryMap>