XinYu_LZMES/.svn/pristine/6f/6fdb0c144003241cec7804f8f1b9370a32b79d01.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="操作历史纪录">

<query id="UIB030194_01.SELECT"  desc="查询">
<![CDATA[
SELECT         T1.PROD_LINE
              ,T1.MATERIAL_NO        
              ,T1.HIS_FLAG          
              ,(SELECT T2.SM_CFNM FROM  TBZ00_COMMCD  T2 WHERE  T2.LG_CD = 'E01002'  AND T1.CUR_PROG_CD =T2.SM_CD )       CUR_PROG_CD        
              ,T1.COIL_LEN           
              ,T1.COIL_INDIA         
              ,T1.COIL_OUTDIA        
              ,T1.CAL_WGT           
              ,T1.COIL_THK           
              ,T1.COIL_WTH          
              ,T1.ACT_WGT                 
              ,T1.ORD_NO            
              ,T1.ORD_SEQ            
              ,T1.MILL_DTIME
              ,T1.UPDATE_FLAG         
              ,T1.EXTSHAPE_QUALITY   
              ,CASE WHEN T1.CAL_TYPE = '1'  THEN '正常退火'  WHEN T1.CAL_TYPE = '2'  THEN '返修'  WHEN T1.CAL_TYPE = '3'  THEN  '过渡' END  CAL_TYPE         
              ,T1.REG_PGM_ID         
              ,T1.REG_ID    
              ,T1.REG_DTIME         
FROM           C_TBC02_COIL_COMM_HIS      T1
              
WHERE          T1.REG_DTIME               BETWEEN     ?   AND  ?
AND            T1.MATERIAL_NO             LIKE        ?||'%'
AND            NVL(T1.PROD_LINE,'NULL')   LIKE DECODE(?,'0','S','1','L','2','C','%%')
AND            T1.UPDATE_FLAG!='打印后'
 ]]>  
</query>


<query id="UIB030194_02.SELECT" desc="酸轧删除记录">
SELECT     '酸轧'  PROD_LINE
          ,T.COIL_NO
          ,T.C_COIL_NO
          ,T.ROLL_MANA_NO 
          ,T.ORD_NO
          ,T.ORD_SEQ
          ,T.MOD_DTIME
          ,T.MOD_ID
FROM       C_TBF03_SPEC_MILL_DEL     T   
WHERE      T.MOD_DTIME BETWEEN  ?    AND   ?
AND        T.ROLL_MANA_NO       LIKE       ?||'%'
</query>

<query id="UIB030194_03.SELECT" desc="连退删除记录">
SELECT     '连退'       PROD_LINE
          ,T.COIL_NO
          ,T.C_COIL_NO
          ,T.CAL_NO     ROLL_MANA_NO 
          ,T.EXIT_COIL_NO     L_COIL_NO          --连退出口卷号
          ,T.ORD_NO
          ,T.ORD_SEQ
          ,T.MOD_DTIME
          ,T.MOD_ID
FROM       L_TBF03_SPEC_MILL_DEL     T   
WHERE      T.MOD_DTIME BETWEEN  ?    AND   ?
AND        T.CAL_NO       LIKE       ?||'%'
</query>

