| 1234567891011121314151617181920212223242526272829303132333435 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="综合判定不合格品判定">
- <query id="UIB020237_01.SELECT" desc="判定">
- SELECT '' CHK
- ,T.COIL_NO
- ,T.OLD_SAMPL_NO
- ,T.PRODNM_CD
- ,T.SPEC_ABBSYM
- ,T.SPEC_STL_GRD
- ,T.COIL_THK
- ,T.SAMPL_NO
- ,T.SLAB_NO
- ,T.COIL_THK
- ,T.SIZE_DEC_RST
- ,T.EXTSHAPE_DEC_GRD
- ,T.WGT_DEC_RST
- ,T.INGR_DEC_GRD
- ,T.MATLQLTY_DEC_GRD
- ,T.TOT_DEC_GRD
- FROM TBH02_COIL_COMM T
- WHERE T.COIL_STAT = '2'
- AND T.ORD_FL = '2'
- AND T.COIL_DEFECTIVE IS NULL
- AND T.SPEC_ABBSYM IS NOT NULL --不允许标准号为空
- AND T.SPEC_STL_GRD IS NOT NULL
- AND T.ORD_USE_CD IS NOT NULL
- AND (T.SMP_STATS IS NULL OR T.SMP_STATS = '3') --必须改判申请完成或者没有进行改判
- </query>
-
- <query id = "UIB020237_01.CALL" desc="判定">
- {call ZL_HOST_DCS03.YUCAI_DCS_TOTL(?,?) }
- </query>
-
- </queryMap>
|
