XinYu_RZMES/.svn/pristine/c6/c65ce3cc5382d3627905762dc933ce56fa3f5835.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="出钢参数接收现况分析(中厚板)">
	<query id="UIF023020.findSchMill" desc="求各炉次所接受的热轧板坯参数" fetchSize="10">
        <![CDATA[
		--MODIFY BY SJW 090806 V1.16 -> V1.17	
SELECT A.ROLL_SLAB_SEQ
       ,A.SLAB_EDT_SEQ
	   ,A.SLAB_NO
	 --  ,DECODE(A.YARD_LOCK_YN,NULL,A.SLAB_NO,A.SLAB_NO_DOWN_LOCK) SLAB_NO
       ,A.WTH_AIM
       ,A.HOT_THK_AIM
FROM  TBF02_SCH_MILL  A
 ORDER   BY A. ROLL_SLAB_SEQ  ASC
			
        ]]>
    </query>  
	
	<query id="UIF023020.find_tot" desc="求各炉次所接受的热轧板坯参数" fetchSize="10">
        <![CDATA[
		--add BY SJW 090829 V1.17 -> V1.18	
  SELECT SUM(A.ROLL_SLAB_CNT) ROLL_SLAB_CNT,               --已编制板坯总数量
         SUM(A.ROLL_SLAB_WGT) ROLL_SLAB_WGT,               --已编制板坯总重量
         SUM(A.MILL_LEN )     MILL_LEN                      --轧制总长度
  FROM TBF02_SCH_ROLL  A
			
        ]]>
    </query>  
	
	<query id="UIF023020.findSlabWth" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[
			
			/*求轧制单元板坯宽度结果集 按升序排列  动态生成宽度的刻度*/
       SELECT DISTINCT  T.WTH_AIM 
       FROM TBF02_SCH_MILL T 
       ORDER BY T.WTH_AIM ASC
			
        ]]>
	</query> 
		
	 <query id="UIF023020.findBehindCCRInfos" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[
			
--求轧制单元板坯宽度结果集 按升序排列  动态生成宽度的刻度
--MODIFY BY SJW 090806 V1.16 -> V1.17	
			
SELECT  A.ROLL_SLAB_SEQ,                    -- 轧辊内顺序
        A.CUR_LOAD_LOC,                     -- 堆置位置
	    --DECODE(A.YARD_LOCK_YN,NULL,A.CUR_LOAD_LOC,A.LOAD_LOC_DOWN_LOCK)  CUR_LOAD_LOC,
	    A.SLAB_NO,
        --A.SLAB_EDT_SEQ,DECODE(A.YARD_LOCK_YN,NULL,A.SLAB_NO,A.SLAB_NO_DOWN_LOCK) SLAB_NO, --板坯号
        A.SLAB_THK,                         --板坯厚度
        A.SLAB_WTH  ,                       --板坯宽度
        A.SLAB_LEN  ,                       --板坯长度
        A.SLAB_WGT  ,                       --板坯重量 
		---------------------------------------------	
		--MODIFY BY SJW 090829
		-- DESC  ：吴部长要求显示订单规格信息
		-- version： V1.17 -> V1.18	  		
        B.ORD_THK,                          -- 订单厚度			
		B.ORD_WTH,                          --订单宽度	
		----------------------------------------------	
        A.HOT_THK_AIM    ,                  --热厚度AIM
        A.HOT_THK_MIN    ,                  --热厚度MIN
        A.HOT_THK_MAX    ,                  --热厚度MAX
        A.WTH_AIM    ,                      --宽度AlM
        A.WTH_MIN    ,                      --宽度MIN
        A.WTH_MAX    ,                      --宽度MAX  
        A.MILL_LEN,                         --轧制长度
        A.MILL_WGT,                         --轧制重量
        A.SPEC_ABBSYM,                      -- 标准号
        A.ORD_NO,                           -- 合同号
        A.ORD_SEQ,                          -- 订单号
        T1.SM_CFNM  CUST_CD,                -- 客户公司代码
        A.STL_GRD,                          -- 钢码
        B.DEL_TO_DATE,                    
        B.EMGMTR_NMG_CLF,               
        T2.SM_CFNM  ROUTE                   -- 去向
	    ,T3.SM_CFNM  DLIV_TP                --发货方式
FROM   TBF02_SCH_MILL                                                              A,
       TBE02_ORD_PRC                                                               B,
       (SELECT T.CUST_CD SM_CD, T.CUST_NM SM_CFNM    FROM TBZ00_CUSTOMER T)        T1,
       (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004')    T2
	   ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012')        T3
	   ,TBA01_ORD_LINE                                                        A01
            WHERE A.ORD_NO        = A01.ORD_NO(+)
              AND A.ORD_SEQ       = A01.ORD_SEQ(+)  
              AND A01.DLIV_TP       =  T3.SM_CD(+) 
    AND  A.ORD_NO     =    B.ORD_NO
    AND  A.ORD_SEQ    =    B.ORD_SEQ
    AND  A.CUST_CD    =    T1.SM_CD
    AND  A.ROUTE    =    T2.SM_CD
    AND  A.ROLL_SLAB_SEQ >= ?
 ORDER   BY A. ROLL_SLAB_SEQ  ASC
			
        ]]>
    </query> 
	
	<query id="UIF023020.findSlabThk" desc="求轧制单元轧制厚度结果集 按升序排列 动态生成轧制厚度的刻度" fetchSize="10">
        <![CDATA[
			
			/*求轧制单元轧制厚度结果集 按升序排列*/
       SELECT DISTINCT T.HOT_THK_AIM
       FROM TBF02_SCH_MILL T 
       ORDER BY T.HOT_THK_AIM ASC
			
        ]]>
    </query>	
	<query id="callUIF023020" desc="사원추가" fetchSize="1">
        <![CDATA[
            {call UIF023020_TEST.CCR_POSITION_OPERATE(?,?,?,?,?,?)}
        ]]>
    </query>
	<query id="callCCRIndicationSave" desc="CCR材料轧辊编制指示确定MAIN" fetchSize="1">
        <![CDATA[
            {call UIF023020_TEST.CCR_INDICATION(?,?,?,?,?)}
        ]]>
    </query>
	<query id="callCCR_IndicationDealAfterCallNIE" desc="CCR材料轧辊编制指示确定MAIN" fetchSize="1">
        <![CDATA[
            {call UIF023020_TEST.DEAL_AFTER_INSERT(?)}
        ]]>
    </query>
	
	<query id="callCCR_SLAB_ORD_REP" desc="跺位替换" fetchSize="1">
        <![CDATA[
            {call UIF023010.SLAB_ORD_REP(?,?)}
        ]]>
    </query>
	
	<query id="NIF012140_SlabInf.select" desc="CCR材料轧辊编制指示确定MAIN" fetchSize="1">
        <![CDATA[
			
			SELECT   A.SLAB_NO           
                    ,A.SLAB_WGT
                    ,A.ORD_NO
                    ,A.ORD_SEQ
              FROM  TBG02_SLAB_COMM A, TBF02_SCH_MILL B
             WHERE  A.SLAB_NO  =     B.SLAB_NO
             ORDER  BY  B.ROLL_SLAB_SEQ
        ]]>
    </query>
	
</queryMap>