XinYu_RZMES/.svn/pristine/81/816c88f650a93cc7c333a4b448e66b8bd31efd34.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Status Charge Select">
              
   <query id="NIE012081_OrdNo.select" desc="it's query from TBF01_SPEC_SLAB, TBF01_SPEC_SLAB_D Table" fetchSize="10">
        <![CDATA[
			SELECT  B.ORD_NO                                    
				   ,B.ORD_SEQ                                   
			  FROM  TBF01_SPEC_SLAB   A
			       ,TBF01_SPEC_SLAB_D B     
			 WHERE  A.CHARGE_MANA_NO  =   ?                   
			   AND  A.SLAB_EDT_SEQ    =   B.SLAB_EDT_SEQ 
			   AND  A.ORD_FL          =   '1'
			   AND  B.ORD_FL          =   '1' 
			   AND  B.ORD_NO          IS  NOT NULL    
			 GROUP  BY  B.ORD_NO                               
			           ,B.ORD_SEQ   
		]]>
    </query>

   <query id="NIE012081_ProgCd.select" desc="it's query from TBZ00_COMMCD Table" fetchSize="10">
        <![CDATA[
			SELECT  SM_CD                                
			  FROM  TBZ00_COMMCD                         
			 WHERE  LG_CD    =        'E01002'           
			   AND  SM_CD    BETWEEN  'JAA'  AND  'JZZ'  
			 ORDER  BY  CD_SEQ   ASC   
		]]>
    </query>

   <query id="NIE012081_OrdWgt.select" desc="it's query from TBZ00_COMMCD Table" fetchSize="10">
        <![CDATA[
			SELECT  SUM(A.ORD_WGT) ORD_WGT                  
		      FROM  TBF01_SPEC_SLAB_D A                     
		           ,TBF01_SPEC_SLAB   B                   
			       ,TBF01_SPEC_CHARGE C                      
			 WHERE  A.ORD_NO           =  ?                  
			   AND  A.ORD_SEQ          =  ?                  
			   AND  A.ORD_FL           =  '1'                
			   AND  C.STATUS_CD        <> 'C'        --2010年4月22日 王黎修改 A.STATUS_CD修改为C.STATUS_CD  解决工序计划下发到生产管制时产生的多余进程量      
			   AND  B.SLAB_EDT_SEQ     =  A.SLAB_EDT_SEQ     
			   AND  C.CHARGE_EDT_SEQ   =  B.CHARGE_EDT_SEQ   
			   AND  C.PROG_CD          =  ?   
		]]>
    </query>
	
</queryMap>