XinYu_RZMES/.svn/pristine/8e/8ea69cb491b3c40a013785cea87d9aff613de2d3.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">
<query id="UIF024030.findRollMana" desc="求各炉次所接受的热轧板坯参数" fetchSize="10">
        <![CDATA[
     SELECT A.SPM_MANA_NO ROLL_EDT_SEQ,
       A.SPM_NO ROLL_MANA_NO,
       COUNT(A.SPM_MANA_NO) coilCnt
  FROM TBF05_SPEC_MILL A
 WHERE A.STATUS_CD IN ('A', 'B', 'D')
 AND substr(A.REG_DTIME,0,8) BETWEEN ? AND ?
 GROUP BY A.SPM_MANA_NO, A.SPM_NO
 ORDER BY A.SPM_NO ASC


        ]]>
</query> 
	<query id="UIF024010.findCoilWth" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[
			
			/*求轧制单元板坯宽度结果集 按升序排列  动态生成宽度的刻度*/
       SELECT DISTINCT T.ORD_WTH 
       FROM TBF02_SPEC_MILL T 
       ORDER BY T.ORD_WTH ASC
			
        ]]>
	</query> 
   <query id="UIF024030.findChart" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[
			
/******************************************************************************/
								
					SELECT A.SPM_NO ROLL_MANA_NO, --轧辊号
					       A.SPM_EDT_SEQ ROLL_SLAB_SEQ, --轧辊内顺序
					       B.SLAB_NO, --板坯号
					       B.INSTR_COIL_THK HOT_THK_AIM, --轧制厚度目标
					       B.INSTR_COIL_WTH WTH_AIM, --轧制宽度目标
					       '' HCR_CLF, --热送状态
					       A.STATUS_CD, --进行状态
					       B.COIL_STAT --钢卷状态
					  FROM tbf05_spec_mill A, TBH02_COIL_COMM B
					 WHERE A.STATUS_CD IN ('A', 'B', 'D')
					   AND A.COIL_NO = B.OLD_SAMPL_NO(+)
					   AND substr(A.REG_DTIME,0,8) BETWEEN ? AND ?
					 ORDER BY A.SPM_NO ASC, A.SPM_EDT_SEQ ASC
			
/******************************************************************************/
			
        ]]>
	</query> 
		
	 <query id="UIF024030.findBehindCoilInfos" desc="求轧制单元板坯宽度结果集 按升序排列" fetchSize="10">
        <![CDATA[			
/***************************************************************************************/

SELECT C.SPM_MANA_NO ROLL_MANA_NO, -- 轧辊号
       C.SPM_EDT_SEQ ROLL_SLAB_SEQ, -- 轧辊内顺序
       A.SLAB_NO, -- 板坯号
       C.COIL_NO COIL_NO, --钢卷号    
       B.SLAB_THK, --板坯厚度
       B.SLAB_WTH, --板坯宽度
       B.SLAB_LEN, --板坯长度
       B.SLAB_WGT, --板坯重量  
       E.ORD_THK, --订单厚度
       E.ORD_WTH, --订单宽度
       E.ORD_WGT, --订单重量
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'H02001'
           AND T.SM_CD = D.SPM_CRK_CD1) SPM_CRK_CD1, --钢卷外观缺陷
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'H02001'
           AND T.SM_CD = D.SPM_CRK_CD2) SPM_CRK_CD2, --钢卷外观缺陷
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'H02001'
           AND T.SM_CD = D.SPM_CRK_CD3) SPM_CRK_CD3, --钢卷外观缺陷
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'H02001'
           AND T.SM_CD = D.SPM_CRK_CD4) SPM_CRK_CD4, --钢卷外观缺陷
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'H02001'
           AND T.SM_CD = D.SPM_CRK_CD5) SPM_CRK_CD5, --钢卷外观缺陷 
       D.SPM_REMARK, --缺陷备注   
       '' HOT_THK_AIM, --热厚度AIM
       '' HOT_THK_MIN, --热厚度MIN
       '' HOT_THK_MAX, --热厚度MAX
       '' WTH_AIM, --宽度AlM
       '' WTH_MIN, --宽度MIN
       '' WTH_MAX, --宽度MAX  
       '' MILL_LEN, --轧制长度
       '' MILL_WGT, --轧制重量
       A.SPEC_STL_GRD STL_GRD, --钢码
       DECODE(GF_NIB028720(A.SLAB_NO, A.ORD_NO, A.ORD_SEQ),
              'YY',
              '合格',
              '不合格') QLFD_YN,
       DECODE(DECODE(C.STATUS_CD,
                     'B',
                     DECODE(B.CUR_PROG_CD,
                            'RBB',
                            '加热炉出炉待机',
                            T1.SM_CFNM),
                     T1.SM_CFNM),
              '',
              '板坯切割待机',
              DECODE(C.STATUS_CD,
                     'B',
                     DECODE(B.CUR_PROG_CD,
                            'RBB',
                            '加热炉出炉待机',
                            T1.SM_CFNM),
                     T1.SM_CFNM)) CUR_PROG_CD, -- 当前进程   
       T2.SM_CFNM STATUS_CD, --   状态区分
       B.CUR_LOAD_LOC, -- 堆置位置
       --T3.SM_CFNM HCR_CLF, -- 热送状态
       A.ORD_NO, --   合同号
       A.ORD_SEQ, --   订单号
       A.SPEC_ABBSYM, --  标准号
       --T4.SM_CFNM ORD_USEAGE_CD, --   订单用途代码
       E.DEL_TO_DATE DELV_REQ_DATE, --   交货期
       -- T5.SM_CFNM ROUTE, --    去向
       E.EMGMTR_NMG_CLF, --  紧急材
       
       T6.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 TBH02_COIL_COMM A,
       TBG02_SLAB_COMM B,
       TBF05_SPEC_MILL C,
       TBB02_SPM_PLAN D,
       (SELECT T.SM_CD, T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'E01002') T1,
       (SELECT T.SM_CD, T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'Z01001') T2,
       
       (SELECT T.SM_CD, T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'B01004') T5,
       TBE02_ORD_PRC E,
       (SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'A01012') T6,
       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 C.COIL_NO = A.OLD_SAMPL_NO(+)
   AND A01.DLIV_TP = T6.SM_CD(+)
   AND A.ORD_NO = E.ORD_NO
   AND A.ORD_SEQ = E.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 C.STATUS_CD IN ('A', 'B', 'D') --处于指示和作业
   AND C.SPM_PLAN_SEQ = D.SPM_PLAN_SEQ
   AND A.SLAB_NO = B.SLAB_NO(+)
   AND B.CUR_PROG_CD = T1.SM_CD(+)
   AND C.STATUS_CD = T2.SM_CD
      -- AND A.HCR_CLF = T3.SM_CD
      -- AND A.ORD_USEAGE_CD = T4.SM_CD(+)
   AND A.ROUTE = T5.SM_CD
   AND C.SPM_MANA_NO || LPAD(TO_CHAR(C.SPM_EDT_SEQ), 4, 0) >=
       ? || LPAD(TO_CHAR(?), 4, 0)
 ORDER BY C.SPM_MANA_NO ASC, C.SPM_EDT_SEQ ASC

/***************************************************************************************/			
        ]]>
    </query> 
	
</queryMap>