XinYu_RZMES/.svn/pristine/3b/3bd055d19ec6437db77fde1d30f181c235fe53e3.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="出钢参数接收现况分析(中厚板)">
	<query id="UIF023100.findSlabChart" desc="求各炉次所接受的热轧板坯参数" fetchSize="10">
        <![CDATA[			
/*********************************生成转炉-->切割待机正在作业板坯信息图表****************************/

SELECT      A.Charge_Edt_Seq,
            A.CHARGE_MANA_NO,
            B.Chg_Seq,
            C.SLAB_EDT_SEQ, /*板坯编制号*/
            C.SLAB_EDT_SEQ,     /*板坯编号*/
/*            C.ORD_WTH,     \*slab宽度*\
            C.ORD_THK,     \*轧制厚度*\*/
            D.WTH_AIM,
            D.HOT_THK_AIM,
            C.HCR_CLF,       /*热装状态*/
            C.ORD_FL
FROM        TBF01_SPEC_CHARGE  A, 
            TBF01_CHARGE_IDX B, 
            TBF01_SPEC_SLAB C,
            TBB01_ORD_PROD D
WHERE       A.STATUS_CD              IN   ('B')
 AND        C.ORD_NO = D.ORD_NO(+)
 AND        C.ORD_SEQ = D.ORD_SEQ(+)
 AND        A.CHARGE_EDT_SEQ    =     B.CHARGE_EDT_SEQ
 AND        A.PROG_CD          >='JBB'
 AND        A.CHARGE_EDT_SEQ    =     C.CHARGE_EDT_SEQ
ORDER   BY  A.PRE_CCM_END_DTIME  ASC,
           C.CHARGE_SLAB_SEQ ASC
			
/*************************************************************************************/
			
        ]]>
    </query>  
	
   <query id="UIF023100.FindChargeChart" desc="求轧辊编制号" fetchSize="10">
        <![CDATA[
			
			/*desc：得到所有的轧辊编制号的combo组*/	
SELECT T.CHARGE_EDT_SEQ,
       T.CHARGE_MANA_NO,
       B.PRE_CCM_END_DTIME,
       B.HCR_CLF,
       B.MILL_FL,
       T1.SM_CFNM PROG_CD,/*   进程代码*/
       COUNT(A.SLAB_EDT_SEQ) ROLL_SLAB_CNT
  FROM TBF01_CHARGE_IDX T,
       TBF01_SPEC_SLAB A,
       TBF01_SPEC_CHARGE B,
       (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1
 WHERE T.CHARGE_EDT_SEQ = A.CHARGE_EDT_SEQ
   AND T.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
   AND B.STATUS_CD = 'B'
   AND B.PROG_CD >= 'JBB'
   AND B.PROG_CD                   =         T1.SM_CD(+)
GROUP BY T.CHARGE_EDT_SEQ ,T.CHARGE_MANA_NO,B.PRE_CCM_END_DTIME,B.MILL_FL,B.HCR_CLF, T1.SM_CFNM
ORDER BY B.PRE_CCM_END_DTIME
					
        ]]>
    </query>
	
	<query id="UIF023100.findCoilWth" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[
			
/*********************求宽度结果集 按升序排列  动态生成宽度的刻度*********************************/
			
       SELECT DISTINCT T.ORD_WTH 
       FROM TBF01_SPEC_SLAB T 
       ORDER BY T.ORD_WTH ASC
			
/************************************************************************************************/
			
        ]]>
	</query> 
		
	 <query id="UIF023100.findChargeInfoOnClick" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[
			
/*******************************通过点击获取该炉次的板坯信息********************************/
			
SELECT A.CHARGE_SLAB_SEQ, /*炉次内顺序*/
	   A.SLAB_EDT_SEQ, /*板坯编制号*/
	   A.SLAB_MANA_NO, /*板坯管理号*/
	   A.SLAB_THK, --板坯厚度
	   A.SLAB_WTH, --板坯宽度
	   A.SLAB_LEN, --板坯长度
	   A.SLAB_WGT, --板坯重量  
	   /*              ORD_THK  ,\*订单厚度*\
                     ORD_WTH  ,\*订单宽度*\*/
	   B.WTH_AIM, --目标宽度
	   B.HOT_THK_AIM, --目标厚度
	   A.ORD_WGT, /*订单重量*/
	   A.STL_GRD, /*钢码*/
	   T1.SM_CFNM HCR_CLF, /*热送代号*/
	   A.ORD_NO, /*合同号*/
	   A.ORD_SEQ, /*订单号*/
	   A.SPEC_ABBSYM, /*标准号*/
	   T2.SM_CFNM ORD_FL,
	   T3.SM_CFNM SLAB_RT /*去向 */,
	   T4.SM_CFNM DLIV_TP /*热送代号*/,
	   DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN
	   ,DECODE(QL.DSN_KIND, '1', 'Y', 'N') AS QLTY_YN  --材质特殊要求
       ,DECODE(DE.DSN_KIND, '1', 'Y', 'N') AS DEL_YN  --交付条件特殊要求
  FROM TBF01_SPEC_SLAB A,
	   TBB01_ORD_PROD B,
	   (SELECT T.SM_CD, T.SM_CFNM
		  FROM TBZ00_COMMCD T
		 WHERE T.LG_CD = 'E01012') T1,
	   (SELECT T.SM_CD, T.SM_CFNM
		  FROM TBZ00_COMMCD T
		 WHERE T.LG_CD = 'E01007') T2,
	   (SELECT T.SM_CD, T.SM_CFNM
		  FROM TBZ00_COMMCD T
		 WHERE T.LG_CD = 'B01004') T3,
	   (SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'A01012') T4,
	   TBA01_ORD_LINE A01,
	   (SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
		  FROM TBB01_ORD_INGR
		 WHERE DSN_KIND = '1') K
	   ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
	      FROM TBB01_ORD_QLTY
	     WHERE DSN_KIND = '1') QL   --材质特殊要求
       ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
	      FROM TBB01_ORD_DEL
	     WHERE DSN_KIND = '1') DE    --交付条件特殊要求
 WHERE A.ORD_NO = A01.ORD_NO(+)
   AND A.ORD_SEQ = A01.ORD_SEQ(+)
   AND A.ORD_NO = K.ORD_NO(+)
   AND A.ORD_SEQ = K.ORD_SEQ(+)
   AND A.ORD_NO  = QL.ORD_NO(+)
   AND A.ORD_SEQ = QL.ORD_SEQ(+)
   AND A.ORD_NO  = DE.ORD_NO(+)
   AND A.ORD_SEQ = DE.ORD_SEQ(+)
   AND A01.DLIV_TP = T4.SM_CD(+)
   AND A.STATUS_CD IN ('A', 'B')
   AND A.HCR_CLF = T1.SM_CD
   AND A.ORD_FL = T2.SM_CD
   AND A.SLAB_RT = T3.SM_CD
   AND A.ORD_NO = B.ORD_NO(+)
   AND A.ORD_SEQ = B.ORD_SEQ(+)
   AND A.CHARGE_EDT_SEQ = ?
 ORDER BY A.CHARGE_SLAB_SEQ ASC
			