<query id="UIB030194_04.SELECT"  desc="查询">
<![CDATA[
SELECT         T1.PROD_LINE
              ,T1.MATERIAL_NO        
              ,T1.HIS_FLAG          
              ,(SELECT T2.SM_CFNM FROM  TBZ00_COMMCD  T2 WHERE  T2.LG_CD = 'E01002'  AND T1.CUR_PROG_CD =T2.SM_CD )  CUR_PROG_CD        
              ,T1.COIL_LEN           
              ,T1.COIL_INDIA         
              ,T1.COIL_OUTDIA        
              ,T1.CAL_WGT           
              ,T1.COIL_THK           
              ,T1.COIL_WTH          
              ,T1.ACT_WGT                 
              ,T1.ORD_NO            
              ,T1.ORD_SEQ            
              ,T1.MILL_DTIME
              ,T1.UPDATE_FLAG         
              ,T1.EXTSHAPE_QUALITY   
              ,CASE WHEN T1.CAL_TYPE = '1'  THEN '正常退火'  WHEN T1.CAL_TYPE = '2'  THEN '返修'  WHEN T1.CAL_TYPE = '3'  THEN  '过渡' END  CAL_TYPE         
              ,T1.REG_PGM_ID         
              ,T1.REG_ID    
              ,T1.REG_DTIME         
FROM           C_TBC02_COIL_COMM_HIS      T1
WHERE         T1.REG_DTIME  BETWEEN       ?   AND     ?
AND            T1.MATERIAL_NO             LIKE        ?||'%'
AND            T1.PROD_LINE               =           DECODE(?,'0','S','1','L','2','C','%%')
AND            T1.HIS_FLAG                =           ?||'实绩修改'
AND            (T1.UPDATE_FLAG<>'打印后' OR T1.UPDATE_FLAG IS NULL)
 ]]>  
</query>

<query id="UIB030194_05.SELECT"  desc="查询">
<![CDATA[
SELECT DECODE(T1.PROD_LINE,'S','酸轧','L','连退','C','重卷') PROD_LINE,
       T1.MATERIAL_NO,
       T1.HIS_FLAG,
       T1.COIL_LEN,
       T1.COIL_INDIA,
       T1.COIL_OUTDIA,
       T1.CAL_WGT,
       T1.COIL_THK,
       T1.COIL_WTH,
       T1.ACT_WGT,
       T1.ORD_NO,
       T1.ORD_SEQ,
       T1.MILL_DTIME,
       T1.REG_PGM_ID,
       T1.REG_ID,
       T1.REG_DTIME
  FROM C_TBC02_COIL_COMM_HIS T1
  WHERE T1.REG_DTIME BETWEEN ? AND ?
   AND T1.MATERIAL_NO LIKE ? || '%'
   AND NVL(T1.PROD_LINE, 'NULL') LIKE
       DECODE(?, '0', 'S', '1', 'L', '2', 'C', '%%')
   AND T1.HIS_FLAG='标签打印'
 ]]>  
</query>

