XinYu_LZMES/.svn/pristine/be/bec1d22f0cc10056e7f85b8620fe1b9b55708be7.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="">
	<query id="UIM040020_01.SELECT"  desc="下线入库">
		<![CDATA[
		SELECT T.COIL_NO,
		       T.SPEC_STL_GRD,
		       T.COIL_THK,
		       T.COIL_WTH,
		       T.ACT_WGT,
		       T.ORD_NO,
		       T.ORD_SEQ,
		       T.INSTR_COIL_THK ORD_THK,
		       T.INSTR_COIL_WTH ORD_WTH
		  FROM C_TBL02_COIL_COMM T
		 WHERE T.COIL_STAT = '2'
		   AND T.CUR_LOAD_LOC IS NULL
		   AND C_PKG_UIM.GET_DATE(T.MILL_DTIME) > SYSDATE - 3
		 ]]>
	</query>
	<query id="UIM040020_02.SELECT"  desc="连退上料">
		<![CDATA[
		SELECT T.COIL_NO,
		       T.SPEC_STL_GRD,
		       T.COIL_THK,
		       T.COIL_WTH,
		       T.ACT_WGT,
		       T.ORD_NO,
		       T.ORD_SEQ,
		       T.INSTR_COIL_THK ORD_THK,
		       T.INSTR_COIL_WTH ORD_WTH,
		       T.CUR_LOAD_LOC,
		       F.CAL_NO,
		       F.CAL_COIL_SEQ
		  FROM C_TBL02_COIL_COMM T, L_TBF03_SPEC_MILL F
		 WHERE T.COIL_NO = F.C_COIL_NO
		   AND F.STATUS_CD = 'A'
		   AND T.COIL_STAT = '2'
		   AND T.CUR_PROG_CD = 'CCB'
		 ORDER BY F.CAL_NO, F.CAL_COIL_SEQ
		 ]]>
	</query>
	<query id="UIM040020_03.SELECT"  desc="酸轧发运">
		<![CDATA[
		SELECT T.COIL_NO,
		       T.SPEC_STL_GRD,
		       T.COIL_THK,
		       T.COIL_WTH,
		       T.ACT_WGT,
		       T.ORD_NO,
		       T.ORD_SEQ,
		       T.INSTR_COIL_THK ORD_THK,
		       T.INSTR_COIL_WTH ORD_WTH,
		       T.CUR_LOAD_LOC,
		       T.DLIV_DIRNO,
		       T.TRANS_CAR_NO TRANS_CARNO
		  FROM C_TBL02_COIL_COMM T
		 WHERE T.COIL_STAT = '2'
		   AND T.CUR_PROG_CD = 'DFB'
		 ORDER BY T.DLIV_DIRNO,T.COIL_NO
		 ]]>
	</query>
</queryMap>