| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="充当结果删除">
- <query id="NIE031040.Job.Update" desc="">
- <![CDATA[
- UPDATE TBE05_JOB SET
- PRC_EDTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS'),
- PRC_STS = 'C', -- 进程状态
- PRC_NEED_ID = ? -- 参数：REG_ID
- WHERE PLT = 'R' -- 工厂
- AND MAIN_PGMID = 'NIE031000' -- 主程序 ID
- ]]>
- </query>
- <query id="NIE031040.JobDet.Update" desc="">
- <![CDATA[
- UPDATE TBE05_JOB_DET SET
- PRC_SDTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS'),
- PRC_EDTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS'),
- PRC_STS = 'C' -- 进程状态
- WHERE PLT = 'R' -- 工厂
- AND MAIN_PGMID = 'NIE031000' -- 主程序 ID
- AND SEQ = 3
- ]]>
- </query>
- <query id="NIE031040.RepSlab.Delete" desc="">
- <![CDATA[
- DELETE TBE04_REP_SLAB
- ]]>
- </query>
- <query id="NIE031040.RepSlabD.Delete" desc="">
- <![CDATA[
- DELETE TBE04_REP_SLAB_D
- ]]>
- </query>
- <query id="NIE031040.RepCoil.Delete" desc="">
- <![CDATA[
- DELETE TBE04_REP_COIL
- ]]>
- </query>
- <query id="NIE031040.RepCoilD.Delete" desc="">
- <![CDATA[
- DELETE TBE04_REP_COIL_D
- ]]>
- </query>
- <query id="NIE031040.RepOrd.Delete" desc="">
- <![CDATA[
- DELETE TBE04_REP_ORD
- ]]>
- </query>
- </queryMap>
|
