b86ab7fefadfbff9abed0d7f7ba1a4f1d90449c7.svn-base 669 B

12345678910111213141516
  1. <?xml version="1.0" encoding='UTF-8'?>
  2. <queryMap desc="异常成分修改记录">
  3. <query id="UIB030200.SELECT" desc="" fetchSize="10">
  4. <![CDATA[
  5. SELECT * FROM TBB02_HIS_INGR T WHERE T.REG_DTIME BETWEEN ? AND ? AND rownum < 10000 ORDER BY T.REG_DTIME DESC
  6. ]]>
  7. </query>
  8. <query id="UIB030200_01.SELECT" desc="板坯综合判定记录">
  9. <![CDATA[
  10. SELECT * FROM TBB02_HIS_SLAB T WHERE T.REG_DTIME BETWEEN ? AND ? AND T.SLAB_NO LIKE ?
  11. AND DECODE(?,'%','%',T.SLAB_DCS_FLAG) = ? AND DECODE(?,NULL,'%',T.REG_ID) = NVL(?,'%') AND ROWNUM < 10000 ORDER BY T.REG_DTIME DESC
  12. ]]>
  13. </query>
  14. </queryMap>