XinYu_RZMES/.svn/pristine/f1/f1932823211515f32115784dce676798df3cdab2.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Status Coil Select">

	<query id="NIE012083_OrdNo.select" desc="it's query from TBH02_COIL_COMM_D Table" fetchSize="10">
        <![CDATA[
			SELECT  A.ORD_NO               
			       ,A.ORD_SEQ              
			  FROM  TBH02_COIL_COMM_D A   
			  		,TBH02_COIL_COMM B 
			 WHERE  B.COIL_NO  =   ?  
			 AND 	A.COIL_NO = B.COIL_NO
			   AND  A.ORD_NO   IS  NOT NULL      
			 GROUP  BY  A.ORD_NO           
			           ,A.ORD_SEQ           
		]]>
	 </query>

	<query id="NIE012083_OrdWgtSFF.select" desc="it's query from TBH02_COIL_COMM_D, TBH02_COIL_COMM Table" fetchSize="10">
        <![CDATA[
			SELECT  SUM(B.ACT_WGT) ORD_WGT        
			  FROM  TBH02_COIL_COMM_D A         
			       ,TBH02_COIL_COMM   B           
			 WHERE  A.ORD_NO       =  ?           
			   AND  A.ORD_SEQ      =  ?           
			   AND  A.ORD_FL       =  '1'         
			   AND  A.COIL_NO      =  B.COIL_NO   
			   AND  B.ORD_FL       =  '1'         
			   AND  B.COIL_STAT    =  '3'         
               AND  B.CUR_PROG_CD  =  ?           
		]]>
	 </query>

    <query id="NIE012083_OrdWgt.select" desc="it's query from TBH02_COIL_COMM_D, TBH02_COIL_COMM Table" fetchSize="10">
        <![CDATA[
			
           -- SELECT  SUM(A.ORD_WGT) ORD_WGT 
		   -----------------------------------------------------------------
		   --MODIFY BY SJW 090821
		   --DESC   :A.ORD_WGT 为订单指示重量即为订单单重
		   --       ：ACT_WGT  为钢卷实际重量   	
			SELECT  SUM(B.ACT_WGT) ORD_WGT 
		   -----------------------------------------------------------------       
              FROM  TBH02_COIL_COMM_D A         
                   ,TBH02_COIL_COMM   B           
             WHERE  A.ORD_NO       =  ?           
               AND  A.ORD_SEQ      =  ?           
               AND  A.ORD_FL       =  '1'         
               AND  A.COIL_NO      =  B.COIL_NO   
               AND  B.ORD_FL       =  '1'         
               AND  B.COIL_STAT    =  '2'         
               AND  B.CUR_PROG_CD  =  ?           
        ]]>
     </query>

    <query id="NIE012083_BefOrdWgtSFF.select" desc="it's query from TBH02_COIL_COMM_D, TBH02_COIL_COMM Table" fetchSize="10">
        <![CDATA[
           -- SELECT  SUM(A.ORD_WGT) ORD_WGT 
		   -----------------------------------------------------------------
		   --MODIFY BY SJW 090821
		   --DESC   :A.ORD_WGT 为订单指示重量即为订单单重
		   --       ：ACT_WGT  为钢卷实际重量   	
			SELECT  SUM(B.ACT_WGT) ORD_WGT 
		   -----------------------------------------------------------------     
              FROM  TBH02_COIL_COMM_D A,          
                    TBH02_COIL_COMM   B           
             WHERE  A.ORD_NO       =  ?           
               AND  A.ORD_SEQ      =  ?           
               AND  A.ORD_FL       =  '1'         
               AND  A.COIL_NO      =  B.COIL_NO   
               AND  B.ORD_FL       =  '1'         
               AND  B.COIL_STAT    =  '3'         
               AND  B.CUR_PROG_CD  =  ?           
        ]]>
     </query>
		
	<query id="NIE012083_BefOrdWgt.select" desc="it's query from TBH02_COIL_COMM_D, TBH02_COIL_COMM Table" fetchSize="10">
        <![CDATA[
			--SELECT  SUM(A.ORD_WGT) ORD_WGT   
		   -----------------------------------------------------------------
		   --MODIFY BY SJW 090925
		   --DESC   :A.ORD_WGT 为订单指示重量即为订单单重
		   --       ：ACT_WGT  为钢卷实际重量   	
			SELECT  SUM(B.ACT_WGT) ORD_WGT 
		   -----------------------------------------------------------------         
			  FROM  TBH02_COIL_COMM_D A,          
			        TBH02_COIL_COMM   B           
			 WHERE  A.ORD_NO       =  ?           
			   AND  A.ORD_SEQ      =  ?           
			   AND  A.ORD_FL       =  '1'         
			   AND  A.COIL_NO      =  B.COIL_NO   
			   AND  B.ORD_FL       =  '1'         
			   AND  B.COIL_STAT    =  '2'         
               AND  B.CUR_PROG_CD  =  ?           
		]]>
	 </query>
	
</queryMap>