XinYu_LZMES/.svn/pristine/14/1422b277e3078a5417b1c11202a21e5f67c3bac4.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="成品库入库管理">
	<query id="UIM010200_01.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,
		              'DDB',
		              '成品库入库待机',
		              'DRC',
		              '连退卷充当待机',
		              '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_TBC02_COIL_COMM T
		 WHERE T.COIL_STAT = '2'
		   AND T.CUR_LOAD_LOC IS NULL
		   AND nvl(T.SHIP_PROG_CD,'00') <>'06'--排除排车状态清除垛位的卷
		   --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||'%'
		 ]]>
	</query>
</queryMap>