| 123456789101112 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH052100_01.select" desc=" 已制定命令查询 ">
- <![CDATA[
- SELECT T.CUR_LOAD_LOC_F,T.CUR_LOAD_LOC_T,T.COIL_NO,T.REG_ID,T.REG_DTIME,
- DECODE(T.REG_SHIFT,'1','早','2','中','3','晚') REG_SHIFT
- ,DECODE(T.REG_GROUP,'A','甲','B','乙','C','丙','D','丁') REG_GROUP,
- T.REG_USE_ID,T.REG_USE_DTIME
- FROM TBH05_COIL_MOVE T WHERE T.COIL_NO LIKE :1||'%'
- ]]>
- </query>
- </queryMap>
|
