| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="钢卷改判申请">
- <query id="UIB020251_01.SELECT" desc="">
-
- SELECT 'N' CHK
- ,CCM.OLD_SAMPL_NO
- ,CCM.COIL_NO
- ,CCM.SAMPL_NO
- ,CCM.SAMPL_CUT_LOC
- ,CCM.PRODNM_CD
- ,CCM.SPEC_ABBSYM
- ,CCM.SPEC_STL_GRD
- ,CCM.BEF_SPEC_ABBSYM
- ,CCM.BEF_SPEC_STL_GRD
- ,CCM.DCS_THK
- ,CCM.INGR_DEC_GRD
- ,CCM.MATLQLTY_DEC_GRD
- ,CCM.SIZE_DEC_RST
- ,CCM.EXTSHAPE_DEC_GRD
- ,CCM.TOT_DEC_GRD
- ,CCM.WGT_DEC_RST
- ,CCM.COIL_WTH
- ,CCM.COIL_THK
- ,CCM.ORD_USE_CD
- FROM TBH02_COIL_COMM CCM
- WHERE CCM.ORD_FL = '2'
- AND CCM.COIL_STAT = '2'
- AND CCM.MISSNO_CLF_CD IS NULL
- AND CCM.SMP_STATS IS NULL
- ORDER BY CCM.OLD_SAMPL_NO
-
- </query>
-
- <query id="UIB020251_01.UPDATE" desc="改判">
- UPDATE TBH02_COIL_COMM CCM
- SET PRODNM_CD = ?
- ,SPEC_ABBSYM = ?
- ,SPEC_STL_GRD = ?
- ,ORD_USE_CD = ?
- ,CHANGE_SPEC_ID = ?
- ,CHANGE_SPEC_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- ,BEF_SPEC_ABBSYM = DECODE(CCM.BEF_SPEC_ABBSYM , NULL , CCM.SPEC_ABBSYM , CCM.BEF_SPEC_ABBSYM)
- ,BEF_SPEC_STL_GRD = DECODE(CCM.BEF_SPEC_STL_GRD , NULL , CCM.SPEC_STL_GRD , CCM.BEF_SPEC_STL_GRD)
- ,SMP_STATS = '0' --表示未生成试样指示信息
- ,QK_YN = 'N'
- ,COIL_DEFECTIVE = NULL
- WHERE COIL_NO = ?
- AND COIL_STAT = '2'
- AND ORD_FL = '2'
- AND SMP_STATS IS NULL
- </query>
- </queryMap>
|
