f82d41a8be098c81244322e16a619e786c5f7b09.svn-base 577 B

123456789101112131415161718192021
  1. <?xml version="1.0" encoding='UTF-8'?>
  2. <queryMap desc="出钢参数接收现况分析(中厚板)">
  3. <query id="UIG013010.find" desc="查询出钢参数返回现状" fetchSize="10">
  4. <![CDATA[
  5. SELECT A.ORD_NO||A.ORD_SEQ HTH
  6. ,A.SLAB_NO
  7. ,'' CD
  8. ,A.STL_GRD
  9. ,A.SLAB_THK || ' * ' || A.SLAB_WTH || ' * ' || A.SLAB_LEN GG
  10. ,A.SLAB_WGT
  11. ,A.CUR_LOAD_LOC
  12. ,'' BZ
  13. ,SMS_YARD_ENT_DTIME
  14. FROM TBG02_SLAB_COMM A
  15. WHERE A.SLAB_STAT = '2'
  16. AND SUBSTR(A.SMS_YARD_ENT_DTIME,1,8) = ?
  17. ]]>
  18. </query>
  19. </queryMap>