/*******************************通过点击获取该炉次的板坯信息********************************/



			
        ]]>
    </query> 
	
	<query id="UIF023100.findCoilThk" desc="求轧制单元轧制厚度结果集 按升序排列 动态生成轧制厚度的刻度" fetchSize="10">
        <![CDATA[			
/********************************************厚度结果集 按升序排列************************/
      
	   SELECT DISTINCT T.ORD_THK
       FROM TBF01_SPEC_SLAB T 
       ORDER BY T.ORD_THK ASC
			
/*************************************************************************************/
			
        ]]>
    </query>
	
	<query id="UIF023100.findRollSpec" desc="求轧制单元轧制厚度结果集 按升序排列 动态生成轧制厚度的刻度" fetchSize="10">
        <![CDATA[
/*******************************查询HCR轧辊编制信息********************************/
						
SELECT  DISTINCT    B.ROLL_MANA_NO  ,/*轧辊管理号*/
            B.ROLL_SLAB_CNT  ,/*编制轧辊内板坯数*/
            B.ROLL_SLAB_WGT  ,/*编制轧辊内板坯重量*/
            B.MILL_LEN  /*轧制长度*/
FROM        TBF02_MILL_IDX A, TBF02_SPEC_ROLL  B
WHERE       A.STATUS_CD   IN ('A', 'B')
     AND    A.ROLL_MANA_NO     =     B. ROLL_MANA_NO
ORDER   BY  B.ROLL_MANA_NO ASC
			
/*******************************查询HCR轧辊编制信息********************************/
			
        ]]>
    </query>
	
	<query id="UIF023100.findMillSpec" desc="求轧制单元轧制厚度结果集 按升序排列 动态生成轧制厚度的刻度" fetchSize="10">
        <![CDATA[
/*******************************查询轧辊单元的HCR轧制信息********************************/	

SELECT A.ROLL_SLAB_SEQ, -- 轧辊内顺序
	   A.SLAB_NO, -- 板坯号
	   A.SLAB_THK, --板坯厚度
	   A.SLAB_WTH, --板坯宽度
	   A.SLAB_LEN, --板坯长度
	   A.SLAB_WGT, --板坯重量  
	   A.ORD_THK, -- 订单厚度
	   A.ORD_WTH, -- 订单宽度
	   A.ORD_WGT, --  订单重量
	   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.STL_GRD, -- 钢码
	   T1.SM_CFNM STATUS_CD, -- 状态区分
	   B.CUR_LOAD_LOC, -- 堆置位置
	   T2.SM_CFNM HCR_CLF, --  热送代号
	   A.ORD_NO, -- 合同号
	   A.ORD_SEQ, -- 订单号
	   A.SPEC_ABBSYM, -- 标准号
	   T3.SM_CFNM ORD_USEAGE_CD, -- 订单用途代码
	   A.DELV_REQ_DATE, -- 交货期
	   T4.SM_CFNM ROUTE, -- 去向
	   NVL(C.EMGMTR_NMG_CLF, 'N') EMGMTR_NMG_CLF, --紧急材代码
	   A.FUR_IN_PRE_DTIME -- 计划加热炉装炉日期
	  ,
	   T5.SM_CFNM DLIV_TP /*热送代号*/,
	   DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN
	   ,DECODE(QL.DSN_KIND, '1', 'Y', 'N') AS QLTY_YN  --材质特殊要求
       ,DECODE(DE.DSN_KIND, '1', 'Y', 'N') AS DEL_YN  --交付条件特殊要求
  FROM TBF02_SPEC_MILL A,
	   TBG02_SLAB_COMM B,
	   TBE02_ORD_PRC C,
	   (SELECT T.SM_CD, T.SM_CFNM
		  FROM TBZ00_COMMCD T
		 WHERE T.LG_CD = 'Z01001') 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 = 'A01007') T3,
	   (SELECT T.SM_CD, T.SM_CFNM
		  FROM TBZ00_COMMCD T
		 WHERE T.LG_CD = 'B01004') T4,
	   (SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'A01012') T5,
	   TBA01_ORD_LINE A01,
	   (SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
		  FROM TBB01_ORD_INGR
		 WHERE DSN_KIND = '1') K
	   ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
	      FROM TBB01_ORD_QLTY
	     WHERE DSN_KIND = '1') QL   --材质特殊要求
       ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
	      FROM TBB01_ORD_DEL
	     WHERE DSN_KIND = '1') DE    --交付条件特殊要求
 WHERE A.ORD_NO = A01.ORD_NO(+)
   AND A.ORD_SEQ = A01.ORD_SEQ(+)
   AND A01.DLIV_TP = T5.SM_CD(+)
   AND A.ORD_NO = C.ORD_NO
   AND A.ORD_SEQ = C.ORD_SEQ
   AND A.ORD_NO = K.ORD_NO(+)
   AND A.ORD_SEQ = K.ORD_SEQ(+)
   AND A.ORD_NO  = QL.ORD_NO(+)
   AND A.ORD_SEQ = QL.ORD_SEQ(+)
   AND A.ORD_NO  = DE.ORD_NO(+)
   AND A.ORD_SEQ = DE.ORD_SEQ(+)
   AND A.STATUS_CD = T1.SM_CD
   AND A.HCR_CLF = T2.SM_CD
   AND A.ORD_USEAGE_CD = T3.SM_CD
   AND A.ROUTE = T4.SM_CD
   AND A.STATUS_CD IN ('A', 'B') --处于指示和作业
   AND A.ROLL_MANA_NO = ? --选择的轧辊编制号
   AND A.SLAB_NO = B.SLAB_NO(+)
 ORDER BY A.ROLL_SLAB_SEQ ASC

/*******************************查询轧辊单元的HCR轧制信息********************************/			
        ]]>
    </query>
	
	<query id="callHCREdit" desc="사원추가" fetchSize="1">
        <![CDATA[

						
            {call UIF023100_TEST.HCR_EDIT(?,?,?,?,?,?,?,?)}
			

        ]]>
    </query>
</queryMap>