| 12345678910111213141516171819202122232425 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH090100_01.select" desc=" 热轧命中率查询 " fetchSize="10">
- <![CDATA[
- SELECT B.SLAB_NO
- ,B.OLD_SAMPL_NO
- ,B.SPEC_STL_GRD
- ,B.COIL_THK||'*'||B.COIL_WTH T_W
- ,A.FM_EXT_STRIP_THK_OUT_OF_LEN
- ,A.FM_EXT_STRIP_WTH_OUT_OF_LEN
- ,A.FM_EXT_STRIP_CROWN_OUT_OF_LEN
- ,A.FM_SYM_STRIP_OUT_OF_RANGE
- ,A.FM_ASY_STRIP_OUT_OF_RANGE
- ,A.FM_STRIP_WDG_OUT_OF_RANGE
- ,A.STRIP_OUT_OF_RANGE
- ,A.DC_TEMP_OUT_OF_RANGE
- FROM TBH02_MILL_RESULT A,TBH02_COIL_COMM B
- WHERE A.SLAB_NO = B.SLAB_NO
- AND A.COIL_NO = B.COIL_NO
- AND A.WKGROUP||'&' LIKE :1||'%'
- AND substr(B.MILL_DTIME,1,8) >= :2
- AND substr(B.MILL_DTIME,1,8) <= :3
- ]]>
- </query>
- </queryMap>
|
