XinYu_RZMES/.svn/pristine/be/be44a62f4af7a5cf870f928ef62795adda177311.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH070010_01.select" desc=" 查询待发板加的钢卷 " fetchSize="10">
		<![CDATA[
          SELECT '' CHK
				  ,A.OLD_SAMPL_NO
				  ,A.COIL_NO
				 ,A.SPEC_STL_GRD
				 ,A.ORD_NO
				 ,A.ORD_SEQ
				 ,A.SLAB_NO 
				 ,A.COIL_THK
				 ,A.COIL_WTH
				 ,A.COIL_LEN
				 ,A.ACT_WGT
				 ,A.COIL_INDIA
				 ,A.COIL_OUTDIA
				 ,A.CUR_LOAD_LOC
				 ,'' TRANS_CAR_NO --车辆号，界面输入
				 ,'' SHIP_INVNO --发货清单号，后台生成
				 ,'' ROUTE --实去向从界面选择
				 ,'' MOVE_MAN --移送人
				 ,TO_CHAR(SYSDATE,'YYYYMMDD') MOVE_TIME --移送时间
				 ,(SELECT T.DEL_TO_DATE FROM TBE02_ORD_PRC T WHERE T.ORD_NO = A.ORD_NO AND T.ORD_SEQ = A.ORD_SEQ) DEVLMT_DTIME
				 ,T3.SM_CFNM ORDCUST_CD_DESC
				 ,T3.SM_CD ORDCUST_CD
				 ,T2.SM_CFNM CUST_CD_DESC
				 ,(SELECT sm_cfnm   FROM TBZ00_COMMCD      WHERE LG_CD = 'A01009'     AND C.DEST_PCD = SM_CD) DEST_PCD_DESC
				 ,(SELECT SM_CD   FROM TBZ00_COMMCD      WHERE LG_CD = 'A01009'     AND C.DEST_PCD = SM_CD) DEST_PCD
				 ,A.PRODNM_CD
				 ,A.SPEC_ABBSYM
				 ,A.MILL_DTIME
				 ,A.INSTR_COIL_THK
				 ,A.INSTR_COIL_WTH
				 ,A.INSTR_COIL_LEN
				 ,A.INSTR_COIL_WGT
				 ,A.INSTR_COIL_INDIA
				 ,A.INSTR_COIL_OUTDIA
				 ,decode(A.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD_DESC  --综合判定
				 ,decode(A.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格')   INGR_DEC_GRD_DESC      --成份判定
				 ,decode(A.MATLQLTY_DEC_GRD,'0','无性能要','1','合格','2','不合格')  MATLQLTY_DEC_GRD_DESC   --材质判定
				 ,decode(A.SIZE_DEC_RST,'1','合格','2','订单外合格','3','不合格','4','废品')   SIZE_DEC_RST_DESC   --尺寸判定
				 ,decode(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD_DESC  --外观判定
				 ,DECODE(A.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST_DESC
				 ,A.TOT_DEC_GRD
				 ,A.INGR_DEC_GRD
				 ,A.MATLQLTY_DEC_GRD
				 ,A.SIZE_DEC_RST
				 ,A.EXTSHAPE_DEC_GRD
				 ,A.WGT_DEC_RST
				 ,A.CRK_CD1
				 ,A.CRK_CD2
				 ,A.CRK_CD3
				 ,A.CRK_CD4
				 ,A.CRK_CD5
			     ,DECODE(A.CUR_PROG_CD,'SED','判定待机','SFA','发货待机','SFB','运送待机','SFF','运送完成') CUR_PROG_CD 
				 FROM TBH02_COIL_COMM A,TBA01_ORD_COMM B,TBA01_ORD_LINE C 
				 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T WHERE REC_TP='02') T3
				 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T WHERE REC_TP='01') T2
				 WHERE A.ORD_NO = B.ORD_NO(+)
				 AND B.ORDCUST_CD = T3.SM_CD(+)
				 AND B.CUST_CD = T2.SM_CD(+)
				 AND A.ORD_NO = C.ORD_NO(+)  
				 AND A.ORD_SEQ = C.ORD_SEQ(+) 
				 AND A.COIL_STAT = '2' 
				 AND A.OLD_SAMPL_NO LIKE :1||'%'
				 AND A.SPEC_STL_GRD LIKE :2||'%'
				 AND T3.SM_CFNM LIKE '%'||:3||'%'
				 AND A.ORD_NO LIKE :4||'%'
				 AND A.CUR_LOAD_LOC IS NOT NULL 
				 AND A.TOT_DEC_GRD = '1' 
				 AND A.CUR_PROG_CD = 'SFA'
				 ORDER BY A.OLD_SAMPL_NO   
			
		]]>
	</query>
	<query id="UIH070010_02.select" desc=" 查询板加待接收的卷 " fetchSize="10">
		<![CDATA[
      SELECT '' CHK
			 ,A.OLD_SAMPL_NO
			 ,A.SPEC_STL_GRD
			 ,A.ORD_NO
			 ,A.ORD_SEQ 
			 ,A.COIL_THK
			 ,A.COIL_WTH
			 ,A.COIL_LEN
			 ,A.ACT_WGT
			 ,A.TRANS_CAR_NO
			 ,A.SHIP_INVNO
			 ,A.ROUTE
			 ,A.MOVE_TIME
			 ,'' RTN_CUR_STORE_LOC --钢卷回退放置位置
			 ,A.MOVE_ST
			 ,A.RTN_CAU_CD
			 ,A.CREATOR
			 ,A.CREATE_TIME
			 ,A.SHIP_INVNO_CR
			 ,A.RETURN_REG
			 ,A.RETURN_DTIME
			 ,A.YSRETURN_REG
			 ,A.YSRETURN_DTIME
			 ,A.BJRETURN_REG
			 ,A.BJRETURN_DTIME
			 ,A.CRRETURN_REG
			 ,A.CRRETURN_DTIME
			 ,DECODE(A.MATLQLTY_DEC_GRD,'1','合格','2','不合格',null) as MATLQLTY_DEC_GRD_DESC 
			 ,DECODE(A.TOT_DEC_GRD,'1','合格','2','不合格',null) as  TOT_DEC_GRD_DESC
			 ,T3.SM_CFNM ORDCUST_CD_DESC
			 ,T3.SM_CD ORDCUST_CD
			 ,T2.SM_CFNM CUST_CD_DESC
			 ,A.ENTRY_REG
			 ,A.ENTRY_DTIME
			 ,A.INSTR_COIL_THK
			 ,A.INSTR_COIL_WTH
			 ,A.PRODNM_CD  
			 ,A.SPEC_ABBSYM  
			 ,(SELECT sm_cfnm   FROM TBZ00_COMMCD      WHERE LG_CD = 'A01009'     AND C.DEST_PCD = SM_CD) DEST_PCD_DESC
			 ,(SELECT SM_CD   FROM TBZ00_COMMCD      WHERE LG_CD = 'A01009'     AND C.DEST_PCD = SM_CD) DEST_PCD
			 ,A.COIL_NO    
			   FROM TBH07_BJ_TRANFINFO A,TBA01_ORD_COMM B,TBA01_ORD_LINE C 
			   ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T WHERE REC_TP='02') T3
			   ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T WHERE REC_TP='01') T2
			   WHERE A.ORD_NO = B.ORD_NO(+)
			   AND B.ORDCUST_CD = T3.SM_CD(+)
			   AND B.CUST_CD = T2.SM_CD(+)
			   AND A.ORD_NO = C.ORD_NO(+)  
			   AND A.ORD_SEQ = C.ORD_SEQ(+) 
			   AND A.MOVE_TIME LIKE :1||'%'
			   AND A.TRANS_CAR_NO LIKE :2||'%'
			   AND A.SHIP_INVNO||'&' LIKE :3||'%'
			   AND A.MOVE_ST LIKE :4||'%'
			   AND A.SHIP_INVNO_CR||'&' LIKE :5||'%'
			   ORDER BY A.SHIP_INVNO,A.SHIP_INVNO_CR 
		]]>
	</query>
	<query id="UIH070010_03.select" desc=" 这里获取移送板加的发货明细编号 " fetchSize="10">
		<![CDATA[
				SELECT   SUBSTRB(A.SHIP_INVNO,1,4)||TO_CHAR(TO_NUMBER(SUBSTRB(SHIP_INVNO,5,6)) + 1,'FM000000') SHIP_INVNO                        
                    FROM    (SELECT ROW_NUMBER() OVER (ORDER BY  NVL(SHIP_INVNO,'BJ0-0000000')  DESC) AS RN
                            ,MOVE_TIME
                            ,SHIP_INVNO
                             FROM   TBH07_BJ_TRANFINFO 
                             WHERE    SHIP_INVNO LIKE 'BJ0%') A
                             WHERE  A.RN = 1
		]]>
	</query>
	<query id="UIH070010_04.select" desc=" 查询垛位表中是否存在数据 " fetchSize="10">
		<![CDATA[
			SELECT A.COIL_NO FROM TBH05_COIL_YARD A WHERE A.YARD_CLF||A.STEP_CLF||A.STORELAY||A.STORE_SEQ = :1
		]]>
	</query>
	<query id="UIH070010_05.select" desc=" 这里获取移送冷轧的发货明细编号 " fetchSize="10">
		<![CDATA[
			/********************************************************************************************************
			SELECT CASE WHEN (SUBSTRB(A.MOVE_TIME,1,4) = TO_CHAR(SYSDATE,'YYYY')) THEN
                     SUBSTRB(A.SHIP_INVNO_CR,1,4)||TO_CHAR(TO_NUMBER(SUBSTRB(A.SHIP_INVNO_CR,5,6)) + 1,'FM000000')
                     ELSE
                     DECODE(SUBSTRB(A.SHIP_INVNO_CR,1,4),TO_CHAR(SYSDATE,'YYYY')
                     ,SUBSTRB(A.SHIP_INVNO_CR,1,4)||TO_CHAR(TO_NUMBER(SUBSTRB(SHIP_INVNO_CR,5,6)) + 1,'FM000000')
                     ,SUBSTRB(A.SHIP_INVNO_CR,1,2)||TO_CHAR(MOD(TO_NUMBER(TO_CHAR(SYSDATE,'YY')),10),'FM0')||'-'||'000001'
                           ) 
                END AS SHIP_INVNO_CR
                FROM     (SELECT ROW_NUMBER() OVER (ORDER BY NVL(SHIP_INVNO_CR,'CR0-0000000') DESC) AS RN
                         ,MOVE_TIME
                         ,SHIP_INVNO_CR
                   FROM TBH07_BJ_TRANFINFO) A
				WHERE A.RN = 1
			*******************************************************************************************************/
			SELECT   SUBSTRB(A.SHIP_INVNO_CR,1,4)||TO_CHAR(TO_NUMBER(SUBSTRB(SHIP_INVNO_CR,5,6)) + 1,'FM000000') SHIP_INVNO_CR                        
                    FROM    (SELECT ROW_NUMBER() OVER (ORDER BY  NVL(SHIP_INVNO_CR,'CR0-0000000')  DESC) AS RN
                            ,MOVE_TIME
                            ,SHIP_INVNO_CR
                             FROM   TBH07_BJ_TRANFINFO 
                             WHERE    SHIP_INVNO_CR LIKE 'CR0%') A
                             WHERE  A.RN = 1
		]]>
	</query>
	<query id="UIH070010_06.select" desc=" 这里效验此卷的状态是否已经做了发运计划或者发运完成 " fetchSize="10">
		<![CDATA[
			SELECT A.CUR_PROG_CD FROM TBH02_COIL_COMM A WHERE A.OLD_SAMPL_NO = ?
		]]>
	</query>
	<query id="UIH070010_07.select" desc=" 查询板加待接收的卷,这里已报表的形式提交 " fetchSize="10">
		<![CDATA[
      SELECT '' CHK
			 ,A.OLD_SAMPL_NO
			 ,A.SPEC_STL_GRD
			 ,A.ORD_NO
			 ,A.ORD_SEQ 
			 ,A.COIL_THK
			 ,A.COIL_WTH
			 ,A.COIL_LEN
			 ,A.ACT_WGT
			 ,A.TRANS_CAR_NO
			 ,A.SHIP_INVNO
			 ,A.ROUTE
			 ,A.MOVE_TIME
			 ,'' RTN_CUR_STORE_LOC --钢卷回退放置位置
			 ,A.MOVE_ST
			 ,A.RTN_CAU_CD
			 ,A.CREATOR
			 ,A.CREATE_TIME
			 ,A.SHIP_INVNO_CR
			 ,A.RETURN_REG
			 ,A.RETURN_DTIME
			 ,A.YSRETURN_REG
			 ,A.YSRETURN_DTIME
			 ,A.BJRETURN_REG
			 ,A.BJRETURN_DTIME
			 ,A.CRRETURN_REG
			 ,A.CRRETURN_DTIME
			 ,A.RETURN_REM 
			 ,A.RETURN_SHIFT 
			 ,A.RETURN_GROUP
			 ,A.MOVE_SHIFT
			 ,A.MOVE_GROUP
			 ,(SELECT sm_cfnm   FROM TBZ00_COMMCD      WHERE LG_CD = 'A01009'     AND A.DEST_CD = SM_CD) DEST_PCD 
			 ,T3.SM_CD ORDCUST_CD
			 ,T3.SM_CFNM ORDCUST_CD_DESC
			 ,A.PRODNM_CD 
			 ,T2.SM_CFNM CUST_CD_DESC
			 FROM TBH07_BJ_TRANFINFO A,TBA01_ORD_COMM B
			 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T WHERE REC_TP='02') T3
			 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T WHERE REC_TP='01') T2
			 WHERE A.ORD_NO = B.ORD_NO(+)
			 AND B.ORDCUST_CD = T3.SM_CD(+)
			 AND B.CUST_CD = T2.SM_CD(+)
			 AND A.OLD_SAMPL_NO LIKE :1||'%'
			 AND (SUBSTR(A.MOVE_TIME,1,8) >= :2)
			 AND (SUBSTR(A.MOVE_TIME,1,8) <= :3) 
			 AND A.MOVE_ST LIKE :4||'%'
			 AND A.MOVE_SHIFT||'&' LIKE :5||'%'
			 AND A.MOVE_GROUP||'&' LIKE :6||'%'
			 AND T3.SM_CFNM LIKE :7||'%'
			 AND A.SPEC_STL_GRD LIKE :8||'%'
			 AND A.ORD_NO LIKE :9||'%'
			ORDER BY A.SHIP_INVNO,A.SHIP_INVNO_CR 
		]]>
	</query>
	<query id="UIH070010_08.select" desc=" 查询板加待接收的卷,这里已报表的形式提交 " fetchSize="10">
		<![CDATA[
          SELECT count(A.OLD_SAMPL_NO) COIL_CNT,
 				  nvl(sum(a.act_wgt)/1000,0) COIL_WGT 
				 FROM TBH07_BJ_TRANFINFO A,TBA01_ORD_COMM B
				 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T3
				 WHERE A.ORD_NO = B.ORD_NO(+)
				 AND B.ORDCUST_CD = T3.SM_CD(+)
				 AND A.OLD_SAMPL_NO LIKE :1||'%'
				 AND (SUBSTR(A.MOVE_TIME,1,8) >= :2)
				 AND (SUBSTR(A.MOVE_TIME,1,8) <= :3) 
				 AND A.MOVE_ST LIKE :4||'%'
				 AND A.MOVE_SHIFT||'&' LIKE :5||'%'
				 AND A.MOVE_GROUP||'&' LIKE :6||'%'
				 AND T3.SM_CFNM LIKE :7||'%'
				 AND A.SPEC_STL_GRD LIKE :8||'%'
				 AND A.ORD_NO LIKE :9||'%'
				
				 ORDER BY A.SHIP_INVNO,A.SHIP_INVNO_CR
		]]>
	</query>
	<query id="UIH070010_09.select" desc="效验移送状态，热轧退回时必须为0" fetchSize="10">
		<![CDATA[
			 SELECT A.MOVE_ST FROM TBH07_BJ_TRANFINFO A WHERE A.OLD_SAMPL_NO = :1 AND A.SHIP_INVNO = :2
		]]>
	</query>
	<query id="UIH070010_01.insert" desc=" 把数据迁移到板加接口表,这里走的是人工操作界面 " fetchSize="10">
		<![CDATA[
      insert into TBH07_BJ_TRANFINFO A   
            (   
              OLD_SAMPL_NO
              ,SPEC_STL_GRD
              ,ORD_NO
              ,ORD_SEQ
              ,SLAB_NO
              ,COIL_THK
              ,COIL_WTH
              ,COIL_LEN
              ,ACT_WGT
              ,COIL_INDIA
              ,COIL_OUTDIA
              ,TRANS_CAR_NO
              ,SHIP_INVNO
              ,ROUTE
              ,MOVE_ST
              ,DEVLMT_DTIME
              ,ORDCUST_CD
              ,DEST_CD
              ,PRODNM_CD
              ,SPEC_ABBSYM
              ,MILL_DTIME
              ,INSTR_COIL_THK 
              ,INSTR_COIL_WTH
              ,INSTR_COIL_LEN
              ,INSTR_COIL_WGT
              ,INSTR_COIL_INDIA
              ,INSTR_COIL_OUTDIA
              ,EXTSHAPE_DEC_GRD
              ,INGR_DEC_GRD
              ,MATLQLTY_DEC_GRD
              ,SIZE_DEC_RST
              ,WGT_DEC_RST
              ,TOT_DEC_GRD
              ,CRK_CD1
              ,CRK_CD2
              ,CRK_CD3
              ,CRK_CD4
              ,CRK_CD5
              ,MOVE_MAN
              ,SX_BIAOZHUN
              ,BAHCT_NUMBER
              ,CHARGE_NO
              ,MOVE_LINE
              ,ARRIVE_LINE
              ,MOVE_SHIFT
              ,MOVE_GROUP
              ,ENTRY_REG
              ,ENTRY_DTIME
			  ,COIL_NO
              ,MOVE_TYPE
              ,MOVE_TIME
            )
            values
            ( 
              :1 
              ,:2
              ,:3
              ,:4
              ,:5
              ,:6
              ,:7
              ,:8
              ,:9
              ,:10
              ,:11
              ,:12
              ,:13
              ,:14
              ,:15
              ,:16
              ,:17
              ,:18
              ,:19
              ,:20
              ,:21 
              ,:22
              ,:23
              ,:24
              ,:25
              ,:26
              ,:27
              ,:28
              ,:29
              ,:30
              ,:31
              ,:32
              ,:33
              ,:34
              ,:35
              ,:36
              ,:37
              ,:38
              ,:39
              ,:40
              ,:41
              ,:42
              ,:43
              ,:44
              ,:45
              ,:46
              ,:47
              ,:48
			  ,:49
              ,'1'
              ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            )
		]]>
	</query>
	<query id="UIH070010_02.insert" desc=" 把数据迁移到冷轧接口表,这里走的是人工操作界面 " fetchSize="10">
		<![CDATA[
      insert into TBH07_BJ_TRANFINFO A   
            (   
              OLD_SAMPL_NO
              ,SPEC_STL_GRD
              ,ORD_NO
              ,ORD_SEQ
              ,SLAB_NO
              ,COIL_THK
              ,COIL_WTH
              ,COIL_LEN
              ,ACT_WGT
              ,COIL_INDIA
              ,COIL_OUTDIA
              ,TRANS_CAR_NO
              ,SHIP_INVNO_CR
              ,ROUTE
              ,MOVE_ST
              ,DEVLMT_DTIME
              ,ORDCUST_CD
              ,DEST_CD
              ,PRODNM_CD
              ,SPEC_ABBSYM
              ,MILL_DTIME
              ,INSTR_COIL_THK 
              ,INSTR_COIL_WTH
              ,INSTR_COIL_LEN
              ,INSTR_COIL_WGT
              ,INSTR_COIL_INDIA
              ,INSTR_COIL_OUTDIA
              ,EXTSHAPE_DEC_GRD
              ,INGR_DEC_GRD
              ,MATLQLTY_DEC_GRD
              ,SIZE_DEC_RST
              ,WGT_DEC_RST
              ,TOT_DEC_GRD
              ,CRK_CD1
              ,CRK_CD2
              ,CRK_CD3
              ,CRK_CD4
              ,CRK_CD5
              ,MOVE_MAN
			  ,SX_BIAOZHUN
			  ,BAHCT_NUMBER
			  ,CHARGE_NO
			  ,MOVE_LINE
			  ,ARRIVE_LINE
			  ,MOVE_SHIFT
              ,MOVE_GROUP
			  ,ENTRY_REG
              ,ENTRY_DTIME
			  ,COIL_NO
			  ,MOVE_TYPE
              ,MOVE_TIME
            )
            values
            ( 
              :1 
              ,:2
              ,:3
              ,:4
              ,:5
              ,:6
              ,:7
              ,:8
              ,:9
              ,:10
              ,:11
              ,:12
              ,:13
              ,:14
              ,:15
              ,:16
              ,:17
              ,:18
              ,:19
              ,:20
              ,:21 
              ,:22
              ,:23
              ,:24
              ,:25
              ,:26
              ,:27
              ,:28
              ,:29
              ,:30
              ,:31
              ,:32
              ,:33
              ,:34
              ,:35
              ,:36
              ,:37
              ,:38
              ,:39
			  ,:40
			  ,:41
			  ,:42
			  ,:43
			  ,:44
			  ,:45
              ,:46
			  ,:47
			  ,:48
			  ,:49
			  ,'1'
              ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            )
		]]>
	</query>
	<query id="UIH070010_01.update" desc=" 把发货明细号迁到钢卷公共表 " fetchSize="10">
		<![CDATA[
      update TBH02_COIL_COMM A set
               A.SHIP_INVNO = :1
               ,A.TRANS_CAR_NO = :2
               ,A.ROUTE    = :3
               ,A.CUR_LOAD_LOC = 'BJ'
               ,A.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,A.BEF_LOAD_LOC = CUR_LOAD_LOC
               ,A.BEF_LOAD_LOC_DTIME = CUR_LOAD_LOC_DTIME
               ,A.CUR_PROG_CD = 'SFF'
               ,A.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,A.CUR_PROG_CD_PGM = 'UIH070010'
               ,A.BEF_PROG_CD = A.CUR_PROG_CD
               ,A.BEF_PROG_CD_DTIME = A.CUR_PROG_CD_DTIME
               ,A.BEF_PROG_CD_PGM = A.CUR_PROG_CD_PGM 
               ,A.COIL_STAT = '3'  --这里移送的卷在热轧结束相应状态
      where    A.OLD_SAMPL_NO = :4 
		]]>
	</query>
	<query id="UIH070010_02.update" desc=" 更新垛位表 " fetchSize="10">
		<![CDATA[
			update TBH05_COIL_YARD A set
               A.COIL_NO = :1
               ,A.REG_ID = 'UIH070010'
               ,A.REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
      where    A.YARD_CLF||A.STEP_CLF||A.STORELAY||A.STORE_SEQ = :2
		]]>
	</query>
	<query id="UIH070010_03.update" desc=" 移送回退的时候更新钢卷公共表 " fetchSize="10">
		<![CDATA[
			update tbh02_coil_comm A set
                A.CUR_LOAD_LOC = :1
               ,A.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,A.BEF_LOAD_LOC = CUR_LOAD_LOC
               ,A.BEF_LOAD_LOC_DTIME = CUR_LOAD_LOC_DTIME
               ,A.TRANS_CAR_NO = ''
               ,A.ROUTE    = 'H'
               ,A.COIL_STAT = '2'
               ,A.CUR_PROG_CD = 'SFA'
               ,A.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,A.CUR_PROG_CD_PGM = 'UIH070010'
               ,A.BEF_PROG_CD = A.CUR_PROG_CD
               ,A.BEF_PROG_CD_DTIME = A.CUR_PROG_CD_DTIME
               ,A.BEF_PROG_CD_PGM = A.CUR_PROG_CD_PGM
      where    A.OLD_SAMPL_NO = :2
		]]>
	</query>
	<query id="UIH070010_04.update" desc=" 更新移送接口表，热轧回退板加的情况 " fetchSize="10">
		<![CDATA[
     		 update TBH07_BJ_TRANFINFO A set
						 A.YSRETURN_REG = :1
						,A.YSRETURN_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
						,A.MOVE_ST = '2'
			  where    A.OLD_SAMPL_NO = :2
					   AND A.SHIP_INVNO = :3
		]]>
	</query>
	<query id="UIH070010_05.update" desc=" 移送的时候还要清除垛位表数据 " fetchSize="10">
		<![CDATA[
     		 update TBH05_COIL_YARD A set
            A.COIL_NO = ''
            ,A.REG_ID = ''
            ,A.REG_DTIME = ''
            
        where    A.COIL_NO = :1
		]]>
	</query>
	<query id="UIH070010_06.update" desc=" 更新移送接口表，板加回退的情况 " fetchSize="10">
		<![CDATA[
 			 update TBH07_BJ_TRANFINFO A set
				 A.BJRETURN_REG = :1
				,A.BJRETURN_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				,A.MOVE_ST = '8'
			where  A.OLD_SAMPL_NO = :2
				 AND A.SHIP_INVNO = :3
		]]>
	</query>
	<query id="UIH070010_07.update" desc=" 更新移送接口表，冷轧回退的情况 " fetchSize="10">
		<![CDATA[
        update TBH07_BJ_TRANFINFO A set
				 A.CRRETURN_REG = :1
				,A.CRRETURN_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				,A.MOVE_ST = '7' 
			  where  A.OLD_SAMPL_NO = :2
				 AND A.SHIP_INVNO_CR = :3
		]]>
	</query>
	<query id="UIH070010_08.update" desc=" 把发货明细号迁到钢卷公共表，冷轧 " fetchSize="10">
		<![CDATA[
      update TBH02_COIL_COMM A set
               A.SHIP_INVNO = :1
               ,A.TRANS_CAR_NO = :2
               ,A.ROUTE    = :3
               ,A.CUR_LOAD_LOC = 'CR'
               ,A.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,A.BEF_LOAD_LOC = CUR_LOAD_LOC
               ,A.BEF_LOAD_LOC_DTIME = CUR_LOAD_LOC_DTIME
               ,A.CUR_PROG_CD = 'SFF'
               ,A.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
               ,A.CUR_PROG_CD_PGM = 'UIH070010'
               ,A.BEF_PROG_CD = A.CUR_PROG_CD
               ,A.BEF_PROG_CD_DTIME = A.CUR_PROG_CD_DTIME
               ,A.BEF_PROG_CD_PGM = A.CUR_PROG_CD_PGM 
               ,A.COIL_STAT = '3'  --这里移送的卷在热轧结束相应状态
      where    A.OLD_SAMPL_NO = :4 
		]]>
	</query>
	<query id="UIH070010_09.update" desc=" 更新移送接口表，热轧回退冷轧的情况 " fetchSize="10">
		<![CDATA[
          update TBH07_BJ_TRANFINFO A set
				 A.YSRETURN_REG = :1
				,A.YSRETURN_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
				,A.MOVE_ST = '2'
				where    A.OLD_SAMPL_NO = :2
				     AND A.SHIP_INVNO_CR = :3
		]]>
	</query>
</queryMap>