XinYu_RZMES/.svn/pristine/ae/ae8d5b4a40f119da95c06f204f7b96da5d5f2538.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炼钢工序类别作业所需时间标准">
	<query id="UIF012031_CHEM_INGR.find" desc="查询1号转炉信息" fetchSize="10">
		
        <![CDATA[
--CREATE  : BY SJW 090828
--VERSION :  V.1.1
--DESC    : 查询客户特殊要求
			    									
SELECT  DISTINCT B.CHARGE_MANA_NO,A.STL_GRD,C.ORD_NO,C.ORD_SEQ,C.CHEM_CD,C.COMP_YN,C.CHEM_MIN,C.CHEM_MAX,C.CHEM_AIM
  FROM  TBF01_SPEC_CHARGE  A
        ,TBF01_SPEC_SLAB   B
        ,TBB01_ORD_INGR    C
WHERE   A.CHARGE_EDT_SEQ   =    B.CHARGE_EDT_SEQ
  AND   B.ORD_NO           =    C.ORD_NO
  AND   B.ORD_SEQ          =    C.ORD_SEQ
  AND   A.STATUS_CD        IN   ('A','B')
  AND   C.DSN_KIND         =    '1'
  AND   A.CHARGE_MANA_NO   =  ?
ORDER BY C.ORD_NO,C.ORD_SEQ	,C.CHEM_CD	
					
        ]]>
    </query> 
    <query id="UIF012031_CHEM_INGR_02.find" desc="查询1号转炉信息" fetchSize="10">
		
        <![CDATA[
--CREATE  : BY WXY 100526
--VERSION :  V.1.1
--DESC    : 中厚板客户特殊要求
			    									
SELECT wmsys.wm_concat(DISTINCT c.SPEC_REQ_DESC) L2DEMO
                     ,substr(c.SLAB_MANA_NO,1,10)  CHARGE_NO
              FROM TBF01_SPEC_SLAB C
              WHERE SPEC_REQ_DESC IS NOT NULL 
              and 	substr(c.SLAB_MANA_NO,1,10) = ?
              GROUP BY substr(c.SLAB_MANA_NO,1,10)
        ]]>
    </query>
</queryMap>