| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="冷轧调度日志chacun">
- <query id="UIB030192_01.SELECT" desc="查询">
- <![CDATA[
- SELECT '酸轧' PROD_LINE
- ,T.STOP_DTIME
- ,T.START_DTIME
- ,T.SUM_
- ,T.EVNET_NM
- ,T.EDT_NM
- ,T.DEPART_NM
- ,T.BAN_CI
- ,T.BAN_ZU
- FROM TBB02_COLD_OTHERS T
- WHERE T.PROD_LINE = 'S'
- UNION ALL
- SELECT '连退' PROD_LINE
- ,T.STOP_DTIME
- ,T.START_DTIME
- ,T.SUM_
- ,T.EVNET_NM
- ,T.EDT_NM
- ,T.DEPART_NM
- ,T.BAN_CI
- ,T.BAN_ZU
- FROM TBB02_COLD_OTHERS T
- WHERE T.PROD_LINE = 'L'
- UNION ALL
- SELECT '重卷' PROD_LINE
- ,T.STOP_DTIME
- ,T.START_DTIME
- ,T.SUM_
- ,T.EVNET_NM
- ,T.EDT_NM
- ,T.DEPART_NM
- ,T.BAN_CI
- ,T.BAN_ZU
- FROM TBB02_COLD_OTHERS T
- WHERE T.PROD_LINE = 'C'
- ]]>
- </query>
- </queryMap>
|
