XinYu_RZMES/.svn/pristine/70/7091e10eb661dd51e48611772c8ad6bfec4a6c9d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炼钢工序类别作业所需时间标准">
    <query id="UIF012041_COMM_PATH_CD.find" desc="查询工序路径的信息" fetchSize="10">
		<![CDATA[
			SELECT  SUBSTR(T2.SM_CFNM,1,2)  CD1
			       ,SUBSTR(T2.SM_CFNM,3,2) CD2
			       ,SUBSTR(T2.SM_CFNM,5,2) CD3
			       ,SUBSTR(T2.SM_CFNM,7,2) CD4
			       ,SUBSTR(T2.SM_CFNM,9,2) CD5
			       ,SUBSTR(T2.SM_CFNM,11,2) CD6
			       ,T2.SM_CFNM
			FROM TBF01_SPEC_CHARGE T1
			     ,TBZ00_COMMCD T2
			WHERE T1.CHARGE_MANA_NO = :1 
			AND   T2.LG_CD = 'F01004'
			AND   T1.TREAT_RT_CD = T2.SM_CD         
    	]]>
    </query> 
    <query id="UIF012041_COMM_PATH_CD.save" desc="查询工序路径的信息" fetchSize="10">
		<![CDATA[
			         
    	]]>
    </query>
    <query id="UIF012041_CHG_STLGRD.find" desc="查询工序路径的信息" fetchSize="10">
		<![CDATA[
			SELECT   'false' CHK,
		            B.CAST_MANA_NO,/*   浇次管理号*/
		            B.CAST_CHARGE_SEQ,/*  浇次内顺序*/
		            B.CHARGE_MANA_NO ,/* 炉次管理号*/
		            B.PRC_LINE,
		            B.STL_GRD,/*钢号*/
		            T1.SM_CFNM PROG_CD,/*   进程代码*/
		            T3.SM_CFNM  STATUS_CFNM,/*   状态区分*/
		            A.L2_SEND,/*   L2传送*/
		            B.CHARGE_RT
		      FROM      TBF01_CHARGE_IDX   A, 
		                TBF01_SPEC_CHARGE  B,
		                TBG02_CHARGE_COMM  C,
		                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1,
		                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2,
		                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3,
		          ----------------------------------------------------------------------------
		          --MODIFY: BY SJW 090828
		        --DESC  : 王艳辉要求增加显示客服特殊要求
		        --VERSION:1.8-->1.9
		        (SELECT  DISTINCT B.CHARGE_MANA_NO,'1' DSN_KIND
		          FROM  TBF01_SPEC_CHARGE  A
		            ,TBF01_SPEC_SLAB   B
		            ,TBB01_ORD_HEAD    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.CUST_SPEC_NO_INGR IS NOT NULL)                                      D 
		          -------------------------------------------------------------------------------                               
		      WHERE     'B' = 'B'
		         AND  A.STATUS_CD                IN    ('A')
		         AND  A.PRC_LINE                 =    substr(:1,3,1)/*(转炉标准)*/
		         AND 	A.L2_SEND = 'N'
		         AND  A.CHARGE_EDT_SEQ           =     B.CHARGE_EDT_SEQ
		         AND  B.CHARGE_MANA_NO           =     C.NEW_PLAN_CHARGE_NO(+)
		         AND B.PROG_CD                   =         T1.SM_CD(+)
		         AND B.HCR_CLF                   =         T2.SM_CD
		         AND B.STATUS_CD                 =         T3.SM_CD
		       AND  B.CHARGE_RT                like     '%%'
		     ----------------------------------------------------------  
		     --MODIFY: BY SJW 090828
		     --DESC  : 王艳辉要求增加显示客服特殊要求
		     --VERSION:1.8-->1.9
		         AND B.CHARGE_MANA_NO            =      D.CHARGE_MANA_NO(+)
		     ----------------------------------------------------------  
		          ----------------------------------------------------------  
		      ORDER   BY A.CHG_SEQ  ASC         
    	]]>
    </query>
</queryMap>