| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="出库钢卷查询">
- <query id="UIM010370_01.SELECT" desc="中间库废次品入库管理信息">
- <![CDATA[
- SELECT T1.COIL_NO
- ,T1.SLAB_NO
- ,ZL_NORM_COMM.FZ00_COMM('E01002' ,T1.CUR_PROG_CD) CUR_PROG_CD
- ,T1.SPEC_STL_GRD
- ,T1.STL_GRD
- ,T1.ORD_NO
- ,T1.ORD_SEQ
- ,DECODE(T1.ORD_FL ,'1' ,'订单材' ,'2' ,'余材') ORD_FL
- ,T2.ORD_THK
- ,T2.ORD_WTH
- ,T2.ORD_LEN
- ,T2.ORD_WGT
- ,T1.COIL_INDIA
- ,T1.COIL_OUTDIA
- ,DECODE(T1.TOT_DEC_GRD,'1','合格','2','不合格','3','外观异常','4','废品') TOT_DEC_GRD
- ,DECODE(T1.INGR_DEC_GRD,'0','综合判定取消','1','合格','2','不合格') INGR_DEC_GRD
- ,DECODE(T1.MATLQLTY_DEC_GRD,'0','无性能要','1','合格','2','不合格') MATLQLTY_DEC_GRD
- ,DECODE(T1.SIZE_DEC_RST,'1','合格','2','订单外合格','3','不合格','4','废品') SIZE_DEC_RST
- ,DECODE(T1.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD
- ,DECODE(T1.WGT_DEC_RST,'1','合格','2','不合格') WGT_DEC_RST
- ,TO_CHAR(TO_DATE(T1.MILL_DTIME , 'YYYYMMDDHH24MISS') ,'YYYY-MM-DD HH24:MI:SS') MILL_DTIME
- ,DECODE(T1.YARD_ENTRY_SHIFT,'0','常白班','1','早班','2','中班','3','晚班') YARD_ENTRY_SHIFT
- ,DECODE(T1.YARD_ENTRY_GROUP,'0','常白班','1','甲班','2','乙班','3','丙班','4','丁班') YARD_ENTRY_GROUP
- ,T1.CUR_LOAD_LOC
- ,ZL_NORM_COMM.FZ00_COMM('H02001' ,T1.CRK_CD1) CRK_CD1
- ,ZL_NORM_COMM.FZ00_COMM('H02001' ,T1.CRK_CD2) CRK_CD2
- ,ZL_NORM_COMM.FZ00_COMM('H02001' ,T1.CRK_CD3) CRK_CD3
- ,ZL_NORM_COMM.FZ00_COMM('H02001' ,T1.CRK_CD4) CRK_CD4
- ,ZL_NORM_COMM.FZ00_COMM('H02001' ,T1.CRK_CD5) CRK_CD5
- ,T1.CRK_CD_DESC
- FROM C_TBK02_COIL_COMM T1
- ,TBA01_ORD_LINE T2
- WHERE T1.ORD_NO = T2.ORD_NO(+)
- AND T1.ORD_SEQ = T2.ORD_SEQ(+)
- AND T1.COIL_STAT = '3'
- AND NVL(T1.MILL_DTIME ,'X') BETWEEN NVL(?,'X') AND NVL(?,'X')
- AND T1.COIL_NO LIKE ?||'%'
- ]]>
- </query>>
- </queryMap>
|
