XinYu_LZMES/.svn/pristine/8e/8e6f39f9230fd2cdb1e40d9fc4644f1e2389822e.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="">

<query id="UIF061090.Query_RollPlan_List" desc='获得可调整的轧制单元信息'>
	SELECT A.REG_DTIME,A.ROLL_EDT_SEQ,A.ROLL_MANA_NO,SUM(1) ROLL_COIL_CNT,
	SUM(B.COIL_WGT) ROLL_COIL_WGT,
	SUM(CASE WHEN B.STATUS_CD IN('A','B','C') THEN 1 ELSE 0 END) RES_ROLL_COIL_CNT,
	SUM(CASE WHEN B.STATUS_CD IN('A','B','C') THEN B.COIL_WGT ELSE 0 END) RES_ROLL_COIL_WGT,
	SUM(CASE WHEN B.STATUS_CD ='D' THEN 1 ELSE 0 END) END_COIL_CNT,
	SUM(CASE WHEN B.STATUS_CD ='D' THEN B.COIL_WGT ELSE 0 END) END_COIL_WGT,
	'FALSE' CHK,DECODE(A.L2_SEND,'N','未下发','已下发') L2_SEND  
	FROM S_TBF03_SPEC_ROLL A,S_TBF03_SPEC_MILL B 
	WHERE A.ROLL_MANA_NO=B.ROLL_MANA_NO AND A.STATUS_CD IN('A','B')
	GROUP BY A.REG_DTIME,A.ROLL_EDT_SEQ,A.ROLL_MANA_NO,A.L2_SEND 
	ORDER BY LPAD(TO_CHAR(A.ROLL_EDT_SEQ),5,'0')
</query>

<query id="UIF042020.Query_RollNO" desc='获得可调整的轧制单元号'>
	SELECT ROLL_MANA_NO NAME_,ROLL_MANA_NO ID_ FROM S_TBF03_SPEC_ROLL 
	WHERE T.STATUS_CD IN ('A','B') 
	ORDER BY LPAD(TO_CHAR(ROLL_EDT_SEQ),3,'0')
</query>

<query id="UIF061090.Del_RollUnit" desc="删除轧辊单元计划信息" >
		<![CDATA[
			{call S_PKG_UIF.C_PRD_ROLLUNIT_DEL(?,?,?)}
		]]>
</query>

<query id="UIF061090.Adj_RollUnit" desc="调整轧辊单元计划顺序" >
		<![CDATA[
			{call S_PKG_UIF.C_PRD_ROLLUNIT_ADJ(?,?,?,?)}
		]]>
</query>

<query id="UIF061090.Sed_RollUnit" desc="下发轧辊单元计划" >
		<![CDATA[
			{call S_PKG_UIF.C_PRD_ROLLUNIT_SND(?,?)}
		]]>
</query>
<query id="UIF061090.Usd_RollUnit" desc="撤销下发轧辊单元计划" >
		<![CDATA[
			{call S_PKG_UIF.C_PRD_ROLLUNIT_USN(?,?,?)}
		]]>
</query>
</queryMap>