| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="酸洗成品库入库管理">
- <query id="UIM060030_11.SELECT" desc="查询酸洗待入库钢卷信息">
- <![CDATA[
- SELECT 'FALSE' CHK,
- T.OLD_SAMPL_NO COIL_NO,
- T.COIL_THK THICK,
- T.COIL_WTH WIDTH,
- T.COIL_LEN LENGTH,
- T.ACT_WGT WEIGHT,
- T.SPEC_STL_GRD,
- DECODE(T.CUR_PROG_CD,
- 'CCA',
- '连退作业指示待机',
- 'CRC',
- '充当待机',
- 'DBA',
- '重卷指示待机',
- 'DBB',
- '重卷作业待机',
- 'DCA',
- '包装指示待机',
- 'DCB',
- '包装作业待机',
- 'DED',
- '综合判定待机',
- 'DFA',
- '发货指示待机',
- 'DFB',
- '发货待机') CUR_PROG_CD,
- T.ORD_NO,
- T.ORD_SEQ,
- C_PKG_UIM.GET_STDDATESTR(T.MILL_DTIME) PRODUCTED_TIME,
- decode(T.CAL_TYPE,'2','√','3','√') RCAL
- FROM C_TBL02_COIL_COMM T
- WHERE T.COIL_STAT = '2'
- AND T.CUR_LOAD_LOC IS NULL
- AND T.LINE_TP='S'
- --AND SUBSTR(T.MILL_DTIME,1,8)||'&' LIKE :1||'%'
- AND SUBSTR(T.MILL_DTIME,1,8)>=NVL(:1,'00000000' )
- AND SUBSTR(T.MILL_DTIME,1,8)<=NVL(:2,'99999999' )
- AND T.OLD_SAMPL_NO||'&' LIKE :3||'%'
- order by T.MILL_DTIME desc
- ]]>
- </query>
- </queryMap>
|
