XinYu_RZMES/.svn/pristine/dd/dd03da851a1e1881225064eefdc042e1b15aa986.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
  <query id="UIG040080_01.select" desc=" ">
	   <![CDATA[
	 SELECT SLAB_NO,PLT_IND_TRS_DATE,PLT_IND_INVOICE_NO,STL_GRD
            ORD_NO,ORD_SEQ,SLAB_THK,SLAB_WTH,SLAB_LEN,SLAB_WGT
            CUR_LOAD_LOC,CORRECT_RSLT_CD,CORRECT_DTIME,SLAB_REGEN_CLF 
       FROM TBG02_SLAB_COMM
      WHERE CUR_LOAD_LOC LIKE 'L%' 
       AND  PRODNM_CD  LIKE 'P%'
        ]]> 
  </query>
  <query id="UIG040080_RECV_SLAB.select" desc=" ">
	   <![CDATA[
			SELECT 	'' CHK
					,'' CUR_LOAD_LOC
					,T.SLAB_THK||'*'||T.SLAB_WTH||'*'||T.SLAB_LEN SLAB_SIZE
					,T.* FROM 
			TBG04_SLAB_TRANSF02 T
			WHERE '1' = '1'
			AND   T.FLAG  = '0'
			AND   T.CHARGE_NO LIKE ?||'%'
			AND   T.TRS_INVOICE_NO LIKE ?||'%'
			AND   T.TRS_CAR_NO LIKE ?||'%' 
			AND   T.INGR_DEC_GRD LIKE ?||'%'
			AND   T.EXTSHAPE_GRD LIKE ?||'%'
        ]]> 
  </query>
  <query id="UIG040080_CHARGE_EXIS.select" desc=" ">
	   <![CDATA[
			SELECT CHARGE_NO,SLAB_WGT,SLAB_CNT 
			FROM TBG02_CHARGE_COMM 
			WHERE CHARGE_NO = ?
        ]]> 
  </query>
  <query id="UIG040080_SLAB_EXIS.select" desc=" ">
	   <![CDATA[
			SELECT SLAB_NO
			FROM TBG02_SLAB_COMM 
			WHERE SLAB_NO = ?
        ]]> 
  </query> 
  <query id="UIG040080_SLAB_RECEIVED.update" desc=" ">
	   <![CDATA[
			UPDATE TBG04_SLAB_TRANSF02  T 
			SET T.FLAG = '1'
        ]]> 
  </query>
</queryMap>