XinYu_RZMES/.svn/pristine/93/935623347248bf3b356ea0d5a97b7b9b141690cd.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
				LEFT JOIN tb_l2_send@link_jk111 t1 ON t.SLAB_NO=t1.billetno
 				WHERE t.slab_no like :1 || '%'
				 --AND T.SAMPLINGID IS NULL
				 and t.STRAND_NO='1'
				 and rownum < 50
				 and (t.MATRL_END_CAUSE_CD is null or t.MATRL_END_CAUSE_CD not in ('4','5'))
				 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
			     LEFT JOIN tb_l2_send@link_jk111 t1 ON t.SLAB_NO=t1.billetno
				 WHERE t.slab_no like :1 || '%'
				 --AND T.SAMPLINGID IS NULL
				 and t.STRAND_NO='2'
				 and rownum < 50
				 and (t.MATRL_END_CAUSE_CD is null or t.MATRL_END_CAUSE_CD not in ('4','5'))
				 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>