| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="中间库废次品入库管理">
- <query id="UIM010360_01.SELECT" desc="中间库废次品入库管理信息">
- <![CDATA[
- select
- 'FALSE' CHK,
- A.OLD_SAMPL_NO,--钢卷号
- TO_CHAR(A.COIL_THK,'FM990.099')||'*'||A.COIL_WTH T_W, --钢卷规格
- TO_CHAR(A.INSTR_COIL_THK,'FM990.099')||'*'||A.INSTR_COIL_WTH IT_IW, --订单规格
- A.SPEC_STL_GRD, --牌号
- A.COIL_INDIA, --钢卷内径
- A.COIL_OUTDIA, --钢卷外径
- A.ACT_WGT, --钢卷重量
- C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME,--入库时间
- (SELECT USERNAME
- FROM CORE_APP_USER U
- WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG,--入库人
- DECODE(A.YARD_ENTRY_SHIFT,
- '0',
- '常白班',
- '1',
- '早班',
- '2',
- '中班',
- '3',
- '晚班') YARD_ENTRY_SHIFT,--入库班次
- DECODE(A.YARD_ENTRY_GROUP,
- '0',
- '常白班',
- '1',
- '甲班',
- '2',
- '乙班',
- '3',
- '丙班',
- '4',
- '丁班') YARD_ENTRY_GROUP,--入库班组
- DECODE(A.EXTSHAPE_QUALITY,
- 'FP',
- '废品',
- 'CP',
- '次品'
- ) EXTSHAPE_QUALITY, --废次品分类
- DECODE(a.TOT_DEC_GRD,'1','合格','2','不合格',null,'待判定') TOT_DEC_GRD, --综合判定
- DECODE(CUR_PROG_CD,
- 'CRC','酸轧卷充当待机',
- 'DBA','重卷指示待机',
- 'DBB','重卷作业待机',
- 'DCA','包装指示待机',
- 'DCB','包装作业待机',
- 'DED','综合判定待机',
- 'DFA','发货指示待机',
- 'DFB','发货待机',
- 'CCA','连退作业指示待机',
- 'CCB','连退作业待机',
- 'CCC','连退卷取待机' ) CUR_PROG_CD, --进程状态
- DECODE(A.CAL_TYPE,'1','酸轧卷','2','返修卷','3','过渡卷') RCAL, --钢卷标识
- (SELECT T.SM_CFNM
- FROM TBZ00_COMMCD T
- WHERE T.LG_CD = 'E01010'
- AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD,--余材原因
- C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME --轧制时间
- FROM C_TBL02_COIL_COMM A
- WHERE '1' = '1'
- AND A.OLD_SAMPL_NO || '&' LIKE ? || '%'
- AND SUBSTR(A.MILL_DTIME,1,8)||'&' LIKE ?||'%'
- AND A.COIL_STAT = '2'
- AND A.EXTSHAPE_QUALITY IN('FP','CP')
- AND A.CUR_LOAD_LOC IS NULL
- ]]>
- </query>>
- </queryMap>
|
