XinYu_RZMES/.svn/pristine/64/6483bf428a887a296daa5d073b49dbea8a93b89a.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="SMS WORK INSTRUCTION INFORMATION DELETE">
              
   <query id="NIF012130_ChgSeqInf.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  A.CHG_SEQ  CHG_SEQ_ST
		           ,B.CHG_SEQ  CHG_SEQ_EN
		      FROM (SELECT  CHG_SEQ  FROM  TBF01_CHARGE_IDX  WHERE  CHARGE_MANA_NO   =   ?) A, 
		           (SELECT  CHG_SEQ  FROM  TBF01_CHARGE_IDX  WHERE  CHARGE_MANA_NO   =   ?) B 
       ]]>
   </query>

   <query id="NIF012130_ChgCntChk.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			SELECT  SUM(DECODE(L2_SEND,'Y',1,0))    L2_CNT              
             	   ,SUM(DECODE(STATUS_CD,'B',1,0))  STATUS_CNT
		      FROM  TBF01_CHARGE_IDX
		     WHERE  PRC_LINE        =        ?
		       AND  CHG_SEQ         BETWEEN  ?  AND  ?
       ]]>
   </query>

   <query id="NIF012130_OrdNoInf.select" desc="it's query from TBF01_SPEC_SLAB_D Table" fetchSize="10">
	   <![CDATA[
			SELECT  DISTINCT 
		            C.CHARGE_MANA_NO
		           ,A.ORD_NO
		           ,A.ORD_SEQ
		           ,D.PREV_CHARGE_WGT
		      FROM  TBF01_SPEC_SLAB_D A
		           ,TBF01_SPEC_SLAB   B
		           ,TBF01_CHARGE_IDX  C
		           ,TBF01_SPEC_CHARGE D
		     WHERE  A.ORD_FL          =        '1'
		       AND  A.SLAB_EDT_SEQ    =        B.SLAB_EDT_SEQ   
		       AND  B.CHARGE_EDT_SEQ  =        C.CHARGE_EDT_SEQ
		       AND  C.CHARGE_MANA_NO  =        D.CHARGE_MANA_NO
		       AND  C.L2_SEND         =        'N'
		       AND  C.STATUS_CD       =        'A'
		       AND  C.PRC_LINE        =        ?
		       AND  C.CHG_SEQ         BETWEEN  ?  AND  ?
		     ORDER  BY  C.CHARGE_MANA_NO
                       ,A.ORD_NO
                       ,A.ORD_SEQ
       ]]>
   </query>

   <query id="NIF012130_ChgInfBak.insert" desc="it's query from TBF01_SPEC_CHARGE_BK Table" fetchSize="10">
	   <![CDATA[
		    INSERT  INTO  TBF01_SPEC_CHARGE_BK 
		           (CHARGE_EDT_SEQ
                   ,CHARGE_MANA_NO
                   ,CAST_EDT_SEQ
                   ,CAST_MANA_NO
                   ,CAST_CHARGE_SEQ
                   ,CAST_EDT_CHARGE_CNT
                   ,PRODNM_CD
                   ,STL_GRD
                   ,STL_GRP_CD
                   ,CHARGE_RT
                   ,SPEC_ABBSYM
                   ,TREAT_RT_CD
                   ,PATH_PROC_CD
                   ,PATH_MILL_CD
                   ,LINE_PROC_CD
                   ,CCM_THK
                   ,CCM_WTH
                   ,CCM_TME
                   ,WID_CHG_FL
                   ,ORD_SLAB_CNT
                   ,NONORD_SLAB_CNT
                   ,NONORD_CHARGE_FL
                   ,SLAB_CNT
                   ,PREV_CHARGE_WGT
                   ,HCR_CLF
                   ,EMGMTR_NMG_CLF
                   ,SMS_DUEDATE
                   ,PRC_LINE
                   ,CCM_PRC_LINE
                   ,TD_NO
                   ,MD_NO1
                   ,MD_NO2
                   ,TD_USE_CNT
                   ,MD_USE_CNT1
                   ,MD_USE_CNT2
                   ,BOF_TEMP_TGT
                   ,CAS_TEMP_TGT
                   ,RH_TEMP_TGT
                   ,LF_TEMP_TGT
                   ,TD_TEMP_AVG
                   ,TD_TEMP_MIN
                   ,TD_TEMP_MAX
                   ,SOLIDE_TEMP_TGT1
                   ,SOLIDE_TEMP_TGT2
                   ,CC_SPEED_AVG1
                   ,CC_SPEED_MIN1
                   ,CC_SPEED_MAX1
                   ,CC_SPEED_AVG2
                   ,CC_SPEED_MIN2
                   ,CC_SPEED_MAX2
                   ,HM_STR_DTIME
                   ,BLOW_STR_DTIME
                   ,PRE_BOF_STR_DTIME
                   ,PRE_BOF_END_DTIME
                   ,PRE_CAS_STR_DTIME
                   ,PRE_CAS_END_DTIME
                   ,PRE_RH_STR_DTIME
                   ,PRE_RH_END_DTIME
                   ,PRE_LF_STR_DTIME
                   ,PRE_LF_END_DTIME
                   ,PRE_CCM_STR_DTIME
                   ,PRE_CCM_END_DTIME
                   ,PROG_CD
                   ,STATUS_CD
                   ,MILL_FL
                   ,FL
                   ,RESCH_CAUSE_CD
                   ,RESCH_DTIME
                   ,RESCH_ID
                   ,RTN_DTIME
                   ,RTN_ID
                   ,REG_DTIME
                   ,REG_ID)
			SELECT  A.CHARGE_EDT_SEQ
				   ,A.CHARGE_MANA_NO
				   ,A.CAST_EDT_SEQ
				   ,A.CAST_MANA_NO
				   ,A.CAST_CHARGE_SEQ
				   ,A.CAST_EDT_CHARGE_CNT
				   ,A.PRODNM_CD
				   ,A.STL_GRD
				   ,A.STL_GRP_CD
				   ,A.CHARGE_RT
				   ,A.SPEC_ABBSYM
				   ,A.TREAT_RT_CD
				   ,A.PATH_PROC_CD
		           ,A.PATH_MILL_CD
				   ,A.LINE_PROC_CD
				   ,A.CCM_THK
				   ,A.CCM_WTH
				   ,A.CCM_TME
				   ,A.WID_CHG_FL
				   ,A.ORD_SLAB_CNT
				   ,A.NONORD_SLAB_CNT
				   ,A.NONORD_CHARGE_FL
				   ,A.SLAB_CNT
				   ,A.PREV_CHARGE_WGT
				   ,A.HCR_CLF
				   ,A.EMGMTR_NMG_CLF
				   ,A.SMS_DUEDATE
				   ,A.PRC_LINE
				   ,A.CCM_PRC_LINE
				   ,A.TD_NO
				   ,A.MD_NO1
				   ,A.MD_NO2
				   ,A.TD_USE_CNT
				   ,A.MD_USE_CNT1
				   ,A.MD_USE_CNT2
				   ,A.BOF_TEMP_TGT
				   ,A.CAS_TEMP_TGT
				   ,A.RH_TEMP_TGT
				   ,A.LF_TEMP_TGT
				   ,A.TD_TEMP_AVG
				   ,A.TD_TEMP_MIN
				   ,A.TD_TEMP_MAX
				   ,A.SOLIDE_TEMP_TGT1
				   ,A.SOLIDE_TEMP_TGT2
				   ,A.CC_SPEED_AVG1
				   ,A.CC_SPEED_MIN1
				   ,A.CC_SPEED_MAX1
				   ,A.CC_SPEED_AVG2
				   ,A.CC_SPEED_MIN2
				   ,A.CC_SPEED_MAX2
				   ,A.HM_STR_DTIME
				   ,A.BLOW_STR_DTIME
				   ,A.PRE_BOF_STR_DTIME
				   ,A.PRE_BOF_END_DTIME
				   ,A.PRE_CAS_STR_DTIME
				   ,A.PRE_CAS_END_DTIME
				   ,A.PRE_RH_STR_DTIME
				   ,A.PRE_RH_END_DTIME
				   ,A.PRE_LF_STR_DTIME
				   ,A.PRE_LF_END_DTIME
				   ,A.PRE_CCM_STR_DTIME
				   ,A.PRE_CCM_END_DTIME
				   ,A.PROG_CD
				   ,A.STATUS_CD
				   ,A.MILL_FL
				   ,A.FL
				   ,A.RESCH_CAUSE_CD
				   ,A.RESCH_DTIME
				   ,A.RESCH_ID
				   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')
				   ,?
				   ,A.MOD_DTIME
				   ,A.MOD_ID
		      FROM  TBF01_SPEC_CHARGE A
		           ,TBF01_CHARGE_IDX  B
		     WHERE  A.CHARGE_EDT_SEQ  =        B.CHARGE_EDT_SEQ
		       AND  B.L2_SEND         =        'N'
		       AND  B.STATUS_CD       =        'A'
		       AND  B.PRC_LINE        =        ?
		       AND  B.CHG_SEQ         BETWEEN  ?  AND  ?
       ]]>
    
   </query>

   <query id="NIF012130_SlabDetDel.delete" desc="it's query from TBF01_SPEC_SLAB_D Table" fetchSize="10">
	   <![CDATA[
			DELETE  TBF01_SPEC_SLAB_D
		     WHERE  SLAB_EDT_SEQ    IN   (SELECT  A.SLAB_EDT_SEQ
		                                    FROM  TBF01_SPEC_SLAB  A
		                                         ,TBF01_CHARGE_IDX B
		                        		   WHERE  A.CHARGE_EDT_SEQ  =        B.CHARGE_EDT_SEQ
		                                     AND  B.L2_SEND         =        'N'
		                                     AND  B.STATUS_CD       =        'A'
		                                     AND  B.PRC_LINE        =        ?
		                                     AND  B.CHG_SEQ         BETWEEN  ?  AND  ?)
       ]]>
   </query>
	
   <query id="NIF012130_SlabdnUpt.update" desc="it's query from TBD01_SLABDN_RST2 Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBD01_SLABDN_OBJ2
		       SET  PROC_STAT     =    '01'
		     WHERE  DSN_SLAB_NO   IN   (SELECT  A.DSN_SLAB_NO
		                                  FROM  TBF01_SPEC_SLAB   A
		                                       ,TBF01_CHARGE_IDX  B
		                        		 WHERE  A.DSN_SLAB_NO     IS       NOT NULL
		                                   AND  A.CHARGE_EDT_SEQ  =        B.CHARGE_EDT_SEQ
		                                   AND  B.L2_SEND         =        'N'
		                                   AND  B.STATUS_CD       =        'A'
		                                   AND  B.PRC_LINE        =        ?
		                                   AND  B.CHG_SEQ         BETWEEN  ?  AND  ?)
       ]]>
   </query>

   <query id="NIF012130_SlabDel.delete" desc="it's query from TBF01_SPEC_SLAB Table" fetchSize="10">
       <![CDATA[
            DELETE  TBF01_SPEC_SLAB
             WHERE  CHARGE_EDT_SEQ   IN   (SELECT  CHARGE_EDT_SEQ
                                             FROM  TBF01_CHARGE_IDX
                                            WHERE  L2_SEND         =        'N'
                                              AND  STATUS_CD       =        'A'
                                              AND  PRC_LINE        =        ?
                                              AND  CHG_SEQ         BETWEEN  ?  AND  ?)
       ]]>
   </query>
		
   <query id="NIF012130_ChargeDel.delete" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			DELETE  TBF01_SPEC_CHARGE
		     WHERE  CHARGE_EDT_SEQ   IN   (SELECT  CHARGE_EDT_SEQ
		                                     FROM  TBF01_CHARGE_IDX
		                        		    WHERE  L2_SEND         =        'N'
		                                      AND  STATUS_CD       =        'A'
		                                      AND  PRC_LINE        =        ?
		                                      AND  CHG_SEQ         BETWEEN  ?  AND  ?)
       ]]>
   </query>

   <query id="NIF012130_ChargeCntUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
			UPDATE  TBF01_SPEC_CHARGE A
		       SET  A.CAST_EDT_CHARGE_CNT   =    (SELECT  COUNT(B.CHARGE_EDT_SEQ)
		                                            FROM  TBF01_SPEC_CHARGE B
		                                           WHERE  A.CAST_MANA_NO  =  B.CAST_MANA_NO)
		     WHERE  A.CAST_MANA_NO          IN   (SELECT  DISTINCT 
		                                                  B.CAST_MANA_NO
		                                            FROM  TBF01_SPEC_CHARGE B
		                                                 ,TBF01_CHARGE_IDX  C
		                        		           WHERE  B.CHARGE_EDT_SEQ  =        C.CHARGE_EDT_SEQ
		                                             AND  C.L2_SEND         =        'N'
		                                             AND  C.STATUS_CD       =        'A'
		                                             AND  C.PRC_LINE        =        ?
		                                             AND  C.CHG_SEQ         BETWEEN  ?  AND  ?) 
       ]]>
   </query>

   <query id="NIF012130_ChargeIdxDel.delete" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
	   <![CDATA[
			DELETE  TBF01_CHARGE_IDX
		     WHERE  L2_SEND         =        'N'
		       AND  STATUS_CD       =        'A'
		       AND  PRC_LINE        =        ?
		       AND  CHG_SEQ         BETWEEN  ?  AND  ?
       ]]>
   </query>

   <query id="NIF012130_SpecCastDel.delete" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
	   <![CDATA[
            DELETE FROM TBF01_SPEC_CAST T
            WHERE NOT EXISTS (SELECT 'X'
                              FROM TBF01_SPEC_CHARGE B
                              WHERE B.CAST_EDT_SEQ = T.CAST_EDT_SEQ)
       ]]>
   </query>
	
</queryMap>