<query id="UIB030194_06.SELECT"  desc="包装">
<![CDATA[
 SELECT DECODE(T1.LINE_TP, 'L', '连退', 'C', '重卷') PROD_LINE,
       T1.OLD_SAMPL_NO,
       '包装' HIS_FLAG,
       T1.COIL_LEN,
       T1.COIL_INDIA,
       T1.COIL_OUTDIA,
       T1.CAL_WGT,
       T1.COIL_THK,
       T1.COIL_WTH,
       T1.ACT_WGT,
       T1.ORD_NO,
       T1.ORD_SEQ,
       T1.MILL_DTIME,
       DECODE(T1.PACKAGE_LEVEL,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装') PACKAGE_LEVEL,
       DECODE(T1.PACKAGE_SHIFT,
              '0',
              '常白班',
              '1',
              '早班',
              '2',
              '中班',
              '3',
              '晚班') PACKAGE_SHIFT,
       DECODE(T1.PACKAGE_GROUP,
              '0',
              '常白班',
              '1',
              '甲班',
              '2',
              '乙班',
              '3',
              '丙班',
              '4',
              '丁班') PACKAGE_GROUP,
       (SELECT USERNAME FROM CORE_APP_USER WHERE USERID = T1.PACKAGE_REG) PACKAGE_REG,
       T1.PACKAGE_DTIME
  FROM C_TBC02_COIL_COMM T1
 WHERE SUBSTR(T1.PACKAGE_DTIME, 1, 8) BETWEEN ?  AND ?
 	AND T1.OLD_SAMPL_NO LIKE ?||'%'
      AND LINE_TP='L'
 ]]>  
</query>

<query id="UIB030194_07.SELECT"  desc="包装">
<![CDATA[
 SELECT DECODE(T1.LINE_TP, 'L', '连退', 'C', '重卷') PROD_LINE,
       T1.OLD_SAMPL_NO,
       '包装' HIS_FLAG,
       T1.COIL_LEN,
       T1.COIL_INDIA,
       T1.COIL_OUTDIA,
       T1.CAL_WGT,
       T1.COIL_THK,
       T1.COIL_WTH,
       T1.ACT_WGT,
       T1.ORD_NO,
       T1.ORD_SEQ,
       T1.MILL_DTIME,
       DECODE(T1.PACKAGE_LEVEL,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装') PACKAGE_LEVEL,
       DECODE(T1.PACKAGE_SHIFT,
              '0',
              '常白班',
              '1',
              '早班',
              '2',
              '中班',
              '3',
              '晚班') PACKAGE_SHIFT,
       DECODE(T1.PACKAGE_GROUP,
              '0',
              '常白班',
              '1',
              '甲班',
              '2',
              '乙班',
              '3',
              '丙班',
              '4',
              '丁班') PACKAGE_GROUP,
       (SELECT USERNAME FROM CORE_APP_USER WHERE USERID = T1.PACKAGE_REG) PACKAGE_REG,
       T1.PACKAGE_DTIME
  FROM C_TBC02_COIL_COMM T1
 WHERE SUBSTR(T1.PACKAGE_DTIME, 1, 8) BETWEEN ?  AND ?
 AND T1.OLD_SAMPL_NO LIKE ?||'%'
      AND LINE_TP='C'
 ]]>  
</query>

<query id="UIB030194_08.SELECT"  desc="包装">
<![CDATA[
 SELECT '酸轧' PROD_LINE,
       T1.OLD_SAMPL_NO,
       '包装' HIS_FLAG,
       T1.COIL_LEN,
       T1.COIL_INDIA,
       T1.COIL_OUTDIA,
       T1.CAL_WGT,
       T1.COIL_THK,
       T1.COIL_WTH,
       T1.ACT_WGT,
       T1.ORD_NO,
       T1.ORD_SEQ,
       T1.MILL_DTIME,
       DECODE(T1.PACKAGE_LEVEL,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装') PACKAGE_LEVEL,
       DECODE(T1.PACKAGE_SHIFT,
              '0',
              '常白班',
              '1',
              '早班',
              '2',
              '中班',
              '3',
              '晚班') PACKAGE_SHIFT,
       DECODE(T1.PACKAGE_GROUP,
              '0',
              '常白班',
              '1',
              '甲班',
              '2',
              '乙班',
              '3',
              '丙班',
              '4',
              '丁班') PACKAGE_GROUP,
       (SELECT USERNAME FROM CORE_APP_USER WHERE USERID = T1.PACKAGE_REG) PACKAGE_REG,
       T1.PACKAGE_DTIME
  FROM C_TBl02_COIL_COMM T1
 WHERE SUBSTR(T1.PACKAGE_DTIME, 1, 8) BETWEEN ?  AND ?
 AND T1.OLD_SAMPL_NO LIKE ?||'%'
 ]]>  
</query>

<query id= "UIB030194_09.SELECT"  desc="磅房重量发送记录">
<![CDATA[
 SELECT T.COILNO OLD_SAMPL_NO,
       TO_CHAR(T.ZL) ACT_WGT,
       TO_CHAR(T.CZDATE, 'YYYYMMDDHH24MISS') CZRQ,
       t.TRAN_TIME DEAL_TIME,
       DECODE(T.FLAG,1,'Y','N') FLAG
  FROM tbh05_l2_weight T
 WHERE TO_CHAR(T.CZDATE, 'YYYYMMDD') BETWEEN ? AND ?
   AND T.COILNO LIKE ? || '%'
 
 ]]>  
</query>

<query id= "UIB030194_10.SELECT"  desc="待处理钢卷管理">
<![CDATA[
    SELECT T.REG_ID,
       T.REG_PGM_ID,
       T.RESERVE_FIELD1,
       T.RESERVE_FIELD11,
       T.REG_SHIFT,
       T.REG_GROUP,
       DECODE(REG_PGM_ID,
              'DEFECTIVE_COIL',
              DECODE(T.RESERVE_FIELD15,
                     '01',
                     '取消二级库存',
                     '02',
                     '二级库存'),
              DECODE(T.RESERVE_FIELD15, '01', '取消封闭', '02', '封闭')) RESERVE_FIELD15
	FROM        TBE04_OPT_HIS T  WHERE  T.RESERVE_FIELD15 IS NOT NULL
	AND         T.RESERVE_FIELD11       BETWEEN         ?         AND      ?
	AND         T.RESERVE_FIELD1        LIKE            ?||'%'
 ]]>  
</query>
<query id= "UIB030194_11.SELECT"  desc="进程修改">
<![CDATA[
    SELECT DECODE(T1.PROD_LINE, 'S', '酸轧', 'L', '连退', 'C', '重卷') PROD_LINE,
       		T1.MATERIAL_NO,
       		T1.HIS_FLAG,
       		t1.UPDATE_FLAG,
       		(SELECT T2.SM_CFNM FROM  TBZ00_COMMCD  T2 WHERE  T2.LG_CD = 'E01002'  AND T1.CUR_PROG_CD =T2.SM_CD )  CUR_PROG_CD,
       		T1.ORD_NO,
       		T1.ORD_SEQ,
      		T1.MILL_DTIME,
       		T1.REG_ID,
       		T1.REG_DTIME
  	FROM C_TBC02_COIL_COMM_HIS T1
 	WHERE substr(T1.REG_DTIME,1,8) BETWEEN ? AND ?
   			AND T1.MATERIAL_NO LIKE ? || '%'
   			AND NVL(T1.PROD_LINE, 'NULL') LIKE
       		DECODE(?, '0', 'S', '1', 'L', '2', 'C', '%%')
   			AND (T1.HIS_FLAG = '进程状态修改' or T1.HIS_FLAG = '取样界面改进程') 
   	order by t1.reg_dtime desc
 ]]>  
</query>
<query id= "UIB030194_12.SELECT"  desc="热轧计划">
<![CDATA[
    select t.SLAB_NO,
       t.COIL_NO,
       t.TRANS_DTIME,
       t.RESERVE_FIELD3 OLD_SAMPL_NO,
       DECODE(T.MSG_FLAG, 'C', 'Y', 'N') FLAG
  from TBH06_L2_MILL_INS t
 where t.SLAB_NO = ? 
 order BY t.TRANS_DTIME DESC
 ]]>  
</query>

<query id= "UIB030194_13.SELECT"  desc="充当改判">
<![CDATA[
				    SELECT DECODE(T1.PROD_LINE, 'S', '酸轧', 'L', '连退', 'C', '重卷') PROD_LINE,
				       T1.MATERIAL_NO,
				       --  T1.HIS_FLAG,
				       t1.UPDATE_FLAG,
				       T1.SPEC_ABBSYM,
				       T1.SPEC_STL_GRD,
				       T1.REG_ID,
				       T1.REG_DTIME
				
				  FROM C_TBC02_COIL_COMM_HIS T1
				 WHERE substr(T1.REG_DTIME, 1, 8) BETWEEN ? AND ?
				   AND T1.MATERIAL_NO LIKE ? || '%'
				   AND NVL(T1.PROD_LINE, 'NULL') LIKE
				       DECODE(?, '0', 'S', '1', 'L', '2', 'C', '%%')
				   AND (T1.HIS_FLAG = '充当改判')
				 order by t1.reg_dtime desc
 ]]>  
</query>

<query id= "UIB030194_14.SELECT"  desc="明细退回">
<![CDATA[
				select t.dliv_no,
       to_char(t.return_dtime,'yyyy-mm-dd hh24:mi:ss') return_dtime,
       t.oriwgt,
       t.oricar,
       t.returnname,
       t.prodline,
       t.return_rson,
       t.oritrnftime,
       t.coil_no
  from return_dliv_his t
 where to_char(t.return_dtime, 'yyyymmdd') between ? and ?
   and DLIV_NO like ? || '%'
 ]]>  
</query>

</queryMap>