XinYu_LZMES/.svn/pristine/c8/c810142952c1b5bb28994eed0aed624c93466dc6.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">
	<query id="UIECOMM00_SELECT.ORD_SEQ" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT 'ORD_SEQ' LG_CD
			       ,'订单序号' LG_NM
			       ,'' SM_CD
			       ,'全部' SM_CFNM FROM DUAL
			UNION ALL
			SELECT 'ORD_SEQ'     LG_CD
			       ,'订单序号'   LG_NM
			       ,ORD_SEQ      SM_CD
			       ,ORD_SEQ      SM_NM    
			FROM TBE02_ORD_PRC
			WHERE ORD_NO = ?  -- 合同号
		]]>
	</query>
	
	<query id="UIECOMM00_SELECT.OPT_HIS" desc="订单号" fetchSize="10">
		<![CDATA[
			INSERT INTO TBE04_OPT_HIS (SEQ_ID,
                                       OPT_TYP,
                                       REG_ID,
                                       REG_PGM_ID,
                                       REG_DATE,
                                       REG_SHIFT,
                                       REG_GROUP,
                                       RESERVE_FIELD1,
                                       RESERVE_FIELD2,
                                       RESERVE_FIELD3,
                                       RESERVE_FIELD4,
                                       RESERVE_FIELD5,
                                       RESERVE_FIELD6,
                                       RESERVE_FIELD7,
                                       RESERVE_FIELD8,
                                       RESERVE_FIELD9,
                                       RESERVE_FIELD10,
                                       RESERVE_FIELD11,
                                       RESERVE_FIELD12,
                                       RESERVE_FIELD13,
                                       RESERVE_FIELD14,
                                       RESERVE_FIELD15)
                 VALUES (TBE04_OPT_HIS_SEQ.NEXTVAL,
                         :1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:14,:15,:16,:17,:18,:19,:20,:21)
		]]>
	</query> 
	
	
	
	<query id="UIECOMM00_SELECT.CUST_CD" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT 'CUST_CD' LG_CD
	               ,'客户名称' LG_NM
	               ,'' SM_CD
	               ,'全部' SM_CFNM FROM DUAL
			UNION ALL
			SELECT 'CUST_CD' LG_CD
			       ,'客户名称' LG_NM
			       ,CUST_CD SM_CD
			       ,CUST_NM SM_CFNM                        
			FROM(                                                                                       
			SELECT * FROM (                                                                           
			        SELECT CUST_CD, CUST_NM                                                     
			        FROM TBZ00_CUSTOMER                                                         
			        ORDER BY CUST_NM)                                                             
			)
		]]>
	</query>
	<query id="UIECOMM00_SELECT.C_STL_GRD" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT 'C_STL_GRD' LG_CD
			       ,'冷轧牌号' LG_NM
			       ,'' SM_CD
			       ,'全部' SM_CFNM FROM DUAL
			UNION ALL
			SELECT LG_CD,LG_NM,SM_CD,SM_CD SM_CFNM FROM(                                                  
			        SELECT DISTINCT C_SPEC_STL_GRD SM_CD
			        ,'C_STL_GRD' LG_CD 
			        ,'冷轧牌号' LG_NM             
			        FROM TBB01_KEY_PROD                                                                 
			                                                                                             
			        ORDER BY C_SPEC_STL_GRD       
			        )
		]]>
	</query>
	
	<query id="UIECOMM00_SELECT.CAL_COILNO">
	 <![CDATA[
	   SELECT T.C_COIL_NO SM_CD
             ,T.C_COIL_NO SM_CFNM
             ,'COIL_NO' LG_CD 
             ,'连退待机卷' LG_NM 
      FROM  L_TBF03_SPEC_MILL T
            ,C_TBC02_COIL_COMM T1
      WHERE T.C_COIL_NO = T1.ORI_OLD_SAMPL_NO
      AND   T.STATUS_CD IN ('B','C')
      order by t.CAL_COIL_SEQ
	 ]]>
	</query>
	
	<query id="UIECOMM00_SELECT.RECOIL_NO">
	 <![CDATA[
	   SELECT      T.C_COIL_NO SM_CD
                 ,T.C_COIL_NO SM_CFNM
                 ,'REEL_NO' LG_CD 
                 ,'重卷待机卷' LG_NM 
    FROM  L_TBF03_SPEC_REEL T
          ,C_TBC02_COIL_COMM T1
    WHERE T.C_COIL_NO = T1.ORI_OLD_SAMPL_NO
    AND   T.STATUS_CD IN ('B','C')
    order by t.COIL_EDT_SEQ
	 ]]>
	</query>
	
	<query id="UIECOMM00_SELECT.CAL_MANA_NO" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT  	 CAL_NO SM_CD
			             ,CAL_NO SM_CFNM
			             ,'CAL_NO' LG_CD 
			             ,'连退单元号' LG_NM  
			FROM (
			SELECT T.CAL_NO FROM L_TBF03_SPEC_CAL T
			ORDER BY T.CAL_NO DESC)
			WHERE  ROWNUM < 10
		]]>
	</query>
	
	<query id="UIECOMM00_SELECT.REEL_MANA_NO" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT     CAL_NO SM_CD
	                   ,CAL_NO SM_CFNM
	                   ,'REEL_NO' LG_CD 
	                   ,'连退单元号' LG_NM  
	      FROM (
	      SELECT T.CAL_NO FROM L_TBF03_SPEC_reel T
	      ORDER BY T.CAL_NO DESC)
	      WHERE  ROWNUM < 10
		]]>
	</query>
	
	<query id="UIECOMM00_SELECT.H_STL_GRD" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT 'H_STL_GRD' LG_CD
			       ,'热轧牌号' LG_NM
			       ,'' SM_CD
			       ,'全部' SM_CFNM FROM DUAL
			UNION ALL
			SELECT LG_CD,LG_NM,SM_CD,SM_CD SM_CFNM FROM(                                                  
						        SELECT DISTINCT SPEC_STL_GRD SM_CD
						        ,'H_STL_GRD' LG_CD 
						        ,'热轧牌号' LG_NM             
						        FROM TBB01_KEY_PROD                                                                 
						                                                                                             
						        ORDER BY SPEC_STL_GRD       
						        )
		]]>
	</query>
	
	<query id="UIECOMM00_SELECT.COMM_CODE" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT T.LG_CD,T.LG_NM,T.SM_CD,T.SM_CFNM                                                       
			FROM TBZ00_COMMCD T                                                                           
			WHERE T.LG_CD IN (SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(:1) AS TABSTR_T))) 
			UNION ALL                                                                                     
			SELECT LG_CD,LG_NM,SM_CD,SM_CD SM_CFNM FROM(                                                  
			        SELECT DISTINCT SPEC_STL_GRD SM_CD,'H_STL_GRD' LG_CD ,'热轧牌号' LG_NM               
			        FROM TBB01_KEY_PROD                                                                   
			                                                                                              
			        ORDER BY SPEC_STL_GRD                                                                 
			)
		]]>
	</query>
</queryMap>