XinYu_RZMES/.svn/pristine/58/58a31aab2567d47151ebeea0891ae35a3706d1b9.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG050021_01.select" desc="     " fetchSize="10">
        <![CDATA[
	          SELECT '' CHK,T.* FROM tbg04_slab_act_wgt t
	          WHERE t.STATS_CD = 'A'
	          AND   SYSDATE  -  T.SAMPLINGTIME <= 1
	          AND T.CCMID = :1
              AND T.FLOWNO = '1'
			  ORDER BY T.SAMPLINGID
        ]]>
    </query> 
    <query id="UIG050021_02.select" desc="     " fetchSize="10">
        <![CDATA[
	            SELECT '' CHK
				       ,T.SLAB_NO
				       ,T.SLAB_WGT
				       ,T.SLAB_THK||'*'||T.SLAB_WTH||'*'||T.SLAB_LEN SLAB_SIZE
				       ,T.STL_GRD
				       ,T.WEIGHT_WGT
				       ,T.SAMPLINGID
				       ,t1.WIGHT_UPDATE
  				FROM tbg02_slab_comm t,tb_l2_send@link_jk111 t1
 				WHERE t.SLAB_NO=t1.billetno(+)
       			and t.slab_no like :1 || '%'
				 --AND T.SAMPLINGID IS NULL
				 and t.STRAND_NO='1'
				 and rownum < 50
				 order by t.SLAB_NO asc
        ]]>
    </query> 
     <query id="UIG050021_03.select" desc="     " fetchSize="10">
        <![CDATA[
	            SELECT '' CHK
				       ,T.SLAB_NO
				       ,T.SLAB_WGT
				       ,T.SLAB_THK||'*'||T.SLAB_WTH||'*'||T.SLAB_LEN SLAB_SIZE
				       ,T.STL_GRD
				       ,T.WEIGHT_WGT
				       ,T.SAMPLINGID
				       ,t1.WIGHT_UPDATE
				  FROM tbg02_slab_comm t,tb_l2_send@link_jk111 t1
				 WHERE t.SLAB_NO=t1.billetno(+)
				  and t.slab_no like :1 || '%'
				 --AND T.SAMPLINGID IS NULL
				 and t.STRAND_NO='2'
				 and rownum < 50
				 order by t.SLAB_NO asc
        ]]>
    </query> 
    <query id="UIG050021_04.select" desc="     " fetchSize="10">
        <![CDATA[
	          SELECT '' CHK,T.* FROM tbg04_slab_act_wgt t
	          WHERE t.STATS_CD = 'A'
	          AND   SYSDATE  -  T.SAMPLINGTIME <=  1
	          AND T.CCMID = :1
              AND T.FLOWNO = '2'
			  ORDER BY T.SAMPLINGID
        ]]>
    </query>
    <query id="UIG050021_01.call" desc="     " fetchSize="10">
        <![CDATA[
	            {call PKG_UIG.PROD_L2_SLABWGT_MATCH_new(?,?,?,?,?,?,?)}
        ]]>
    </query>
    <query id="UIG050021_02.call" desc="     " fetchSize="10">
        <![CDATA[
	            {call PKG_UIG.PROD_GET_L2_SLABWGT_new(?)}
        ]]>
    </query>
</queryMap>