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

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
	<query id="UIG020900_01.select" desc=" 取板坯运送前的信息，此时板坯在我方数据库。 ">
	   <![CDATA[
			/*select a.SLAB_CUT_DTIME,
			       C.REG_DTIME,
			       A.SLAB_CUT_DTIME - c.REG_DTIME,
			       a.SLAB_TOT_DEC_GRD,
			       a.CAST_NO,
			       a.ORD_NO || '-' || a.ORD_SEQ ord_no,
			       a.CHARGE_NO,
			       a.SLAB_NO,
			       c.STL_GRD BEF_STL_GRD,
			       a.STL_GRD,
			       a.SLAB_THK,
			       a.SLAB_WTH,
			       a.SLAB_LEN,
			       a.SLAB_WGT,
			       C.LINE_PROC_CD,
			       instr(c.LINE_PROC_CD,'L') LF,
			       INSTR(C.LINE_PROC_CD,'R') RH,
			       A.SLAB_INGR_DEC_DTIME,
			       A.SLAB_INGR_DEC_GRD,
			       A.SMS_YARD_EXT_DTIME,
			       C.REG_DTIME MOD_DTIME,
			       d.DEL_TO_DATE,
			       a.SLAB_RT,
			       b.CC_DEVNO,
			       a.CUT_WKGROUP,
			       a.NONORD_CAUSE_CD,
			       a.EXTSHAPE_GRD,
			       a.SLAB_INGR_DEC_KIND,
			       a.SLAB_INGR_DEC_GRD,
			       a.HCR_CLF,
			       e.INGR_DEC_GRD,
			       a.NONORD_CAUSE_CD
			       
			  from tbg02_slab_comm a,
			       tbg02_charge_comm b,
			       tbf01_spec_charge c,
			       tbe02_ord_prc d,
			       tbg02_charge_comm_d e,
			       (select slabcmm.ORD_NO || slabcmm.ORD_SEQ,
			               slabspec.ORD_NO || slabspec.ORD_SEQ,
			               slabspec.STL_GRD,
			               slabcmm.STL_GRD,
			               slabcmm.SLAB_NO,
			               'Y' noord_yn
			          from tbg02_slab_comm     slabcmm,
			               tbf01_spec_slab     slabspec
			         where slabcmm.PLAN_SLAB_NO = slabspec.SLAB_MANA_NO
			           and slabcmm.ORD_NO || slabcmm.ORD_SEQ <> slabspec.ORD_NO||slabspec.ORD_SEQ )g
			where  a.SLAB_NO = g.slab_no(+)
			and    a.ORD_NO = d.ORD_NO(+)
			and    a.ORD_SEQ = d.ORD_SEQ(+)   
			and    substr(a.SLAB_NO,1,10) = b.CHARGE_NO 
			and    b.PLAN_CHARGE_NO = c.CHARGE_MANA_NO     
			and    b.CHARGE_NO = e.SUB_CHARGE_NO  
			
			AND     substr(A.SLAB_CUT_DTIME,1,8) >= :1
			AND     substr(A.SLAB_CUT_DTIME,1,8) <= :2
			and     A.SLAB_CUT_DTIME - c.REG_DTIME > :3*1000000
			and     b.CC_DEVNO like :4||'%'
			and     a.CAST_NO like :5||'%'
			and     a.ORD_NO like :6||'%'
			and     b.CHARGE_NO like :7||'%'
			and     a.SLAB_NO like :8||'%'
			and     a.SLAB_TOT_DEC_GRD like :9||'%'
			and     a.SLAB_RT like :10||'%'
			and     a.NONORD_CAUSE_CD like :11||'%'
			AND     instr(c.LINE_PROC_CD,:12)>'0'
			AND     A.SLAB_WTH >= :13 AND A.SLAB_WTH <= :14  
			AND     c.STL_GRD LIKE :15||'%'
			AND     B.INGR_DEC_GRD LIKE :16||'%'*/
			
			SELECT A.SLAB_CUT_DTIME
		             ,A.CAST_NO
		             ,A.ORD_NO
		             ,SUBSTR(A.SUB_SLAB_NO,1,10) CHARGE_NO
		             ,A.SLAB_NO
		             ,f.STL_GRD BEF_STL_GRD
		             ,A.STL_GRD
		             ,NVL(B.L2_STEELCODE,G.H_SPEC_STL_GRD) SPEC_STL_GRD
		             ,A.SLAB_THK
		             ,A.SLAB_WTH
		             ,A.SLAB_LEN
		             ,A.SLAB_WGT
		             ,A.WEIGHT_WGT
		             ,A.SLAB_INGR_DEC_DTIME
		             ,A.SLAB_TOT_DEC_GRD
		             ,NVL(A.SMS_YARD_EXT_DTIME,A.SLAB_STOCK_ENT_DTIME) SMS_YARD_EXT_DTIME
		             ,f.REG_DTIME
		             ,A.SLAB_RT
		             ,decode(A.CUT_WKGROUP,'A','甲班','B','乙班','C','丙班','D','丁班') CUT_WKGROUP
		             ,decode(A.EXTSHAPE_GRD,'1','合格','2','不合格') EXTSHAPE_GRD
		             ,(SELECT SM_CFNM FROM TBZ00_COMMCD WHERE SM_CD = A.SLAB_INGR_DEC_KIND AND LG_CD = 'B01133') SLAB_INGR_DEC_KIND
		             ,A.SLAB_INGR_DEC_GRD INGR_DEC_GRD
		             ,decode(A.HCR_CLF,'H','热送','C','冷送')HCR_CLF
		             ,decode(PKG_G_QUERY.FIG010_NOORDER(A.SLAB_NO),'N','否','Y','是') NOORDER
		             ,(select sm_cfnm from tbz00_commcd  where lg_cd like 'E01010%' and sm_cd = A.NONORD_CAUSE_CD)NONORD_CAUSE_CD
		             ,G.DEL_TO_DATE
		                ,E.CC_DEVNO
		              --  ,(select TO_DATE( A.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS') - TO_DATE( f.REG_DTIME,'YYYY-MM-DD HH24:MI:SS') from dual) CJHQ
		             ,round((select  sysdate - TO_DATE( f.REG_DTIME,'YYYY-MM-DD HH24:MI:SS') from dual)) CJHQ
		             ,A.CUR_LOAD_LOC
		             ,B.L2_SCH_NO,
		             decode(f.STL_GRD, A.STL_GRD, '是', '') SFMZ,
       				 B.L2_SENDBEGINDATE,
       				 case
        			 (SELECT COUNT(*) FROM J#STL_LFS_OPTINFO where heatno = e.CHARGE_NO)
         			 when 0 then
          			''
         			else
          			'是'
       				end LF,
       				case
        			(SELECT COUNT(*) FROM J#STL_RHS_OPTINFO where heatno = e.CHARGE_NO)
        			 when 0 then
          			''
         			else
          			'是'
       				end RH  
       				/*,case
                    (SELECT COUNT(*) FROM TBG02_SLAB_DOWNLINE where SLAB_NO = A.SLAB_NO)
        			 when 0 then
          			'热送'
         			else
          			'冷送'
       				end XXYY */
       				,case when h.remark is null then '热送' else '冷送' end XXYY     				
		          FROM TBG02_SLAB_COMM A
		           ,TBG02_CHARGE_COMM E
		           ,TBF01_SPEC_SLAB F
		           ,TBE02_ORD_PRC G
		           ,TBD01_SLABDN_OBJ2 B
		           ,TBG02_SLAB_DOWNLINE H
		           --,TBD01_SLABDN_OBJ2_DETAIL C
		          WHERE '1' = '1'
		          AND   A.PLAN_SLAB_NO = F.SLAB_MANA_NO(+)
		          and   a.ORD_NO = g.ORD_NO(+)
		          and   a.ORD_SEQ = g.ORD_SEQ(+)
		          AND   SUBSTR(A.SUB_SLAB_NO,1,10) = E.CHARGE_NO  
		          AND   A.DSN_SLAB_NO = B.DSN_SLAB_NO(+)
		          AND   A.SLAB_NO = H.SLAB_NO(+)
		          --AND   B.DSN_SLAB_NO = C.DSN_SLAB_NO(+)
		          
		          and    (select TO_DATE( A.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS') - TO_DATE( f.REG_DTIME,'YYYY-MM-DD HH24:MI:SS') from dual) > :1
		          AND    substr(A.SLAB_CUT_DTIME,1,8) >= :2
		          AND   substr(A.SLAB_CUT_DTIME,1,8) <= :3
		          AND   E.CC_DEVNO||'&' LIKE :4||'%'
		          AND   A.CAST_NO LIKE :5||'%'
		          AND   A.ORD_NO||'&' LIKE :6||'%'
		          AND   A.CHARGE_NO LIKE :7||'%'
		          AND   A.SLAB_NO LIKE :8||'%'
		          AND   A.SLAB_RT||'&' LIKE :9||'%'  
		          AND   A.NONORD_CAUSE_CD||'&' LIKE :10||'%'
		          -------------------------------------------
		          AND   A.SLAB_TOT_DEC_GRD||'&' LIKE :11||'%'
		          AND   A.SLAB_STAT LIKE :12||'%'
		          AND   A.STL_GRD LIKE :13||'%'
		          AND   E.CC_DEVNO LIKE :14||'%'
	              AND   B.L2_SCH_NO||'&' LIKE :15||'%'
	              AND   A.SLAB_THK BETWEEN :16 AND :17
	              AND   A.SLAB_WTH BETWEEN :18 AND :19
        ]]> 
  </query>
</queryMap>