| 123456789101112131415161718192021 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="原料库移垛">
- <query id="UIM010100_01.SELECT" desc="热轧钢卷垛位查询">
- <![CDATA[
- select count(1) count
- from c_tbk02_coil_comm k,tbh02_coil_comm h
- where k.COIL_NO = h.OLD_SAMPL_NO
- and h.COIL_STAT = '2' and h.OLD_SAMPL_NO = ?
- ]]>
- </query>
- <query id="UIM010100_01.UPDATE" desc="更新更新热轧垛位">
- <![CDATA[
- UPDATE TBH02_COIL_COMM H
- SET H.BEF_LOAD_LOC = H.CUR_LOAD_LOC
- ,H.BEF_LOAD_LOC_DTIME = H.CUR_LOAD_LOC_DTIME
- ,H.CUR_LOAD_LOC = ?
- ,H.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- WHERE H.OLD_SAMPL_NO = ?
- ]]>
- </query>
- </queryMap>
|
