XinYu_RZMES/.svn/pristine/49/4998637e2f1233e30e02cbae7168fb396e35ade3.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIG050020_01.select" desc="     " fetchSize="10">
        <![CDATA[
	          SELECT '' CHK,T.* FROM tbg04_slab_act_wgt t
	          WHERE t.STATS_CD = 'A'
	          AND   SYSDATE  -  T.SAMPLINGTIME <  60
	          AND T.CCMID = :1
            AND T.FLOWNO = :2
			  ORDER BY T.SAMPLINGID
        ]]>
    </query> 
    <query id="UIG050020_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
				  FROM tbg02_slab_comm t
				 WHERE t.slab_no like :1 || '%'
				 --AND T.SAMPLINGID IS NULL
				 and rownum < 50
        ]]>
    </query> 
    <query id="UIG050020_01.call" desc="     " fetchSize="10">
        <![CDATA[
	            {call PKG_UIG.PROD_L2_SLABWGT_MATCH(?,?,?,?,?,?)}
        ]]>
    </query>
    <query id="UIG050020_02.call" desc="     " fetchSize="10">
        <![CDATA[
	            {call PKG_UIG.PROD_GET_L2_SLABWGT(?)}
        ]]>
    </query>
</queryMap>