XinYu_RZMES/.svn/pristine/5d/5d57a499b257f6e938935eedc7ee327bfc126010.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="MILL WORK INSTRUCTION SPLIT ROLL">
              
   <query id="NIF024080_RollManaNoChk.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
            SELECT  A.ROLL_SLAB_SEQ
              FROM  TBF02_SPEC_MILL  A
		     WHERE  A.ROLL_MANA_NO    =   ?
		       AND  A.SLAB_NO         =   ?                              
       ]]>
   </query>

   <query id="NIF024080_RollSlabStatusChk.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
		   
            SELECT   SUM(DECODE(A.STATUS_CD,'B',1,0))  STATUS_CD_CNT
                    ,SUM(DECODE(B.COIL_STAT,'0',1,0))  COIL_STAT_CNT
              FROM  TBF02_SPEC_MILL  A  
                    ,TBH02_COIL_COMM B
             WHERE  A.COIL_NO        =    B.COIL_NO(+)
               AND  A.ROLL_MANA_NO   =    ?
               AND  A.ROLL_SLAB_SEQ  >    ?                       
       ]]>
   </query>
	
   <query id="NIF024080_RollEdtSeqMax.select" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
       <![CDATA[
            SELECT  MAX(A.ROLL_EDT_SEQ)  ROLL_EDT_SEQ
              FROM  TBF02_SPEC_ROLL  A                           
       ]]>
   </query>

   <query id="NIF024080_ChgRollDel.delete" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
       <![CDATA[
            DELETE  FROM  TBF02_CHG_ROLL                           
       ]]>
   </query>
	
   <query id="NIF024080_ChgRollIns.insert" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBF02_CHG_ROLL
		           (ORG_SEQ
		           ,CHG_SEQ
		           ,ROLL_EDT_SEQ
		           ,ROLL_MANA_NO
		           ,CHG_ROLL_MANA_NO
		           ,FL)
		    SELECT  ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO)
		           ,ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO)
		           ,A.ROLL_EDT_SEQ
                   ,A.ROLL_MANA_NO
                   ,A.NEW_ROLL_MANA_NO
                   ,DECODE(B.ROLL_EDT_SEQ,NULL,'N','Y')
              FROM (SELECT  ROLL_EDT_SEQ
                           ,ROLL_MANA_NO    ROLL_MANA_NO 
                           ,DECODE(SUBSTR(ROLL_MANA_NO,2,4),9999,CHR(ASCII(SUBSTR(ROLL_MANA_NO,1,1)) + 1) || '0001', 
                                   SUBSTR(ROLL_MANA_NO,1,1) || LPAD(TO_CHAR(TO_NUMBER(SUBSTR(ROLL_MANA_NO,2,4)) + 1),4,'0')) NEW_ROLL_MANA_NO 
                      FROM  TBF02_SPEC_ROLL) A
                   ,TBF02_SPEC_ROLL  B
             WHERE  A.NEW_ROLL_MANA_NO   =   B.ROLL_MANA_NO(+)
		       AND  A.ROLL_MANA_NO       >   ?
             ORDER  BY  A.ROLL_MANA_NO
       ]]>
   </query>
	
   <query id="NIF024080_L2ROLLDelSend.insert" desc="it's query from TBH06_L2_ROLL_UNIT_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_ROLL_UNIT_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_DC
                   ,RECV_DC
                   ,SERIAL_NO
                   ,RESERVED
                   ,SEND_CLF
                   ,ROLL_UNIT_NO
                   ,UNIT_SLAB_CNT)		   
            SELECT  B.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO)  -- SEQ_NO
                   ,'N'                                     -- MSG_FLAG
                   ,'34'                                    -- SEND_LEN
                   ,'HMFU10'                                -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')    -- TRANS_DTIME
                   ,'FU'                                    -- SEND_DC
                   ,'HM'                                    -- RECV_DC
                   ,''                                      -- SERIAL_NO
                   ,''                                      -- RESERVED
                   ,'3'                                     -- SEND_CLF ('1': INSERT, '2': UPDATE  '3' : DELETE)
                   ,A.ROLL_MANA_NO                          -- ROLL_UNIT_NO 
                   ,A.ROLL_SLAB_CNT                         -- UNIT_SLAB_CNT
              FROM  TBF02_SPEC_ROLL  A
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_ROLL_UNIT_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') B
		           ,(SELECT  ROLL_MANA_NO
		               FROM  TBF02_CHG_ROLL
		              WHERE  ROLL_MANA_NO  <>  ?
		              MINUS
		             SELECT  CHG_ROLL_MANA_NO
		               FROM  TBF02_CHG_ROLL)  C
             WHERE  A.ROLL_MANA_NO   =   C.ROLL_MANA_NO
		     ORDER  BY  A.ROLL_MANA_NO
       ]]>
   </query> 	
	
   <query id="NIF024080_L2RHTDelSend.insert" desc="it's query from TBH06_L2_RHT_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_RHT_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_DC
                   ,RECV_DC
                   ,SERIAL_NO
                   ,RESERVED
                   ,SEND_CLF
                   ,SLAB_NO                
                   ,COIL_NO
                   ,ROLL_UNIT_NO           
                   ,ROLL_UNIT_SEQ          
                   ,SLAB_THK               
                   ,SLAB_WTH               
                   ,SLAB_LEN               
                   ,SLAB_WGT
                   ,STL_GRD
                   ,SPEC_ABBSYM
                   ,EXTRACT_TGT_TEMP       
                   ,EXTRACT_MAX_TEMP       
                   ,EXTRACT_MIN_TEMP       
                   ,CHARGING_TGT_TEMP      
                   ,CHARGING_MAX_TEMP      
                   ,HCR_FL                 
                   ,INFUR_MIN_HOUR         
                   ,INFUR_MAX_HOUR         
                   ,EQ_HT_MIN_HOUR         
                   ,EQ_HT_MAX_HOUR         
                   ,CHARGE_NO              
                   ,CAST_NO
                   ,CHEM_KIND
                   ,CHEM_AL
                   ,CHEM_AS
                   ,CHEM_B
                   ,CHEM_BE
                   ,CHEM_Bi
                   ,CHEM_C
                   ,CHEM_CA
                   ,CHEM_CE
                   ,CHEM_CO
                   ,CHEM_CR
                   ,CHEM_CU
                   ,CHEM_H      
                   ,CHEM_LA               
                   ,CHEM_MG          
                   ,CHEM_MN
                   ,CHEM_MO          
                   ,CHEM_N
                   ,CHEM_NB
                   ,CHEM_NI
                   ,CHEM_O
                   ,CHEM_P
                   ,CHEM_S
                   ,CHEM_SB
                   ,CHEM_SE
                   ,CHEM_SI
                   ,CHEM_TI
                   ,CHEM_SN
                   ,CHEM_TA
                   ,CHEM_TE
                   ,CHEM_PB
                   ,CHEM_PD
                   ,CHEM_V
                   ,CHEM_W
                   ,CHEM_ZN
                   ,CHEM_ZR
				   ,STRIP_AIM_THK)			   
            SELECT  C.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                    -- MSG_FLAG
                   ,'520'                                  -- SEND_LEN
                   ,'HMFU20'                               -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')   -- TRANS_DTIME
                   ,'FU'                                   -- SEND_DC
                   ,'HM'                                   -- RECV_DC
                   ,''                                     -- SERIAL_NO
                   ,''                                     -- RESERVED
                   ,'3'                                    -- SEND_CLF
                   ,A.SLAB_NO                              -- SLAB_NO                
                   ,A.COIL_NO                              -- COIL_NO
                   ,A.ROLL_MANA_NO                         -- ROLL_UNIT_NO           
                   ,TO_CHAR(A.ROLL_SLAB_SEQ)               -- ROLL_UNIT_SEQ          
                   ,TO_CHAR(A.SLAB_THK)                    -- SLAB_THK               
                   ,TO_CHAR(A.SLAB_WTH)                    -- SLAB_WTH               
                   ,TO_CHAR(A.SLAB_LEN)                    -- SLAB_LEN               
                   ,TO_CHAR(A.SLAB_WGT)                    -- SLAB_WGT
                   ,A.SPEC_STL_GRD                         -- STL_GRD
                   ,A.SPEC_ABBSYM                          -- SPEC_ABBSYM
                   ,A.CHG_TMP_TGT                          -- EXTRACT_TGT_TEMP       
                   ,A.CHG_TMP_MAX                          -- EXTRACT_MAX_TEMP       
                   ,A.CHG_TMP_MIN                          -- EXTRACT_MIN_TEMP       
                   ,A.CRACK_TGT                            -- CHARGING_TGT_TEMP      
                   ,A.CRACK_MAX                            -- CHARGING_MAX_TEMP      
                   ,DECODE(A.HCR_CLF,'C','0','1')          -- HCR_FL                 
                   ,A.FUR_TME_MIN                          -- INFUR_MIN_HOUR         
                   ,A.FUR_TME_MAX                          -- INFUR_MAX_HOUR         
                   ,A.CRACK_TME_MIN                        -- EQ_HT_MIN_HOUR         
                   ,A.CRACK_TME_MAX                        -- EQ_HT_MAX_HOUR         
                   ,SUBSTR(A.SLAB_NO,1,10)                 -- CHARGE_NO              
                   ,A.CAST_NO                              -- CAST_NO
                   ,B.CHEM_CLF                             -- CHEM_KIND
                   ,TO_CHAR(B.CHEM_Al)                     -- CHEM_Al
                   ,TO_CHAR(B.CHEM_As)                     -- CHEM_As
                   ,TO_CHAR(B.CHEM_B)                      -- CHEM_B
                   ,TO_CHAR(B.CHEM_Be)                     -- CHEM_Be
                   ,TO_CHAR(B.CHEM_Bi)                     -- CHEM_Bi
                   ,TO_CHAR(B.CHEM_C)                      -- CHEM_C
                   ,TO_CHAR(B.CHEM_Ca)                     -- CHEM_Ca
                   ,TO_CHAR(B.CHEM_Ce)                     -- CHEM_Ce
                   ,TO_CHAR(B.CHEM_Co)                     -- CHEM_Co
                   ,TO_CHAR(B.CHEM_Cr)                     -- CHEM_Cr
                   ,TO_CHAR(B.CHEM_Cu)                     -- CHEM_Cu
                   ,TO_CHAR(B.CHEM_H)                      -- CHEM_H      
                   ,TO_CHAR(B.CHEM_La)                     -- CHEM_La               
                   ,TO_CHAR(B.CHEM_Mg)                     -- CHEM_Mg          
                   ,TO_CHAR(B.CHEM_Mn)                     -- CHEM_Mn
                   ,TO_CHAR(B.CHEM_Mo)                     -- CHEM_Mo          
                   ,TO_CHAR(B.CHEM_N)                      -- CHEM_N
                   ,TO_CHAR(B.CHEM_Nb)                     -- CHEM_Nb
                   ,TO_CHAR(B.CHEM_Ni)                     -- CHEM_Ni
                   ,TO_CHAR(B.CHEM_O)                      -- CHEM_O
                   ,TO_CHAR(B.CHEM_P)                      -- CHEM_P
                   ,TO_CHAR(B.CHEM_S)                      -- CHEM_S
                   ,TO_CHAR(B.CHEM_Sb)                     -- CHEM_Sb
                   ,TO_CHAR(B.CHEM_Se)                     -- CHEM_Se
                   ,TO_CHAR(B.CHEM_Si)                     -- CHEM_Si
                   ,TO_CHAR(B.CHEM_Ti)                     -- CHEM_Ti
                   ,TO_CHAR(B.CHEM_Sn)                     -- CHEM_Sn
                   ,TO_CHAR(B.CHEM_Ta)                     -- CHEM_Ta
                   ,TO_CHAR(B.CHEM_Te)                     -- CHEM_Te
                   ,TO_CHAR(B.CHEM_Pb)                     -- CHEM_Pb
                   ,TO_CHAR(B.CHEM_Pd)                     -- CHEM_Pd
                   ,TO_CHAR(B.CHEM_V)                      -- CHEM_V
                   ,TO_CHAR(B.CHEM_W)                      -- CHEM_W
                   ,TO_CHAR(B.CHEM_Zn)                     -- CHEM_Zn
                   ,TO_CHAR(B.CHEM_Zr)                     -- CHEM_Zr
		           ,TO_CHAR(B.STRIP_AIM_THK)               --STRIP_AIM_THK
              FROM  TBF02_SPEC_MILL     A
                   ,TBF02_SPEC_MILL_DET B
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_RHT_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
                   ,(SELECT  ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO  <>  ?
                      MINUS
                     SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL)  D
             WHERE  A.ROLL_MANA_NO   =   D.ROLL_MANA_NO
               AND  A.SLAB_EDT_SEQ   =   B.SLAB_EDT_SEQ(+)
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ
       ]]>
   </query> 
	
   <query id="NIF024080_L2MILLDelSend.insert" desc="it's query from TBH06_L2_MILL_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_MILL_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SLAB_NO                
                   ,COIL_NO
                   ,ROLL_MANA_NO           
                   ,CHARGE_NO   
                   ,CAST_NO
                   ,ROLL_SLAB_SEQ 
                   ,TRANS_FLAG
                   ,STL_GRD
                   ,SPEC_ABBSYM
                   ,ROUTE
                   ,MC_NO
                   ,SLAB_LEN  
                   ,SLAB_WTH  
                   ,SLAB_TAPER
                   ,SLAB_WTH_HEAD
                   ,SLAB_WTH_TAIL
                   ,WTH_CHG_STS
                   ,WTH_CHG_END   
                   ,SLAB_THK  
                   ,SLAB_WGT  
                   ,HCR_CLF
                   ,FERR_MODE
                   ,FERR_CON_STA_TGT_TEMP  
                   ,FERR_CON_END_TGT_TEMP  
                   ,EXTRACT_TGT_TEMP 
                   ,RM2_EXIT_TGT_TEMP 
                   ,RM2_EXIT_MIN_TEMP 
                   ,RM2_EXIT_MAX_TEMP
                   ,STRIP_AIM_THK 
                   ,STRIP_MAX_THK 
                   ,STRIP_MIN_THK 
                   ,STRIP_CHG_TGT_THK 
                   ,STRIP_CHG_MAX_THK 
                   ,STRIP_CHG_MIN_THK                     
                   ,STRIP_AIM_WTH
                   ,STRIP_MAX_WTH 
                   ,STRIP_MIN_WTH 
                   ,STRIP_AIM_TEMP
                   ,STRIP_MAX_TEMP 
                   ,STRIP_MIN_TEMP    
                   ,CROWN_AIM_C40
                   ,CROWN_MAX_C40 
                   ,CROWN_MIN_C40 
                   ,FM_SYM_STRIP_FLATNESS_DEV 
                   ,FM_ASY_STRIP_FLATNESS_DEV 
                   ,STRIP_WEDGE_MIN
                   ,STRIP_WEDGE_MAX
                   ,COOLING_MODE
                   ,DUAL_PAHSE
                   ,DUAL_TEMP 
                   ,DUAL_TIME 
                   ,UNCOIL_HEAD_LEN                       
                   ,UNCOIL_TAIL_LEN                       
                   ,UNCOOL_AREA_LEN                       
                   ,COOLING_RATE_TOP                                          
                   ,COOLING_RATE_BOT                                          
                   ,COOL_EXIT_TGT_TEMP                                            
                   ,COOL_EXIT_MAX_TEMP                                            
                   ,COOL_EXIT_MIN_TEMP                                            
                   ,SAMPLE_NO
                   ,INSPECT_YN
                   ,BINDING_AMT_CIRC                                          
                   ,BINDING_AMT_RADI  
                   ,SMP_YS                                            
                   ,SMP_YP    
                   ,ALLOY_COMP_THK_DEV
                   ,DILAT_CURVE
                   ,DIAMOND_FLAG
                   ,STS_FLAG
                   ,ORD_NO
                   ,COIL_LAYER
                   ,HAEA_TAIL_CD  
                   ,PDI_COMM 
                   ,CHEM_CLF
                   ,CHEM_AL
                   ,CHEM_AS
                   ,CHEM_B
                   ,CHEM_BE
                   ,CHEM_BI
                   ,CHEM_C
                   ,CHEM_CA
                   ,CHEM_CE
                   ,CHEM_CO
                   ,CHEM_CR
                   ,CHEM_CU
                   ,CHEM_H      
                   ,CHEM_LA               
                   ,CHEM_MG          
                   ,CHEM_MN
                   ,CHEM_MO          
                   ,CHEM_N
                   ,CHEM_NB
                   ,CHEM_NI
                   ,CHEM_O
                   ,CHEM_P
                   ,CHEM_PB
                   ,CHEM_PD
                   ,CHEM_S
                   ,CHEM_SB
                   ,CHEM_SE
                   ,CHEM_SI
                   ,CHEM_SN
                   ,CHEM_TA
                   ,CHEM_TE
                   ,CHEM_TI
                   ,CHEM_V
                   ,CHEM_W
                   ,CHEM_ZN
                   ,CHEM_ZR
                   ,RESERVE_FIELD1
                   ,RESERVE_FIELD2
                   ,RESERVE_FIELD3
                   ,RESERVE_FIELD4
                   ,RESERVE_FIELD5)       		   
            SELECT  C.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                    -- MSG_FLAG
                   ,'833'                                  -- SEND_LEN
                   ,'4001'                                 -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')   -- TRANS_DTIME
                   ,A.SLAB_NO                              -- SLAB_NO                
                   ,A.COIL_NO                              -- COIL_NO
                   ,A.ROLL_MANA_NO                         -- ROLL_MANA_NO           
                   ,SUBSTR(A.SLAB_NO,1,10)                 -- CHARGE_NO   
                   ,A.CAST_NO                              -- CAST_NO
                   ,TO_CHAR(A.ROLL_SLAB_SEQ)               -- ROLL_SLAB_SEQ 
                   ,'3'                                    -- TRANS_FLAG
                   ,A.SPEC_STL_GRD                         -- STL_GRD
                   ,A.SPEC_ABBSYM                          -- SPEC_ABBSYM
                   ,''                                     -- ROUTE
                   ,A.CCM_PRC_LINE                         -- MC_NO
                   ,TO_CHAR(A.SLAB_LEN)                    -- SLAB_LEN  
                   ,TO_CHAR(A.SLAB_WTH)                    -- SLAB_WTH  
                   ,A.SLAB_TAPER                           -- SLAB_TAPER
                   ,TO_CHAR(A.SLAB_WTH_HEAD)               -- SLAB_WTH_HEAD
                   ,TO_CHAR(A.SLAB_WTH_TAIL)               -- SLAB_WTH_TAIL
                   ,TO_CHAR(A.WTH_CHG_STS)                 -- WTH_CHG_STS
                   ,TO_CHAR(WTH_CHG_END)                   -- WTH_CHG_END   
                   ,TO_CHAR(A.SLAB_THK)                    -- SLAB_THK  
                   ,TO_CHAR(A.SLAB_WGT)                    -- SLAB_WGT  
                   ,DECODE(A.HCR_CLF,'C','0','1')          -- HCR_FL
                   ,B.FERR_MODE                            -- FERR_MODE
                   ,TO_CHAR(B.FERR_CON_STA_TGT_TEMP)       -- FERR_CON_STA_TGT_TEMP  
                   ,TO_CHAR(B.FERR_CON_END_TGT_TEMP)       -- FERR_CON_END_TGT_TEMP  
                   ,TO_CHAR(B.EXTRACT_TGT_TEMP)            -- EXTRACT_TGT_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_TGT_TEMP)           -- RM2_EXIT_TGT_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_MIN_TEMP)           -- RM2_EXIT_MIN_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_MAX_TEMP)           -- RM2_EXIT_MAX_TEMP
                   ,TO_CHAR(B.STRIP_AIM_THK)               -- STRIP_AIM_THK 
                   ,TO_CHAR(B.STRIP_MAX_THK)               -- STRIP_MAX_THK 
                   ,TO_CHAR(B.STRIP_MIN_THK)               -- STRIP_MIN_THK 
                   ,TO_CHAR(B.STRIP_CHG_TGT_THK)           -- STRIP_CHG_TGT_THK 
                   ,TO_CHAR(B.STRIP_CHG_MAX_THK)           -- STRIP_CHG_MAX_THK 
                   ,TO_CHAR(B.STRIP_CHG_MIN_THK)           -- STRIP_CHG_MIN_THK                     
                   ,TO_CHAR(B.STRIP_AIM_WTH)               -- STRIP_AIM_WTH
                   ,TO_CHAR(B.STRIP_MAX_WTH)               -- STRIP_MAX_WTH 
                   ,TO_CHAR(B.STRIP_MIN_WTH)               -- STRIP_MIN_WTH 
                   ,TO_CHAR(B.STRIP_TGT_TEMP)              -- STRIP_AIM_TEMP
                   ,TO_CHAR(B.STRIP_MAX_TEMP)              -- STRIP_MAX_TEMP 
                   ,TO_CHAR(B.STRIP_MIN_TEMP)              -- STRIP_MIN_TEMP    
                   ,B.CROWN_AIM_C40                        -- CROWN_AIM_C40
                   ,B.CROWN_MAX_C40                        -- CROWN_MAX_C40 
                   ,B.CROWN_MIN_C40                        -- CROWN_MIN_C40 
                   ,B.FM_SYM_STRIP_FLATNESS_DEV            -- FM_SYM_STRIP_FLATNESS_DEV 
                   ,B.FM_ASY_STRIP_FLATNESS_DEV            -- FM_ASY_STRIP_FLATNESS_DEV 
                   ,B.STRIP_WEDGE_MIN                      -- STRIP_WEDGE_MIN
                   ,B.STRIP_WEDGE_MAX                      -- STRIP_WEDGE_MAX
                   ,B.COOLING_MODE                         -- COOLING_MODE
                   ,B.DUAL_PAHSE                           -- DUAL_PAHSE
                   ,TO_CHAR(B.DUAL_TEMP)                   -- DUAL_TEMP 
                   ,TO_CHAR(B.DUAL_TIME)                   -- DUAL_TIME 
                   ,TO_CHAR(B.UNCOIL_HEAD_LEN)             -- UNCOIL_HEAD_LEN                       
                   ,TO_CHAR(B.UNCOIL_TAIL_LEN)             -- UNCOIL_TAIL_LEN                       
                   ,TO_CHAR(B.UNCOOL_AREA_LEN)             -- UNCOOL_AREA_LEN                       
                   ,TO_CHAR(B.COOLING_RATE_TOP)            -- COOLING_RATE_TOP                                          
                   ,TO_CHAR(B.COOLING_RATE_BOT)            -- COOLING_RATE_BOT                                          
                   ,TO_CHAR(B.COOL_EXIT_TGT_TEMP)          -- COOL_EXIT_TGT_TEMP                                            
                   ,TO_CHAR(B.COOL_EXIT_MAX_TEMP)          -- COOL_EXIT_MAX_TEMP                                            
                   ,TO_CHAR(B.COOL_EXIT_MIN_TEMP)          -- COOL_EXIT_MIN_TEMP                                            
                   ,B.SAMPLE_NO                            -- SAMPLE_NO
                   ,B.INSPECT_YN                           -- INSPECT_YN
                   ,TO_CHAR(B.BINDING_AMT_CIRC)            -- BINDING_AMT_CIRC                                          
                   ,TO_CHAR(B.BINDING_AMT_RADI)            -- BINDING_AMT_RADI  
                   ,TO_CHAR(B.SMP_YS)                      -- SMP_YS                                            
                   ,TO_CHAR(B.SMP_YP)                      -- SMP_YP    
                   ,B.ALLOY_COMP_THK_DEV                   -- ALLOY_COMP_THK_DEV
                   ,B.DILAT_CURVE                          -- DILAT_CURVE
                   ,B.DIAMOND_FLAG                         -- DIAMOND_FLAG
                   ,B.STS_FLAG                             -- STS_FLAG
                   ,SUBSTR(B.ORD_NO,1,15)                               -- ORD_NO
                   ,B.COIL_LAYER                           -- COIL_LAYER
                   ,B.HAEA_TAIL_CD                         -- HAEA_TAIL_CD  
                   ,B.PDI_COMM                             -- PDI_COMM 
                   ,DECODE(B.CHEM_CLF,'0','2',B.CHEM_CLF)  -- CHEM_KIND
                   ,TO_CHAR(B.CHEM_Al)                     -- CHEM_Al
                   ,TO_CHAR(B.CHEM_As)                     -- CHEM_As
                   ,TO_CHAR(B.CHEM_B)                      -- CHEM_B
                   ,TO_CHAR(B.CHEM_Be)                     -- CHEM_Be
                   ,TO_CHAR(B.CHEM_Bi)                     -- CHEM_Bi
                   ,TO_CHAR(B.CHEM_C)                      -- CHEM_C
                   ,TO_CHAR(B.CHEM_Ca)                     -- CHEM_Ca
                   ,TO_CHAR(B.CHEM_Ce)                     -- CHEM_Ce
                   ,TO_CHAR(B.CHEM_Co)                     -- CHEM_Co
                   ,TO_CHAR(B.CHEM_Cr)                     -- CHEM_Cr
                   ,TO_CHAR(B.CHEM_Cu)                     -- CHEM_Cu
                   ,TO_CHAR(B.CHEM_H)                      -- CHEM_H      
                   ,TO_CHAR(B.CHEM_La)                     -- CHEM_La               
                   ,TO_CHAR(B.CHEM_Mg)                     -- CHEM_Mg          
                   ,TO_CHAR(B.CHEM_Mn)                     -- CHEM_Mn
                   ,TO_CHAR(B.CHEM_Mo)                     -- CHEM_Mo          
                   ,TO_CHAR(B.CHEM_N)                      -- CHEM_N
                   ,TO_CHAR(B.CHEM_Nb)                     -- CHEM_Nb
                   ,TO_CHAR(B.CHEM_Ni)                     -- CHEM_Ni
                   ,TO_CHAR(B.CHEM_O)                      -- CHEM_O
                   ,TO_CHAR(B.CHEM_P)                      -- CHEM_P
                   ,TO_CHAR(B.CHEM_Pb)                     -- CHEM_Pb
                   ,TO_CHAR(B.CHEM_Pd)                     -- CHEM_Pd
                   ,TO_CHAR(B.CHEM_S)                      -- CHEM_S
                   ,TO_CHAR(B.CHEM_Sb)                     -- CHEM_Sb
                   ,TO_CHAR(B.CHEM_Se)                     -- CHEM_Se
                   ,TO_CHAR(B.CHEM_Si)                     -- CHEM_Si
                   ,TO_CHAR(B.CHEM_Sn)                     -- CHEM_Sn
                   ,TO_CHAR(B.CHEM_Ta)                     -- CHEM_Ta
                   ,TO_CHAR(B.CHEM_Te)                     -- CHEM_Te
                   ,TO_CHAR(B.CHEM_Ti)                     -- CHEM_Ti
                   ,TO_CHAR(B.CHEM_V)                      -- CHEM_V
                   ,TO_CHAR(B.CHEM_W)                      -- CHEM_W
                   ,TO_CHAR(B.CHEM_Zn)                     -- CHEM_Zn
                   ,TO_CHAR(B.CHEM_Zr)                     -- CHEM_Zr
                   ,''                                     -- RESERVE_FIELD1
                   ,''                                     -- RESERVE_FIELD2
                   ,''                                     -- RESERVE_FIELD3
                   ,''                                     -- RESERVE_FIELD4
                   ,''                                     -- RESERVE_FIELD5
              FROM  TBF02_SPEC_MILL     A
                   ,TBF02_SPEC_MILL_DET B
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_MILL_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
                   ,(SELECT  ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO  <>  ?
                      MINUS
                     SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL)  D		   
             WHERE  A.ROLL_MANA_NO   =   D.ROLL_MANA_NO
               AND  A.SLAB_EDT_SEQ   =   B.SLAB_EDT_SEQ(+)
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ
       ]]>
   </query> 
	
   <query id="NIF024080_L2ROLLCOILDelSend.insert" desc="it's query from TBH06_L2_COIL_NO_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO TBH06_L2_COIL_NO_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_LEN
                   ,SET_SEQ
                   ,COIL_NO)		   
            SELECT  B.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                   -- MSG_FLAG
                   ,'4003'                                -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')  -- TRANS_DTIME
                   ,''                                    -- SEND_LEN
                   ,?                                     -- SET_SEQ
                   ,A.SLAB_NO                             -- COIL_NO
              FROM  TBF02_SPEC_MILL  A
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_COIL_NO_INS 
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%')  B
                   ,(SELECT  ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO  <>  ?
                      MINUS
                     SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL)  C        
             WHERE  A.ROLL_MANA_NO   =   C.ROLL_MANA_NO
       ]]>
   </query>         
	
   <query id="NIF024080_ChgRollSel.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
            SELECT  A.ROLL_MANA_NO
                   ,A.CHG_ROLL_MANA_NO
              FROM  TBF02_SPEC_MILL  A
             WHERE  A.ROLL_MANA_NO    >   ?
             ORDER  BY  A.ORG_SEQ                              
       ]]>
   </query>
	
   <query id="NIF024080_SpecRollUpd.update" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_SPEC_ROLL  A
               SET  A.ROLL_MANA_NO    =    (SELECT  B.CHG_ROLL_MANA_NO
		                                      FROM  TBF02_CHG_ROLL  B
		                                     WHERE  B.ROLL_MANA_NO  =  A.ROLL_MANA_NO)
		           ,A.FL              =    'Y'
             WHERE  A.ROLL_MANA_NO    >    ?
               AND  A.FL              IS   NULL                              
       ]]>
   </query>
		
   <query id="NIF024080_SpecMillUpd.update" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_SPEC_MILL  A
               SET  A.ROLL_MANA_NO    =    (SELECT  B.CHG_ROLL_MANA_NO
                                              FROM  TBF02_CHG_ROLL  B
                                             WHERE  B.ROLL_MANA_NO  =  A.ROLL_MANA_NO)
                   ,A.FL              =    'Y'
             WHERE  A.ROLL_MANA_NO    >    ?
               AND  A.FL              IS   NULL                              
       ]]>
   </query>
	
   <query id="NIF024080_MillIdxUpd.update" desc="it's query from TBF02_MILL_IDX Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_MILL_IDX  A
               SET  A.ROLL_MANA_NO    =    (SELECT  B.CHG_ROLL_MANA_NO
                                              FROM  TBF02_CHG_ROLL  B
                                             WHERE  B.ROLL_MANA_NO  =  A.ROLL_MANA_NO)
                   ,A.FL              =    'Y'
             WHERE  A.ROLL_MANA_NO    >    ?
               AND  A.FL              IS   NULL                              
       ]]>
   </query>
	
   <query id="NIF024080_L2ROLLUpdInsSend.insert" desc="it's query from TBH06_L2_ROLL_UNIT_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_ROLL_UNIT_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_DC
                   ,RECV_DC
                   ,SERIAL_NO
                   ,RESERVED
                   ,SEND_CLF
                   ,ROLL_UNIT_NO
                   ,UNIT_SLAB_CNT)         		   
            SELECT  B.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO)  -- SEQ_NO
                   ,'N'                                     -- MSG_FLAG
                   ,'34'                                    -- SEND_LEN
                   ,'HMFU10'                                -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')    -- TRANS_DTIME
                   ,'FU'                                    -- SEND_DC
                   ,'HM'                                    -- RECV_DC
                   ,''                                      -- SERIAL_NO
                   ,''                                      -- RESERVED
                   ,?                                       -- SEND_CLF ('1': INSERT, '2': UPDATE  '3' : DELETE)
                   ,A.ROLL_MANA_NO                          -- ROLL_UNIT_NO 
                   ,A.ROLL_SLAB_CNT                         -- UNIT_SLAB_CNT
              FROM  TBF02_SPEC_ROLL  A
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_ROLL_UNIT_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') B
                   ,(SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO   >   ?
		                AND  FL             =   ? )  C
             WHERE  A.ROLL_MANA_NO   =   C.CHG_ROLL_MANA_NO
		     ORDER  BY  A.ROLL_MANA_NO
       ]]>
   </query>     
	
   <query id="NIF024080_L2RHTUpdInsSend.insert" desc="it's query from TBH06_L2_RHT_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_RHT_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_DC
                   ,RECV_DC
                   ,SERIAL_NO
                   ,RESERVED
                   ,SEND_CLF
                   ,SLAB_NO                
                   ,COIL_NO
                   ,ROLL_UNIT_NO           
                   ,ROLL_UNIT_SEQ          
                   ,SLAB_THK               
                   ,SLAB_WTH               
                   ,SLAB_LEN               
                   ,SLAB_WGT
                   ,STL_GRD
                   ,SPEC_ABBSYM
                   ,EXTRACT_TGT_TEMP       
                   ,EXTRACT_MAX_TEMP       
                   ,EXTRACT_MIN_TEMP       
                   ,CHARGING_TGT_TEMP      
                   ,CHARGING_MAX_TEMP      
                   ,HCR_FL                 
                   ,INFUR_MIN_HOUR         
                   ,INFUR_MAX_HOUR         
                   ,EQ_HT_MIN_HOUR         
                   ,EQ_HT_MAX_HOUR         
                   ,CHARGE_NO              
                   ,CAST_NO
                   ,CHEM_KIND
                   ,CHEM_AL
                   ,CHEM_AS
                   ,CHEM_B
                   ,CHEM_BE
                   ,CHEM_Bi
                   ,CHEM_C
                   ,CHEM_CA
                   ,CHEM_CE
                   ,CHEM_CO
                   ,CHEM_CR
                   ,CHEM_CU
                   ,CHEM_H      
                   ,CHEM_LA               
                   ,CHEM_MG          
                   ,CHEM_MN
                   ,CHEM_MO          
                   ,CHEM_N
                   ,CHEM_NB
                   ,CHEM_NI
                   ,CHEM_O
                   ,CHEM_P
                   ,CHEM_S
                   ,CHEM_SB
                   ,CHEM_SE
                   ,CHEM_SI
                   ,CHEM_TI
                   ,CHEM_SN
                   ,CHEM_TA
                   ,CHEM_TE
                   ,CHEM_PB
                   ,CHEM_PD
                   ,CHEM_V
                   ,CHEM_W
                   ,CHEM_ZN
                   ,CHEM_ZR)		   
            SELECT  C.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                    -- MSG_FLAG
                   ,'520'                                  -- SEND_LEN
                   ,'HMFU20'                               -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')   -- TRANS_DTIME
                   ,'FU'                                   -- SEND_DC
                   ,'HM'                                   -- RECV_DC
                   ,''                                     -- SERIAL_NO
                   ,''                                     -- RESERVED
                   ,?                                      -- SEND_CLF
                   ,A.SLAB_NO                              -- SLAB_NO                
                   ,A.COIL_NO                              -- COIL_NO
                   ,A.ROLL_MANA_NO                         -- ROLL_UNIT_NO           
                   ,TO_CHAR(A.ROLL_SLAB_SEQ)               -- ROLL_UNIT_SEQ          
                   ,TO_CHAR(A.SLAB_THK)                    -- SLAB_THK               
                   ,TO_CHAR(A.SLAB_WTH)                    -- SLAB_WTH               
                   ,TO_CHAR(A.SLAB_LEN)                    -- SLAB_LEN               
                   ,TO_CHAR(A.SLAB_WGT)                    -- SLAB_WGT
                   ,A.SPEC_STL_GRD                         -- STL_GRD
                   ,A.SPEC_ABBSYM                          -- SPEC_ABBSYM
                   ,A.CHG_TMP_TGT                          -- EXTRACT_TGT_TEMP       
                   ,A.CHG_TMP_MAX                          -- EXTRACT_MAX_TEMP       
                   ,A.CHG_TMP_MIN                          -- EXTRACT_MIN_TEMP       
                   ,A.CRACK_TGT                            -- CHARGING_TGT_TEMP      
                   ,A.CRACK_MAX                            -- CHARGING_MAX_TEMP      
                   ,DECODE(A.HCR_CLF,'C','0','1')          -- HCR_FL                 
                   ,A.FUR_TME_MIN                          -- INFUR_MIN_HOUR         
                   ,A.FUR_TME_MAX                          -- INFUR_MAX_HOUR         
                   ,A.CRACK_TME_MIN                        -- EQ_HT_MIN_HOUR         
                   ,A.CRACK_TME_MAX                        -- EQ_HT_MAX_HOUR         
                   ,SUBSTR(A.SLAB_NO,1,10)                 -- CHARGE_NO              
                   ,A.CAST_NO                              -- CAST_NO
                   ,B.CHEM_CLF                             -- CHEM_KIND
                   ,TO_CHAR(B.CHEM_Al)                     -- CHEM_Al
                   ,TO_CHAR(B.CHEM_As)                     -- CHEM_As
                   ,TO_CHAR(B.CHEM_B)                      -- CHEM_B
                   ,TO_CHAR(B.CHEM_Be)                     -- CHEM_Be
                   ,TO_CHAR(B.CHEM_Bi)                     -- CHEM_Bi
                   ,TO_CHAR(B.CHEM_C)                      -- CHEM_C
                   ,TO_CHAR(B.CHEM_Ca)                     -- CHEM_Ca
                   ,TO_CHAR(B.CHEM_Ce)                     -- CHEM_Ce
                   ,TO_CHAR(B.CHEM_Co)                     -- CHEM_Co
                   ,TO_CHAR(B.CHEM_Cr)                     -- CHEM_Cr
                   ,TO_CHAR(B.CHEM_Cu)                     -- CHEM_Cu
                   ,TO_CHAR(B.CHEM_H)                      -- CHEM_H      
                   ,TO_CHAR(B.CHEM_La)                     -- CHEM_La               
                   ,TO_CHAR(B.CHEM_Mg)                     -- CHEM_Mg          
                   ,TO_CHAR(B.CHEM_Mn)                     -- CHEM_Mn
                   ,TO_CHAR(B.CHEM_Mo)                     -- CHEM_Mo          
                   ,TO_CHAR(B.CHEM_N)                      -- CHEM_N
                   ,TO_CHAR(B.CHEM_Nb)                     -- CHEM_Nb
                   ,TO_CHAR(B.CHEM_Ni)                     -- CHEM_Ni
                   ,TO_CHAR(B.CHEM_O)                      -- CHEM_O
                   ,TO_CHAR(B.CHEM_P)                      -- CHEM_P
                   ,TO_CHAR(B.CHEM_S)                      -- CHEM_S
                   ,TO_CHAR(B.CHEM_Sb)                     -- CHEM_Sb
                   ,TO_CHAR(B.CHEM_Se)                     -- CHEM_Se
                   ,TO_CHAR(B.CHEM_Si)                     -- CHEM_Si
                   ,TO_CHAR(B.CHEM_Ti)                     -- CHEM_Ti
                   ,TO_CHAR(B.CHEM_Sn)                     -- CHEM_Sn
                   ,TO_CHAR(B.CHEM_Ta)                     -- CHEM_Ta
                   ,TO_CHAR(B.CHEM_Te)                     -- CHEM_Te
                   ,TO_CHAR(B.CHEM_Pb)                     -- CHEM_Pb
                   ,TO_CHAR(B.CHEM_Pd)                     -- CHEM_Pd
                   ,TO_CHAR(B.CHEM_V)                      -- CHEM_V
                   ,TO_CHAR(B.CHEM_W)                      -- CHEM_W
                   ,TO_CHAR(B.CHEM_Zn)                     -- CHEM_Zn
                   ,TO_CHAR(B.CHEM_Zr)                     -- CHEM_Zr
              FROM  TBF02_SPEC_MILL     A
                   ,TBF02_SPEC_MILL_DET B
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_RHT_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
                   ,(SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO   >   ?
                        AND  FL             =   ? )  D
             WHERE  A.ROLL_MANA_NO   =   D.CHG_ROLL_MANA_NO
               AND  A.SLAB_EDT_SEQ   =   B.SLAB_EDT_SEQ(+)
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ
       ]]>
   </query> 	
	
   <query id="NIF024080_L2MILLUpdInsSend.insert" desc="it's query from TBH06_L2_MILL_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_MILL_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SLAB_NO                
                   ,COIL_NO
                   ,ROLL_MANA_NO           
                   ,CHARGE_NO   
                   ,CAST_NO
                   ,ROLL_SLAB_SEQ 
                   ,TRANS_FLAG
                   ,STL_GRD
                   ,SPEC_ABBSYM
                   ,ROUTE
                   ,MC_NO
                   ,SLAB_LEN  
                   ,SLAB_WTH  
                   ,SLAB_TAPER
                   ,SLAB_WTH_HEAD
                   ,SLAB_WTH_TAIL
                   ,WTH_CHG_STS
                   ,WTH_CHG_END   
                   ,SLAB_THK  
                   ,SLAB_WGT  
                   ,HCR_CLF
                   ,FERR_MODE
                   ,FERR_CON_STA_TGT_TEMP  
                   ,FERR_CON_END_TGT_TEMP  
                   ,EXTRACT_TGT_TEMP 
                   ,RM2_EXIT_TGT_TEMP 
                   ,RM2_EXIT_MIN_TEMP 
                   ,RM2_EXIT_MAX_TEMP
                   ,STRIP_AIM_THK 
                   ,STRIP_MAX_THK 
                   ,STRIP_MIN_THK 
                   ,STRIP_CHG_TGT_THK 
                   ,STRIP_CHG_MAX_THK 
                   ,STRIP_CHG_MIN_THK                     
                   ,STRIP_AIM_WTH
                   ,STRIP_MAX_WTH 
                   ,STRIP_MIN_WTH 
                   ,STRIP_AIM_TEMP
                   ,STRIP_MAX_TEMP 
                   ,STRIP_MIN_TEMP    
                   ,CROWN_AIM_C40
                   ,CROWN_MAX_C40 
                   ,CROWN_MIN_C40 
                   ,FM_SYM_STRIP_FLATNESS_DEV 
                   ,FM_ASY_STRIP_FLATNESS_DEV 
                   ,STRIP_WEDGE_MIN
                   ,STRIP_WEDGE_MAX
                   ,COOLING_MODE
                   ,DUAL_PAHSE
                   ,DUAL_TEMP 
                   ,DUAL_TIME 
                   ,UNCOIL_HEAD_LEN                       
                   ,UNCOIL_TAIL_LEN                       
                   ,UNCOOL_AREA_LEN                       
                   ,COOLING_RATE_TOP                                          
                   ,COOLING_RATE_BOT                                          
                   ,COOL_EXIT_TGT_TEMP                                            
                   ,COOL_EXIT_MAX_TEMP                                            
                   ,COOL_EXIT_MIN_TEMP                                            
                   ,SAMPLE_NO
                   ,INSPECT_YN
                   ,BINDING_AMT_CIRC                                          
                   ,BINDING_AMT_RADI  
                   ,SMP_YS                                            
                   ,SMP_YP    
                   ,ALLOY_COMP_THK_DEV
                   ,DILAT_CURVE
                   ,DIAMOND_FLAG
                   ,STS_FLAG
                   ,ORD_NO
                   ,COIL_LAYER
                   ,HAEA_TAIL_CD  
                   ,PDI_COMM 
                   ,CHEM_CLF
                   ,CHEM_AL
                   ,CHEM_AS
                   ,CHEM_B
                   ,CHEM_BE
                   ,CHEM_BI
                   ,CHEM_C
                   ,CHEM_CA
                   ,CHEM_CE
                   ,CHEM_CO
                   ,CHEM_CR
                   ,CHEM_CU
                   ,CHEM_H      
                   ,CHEM_LA               
                   ,CHEM_MG          
                   ,CHEM_MN
                   ,CHEM_MO          
                   ,CHEM_N
                   ,CHEM_NB
                   ,CHEM_NI
                   ,CHEM_O
                   ,CHEM_P
                   ,CHEM_PB
                   ,CHEM_PD
                   ,CHEM_S
                   ,CHEM_SB
                   ,CHEM_SE
                   ,CHEM_SI
                   ,CHEM_SN
                   ,CHEM_TA
                   ,CHEM_TE
                   ,CHEM_TI
                   ,CHEM_V
                   ,CHEM_W
                   ,CHEM_ZN
                   ,CHEM_ZR
                   ,RESERVE_FIELD1
                   ,RESERVE_FIELD2
                   ,RESERVE_FIELD3
                   ,RESERVE_FIELD4
                   ,RESERVE_FIELD5)		   
            SELECT  C.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                    -- MSG_FLAG
                   ,'833'                                  -- SEND_LEN
                   ,'4001'                                 -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')   -- TRANS_DTIME
                   ,A.SLAB_NO                              -- SLAB_NO                
                   ,A.COIL_NO                              -- COIL_NO
                   ,A.ROLL_MANA_NO                         -- ROLL_MANA_NO           
                   ,SUBSTR(A.SLAB_NO,1,10)                 -- CHARGE_NO   
                   ,A.CAST_NO                              -- CAST_NO
                   ,TO_CHAR(A.ROLL_SLAB_SEQ)               -- ROLL_SLAB_SEQ 
                   ,?                                      -- TRANS_FLAG
                   ,A.SPEC_STL_GRD                         -- STL_GRD
                   ,A.SPEC_ABBSYM                          -- SPEC_ABBSYM
                   ,''                                     -- ROUTE
                   ,A.CCM_PRC_LINE                         -- MC_NO
                   ,TO_CHAR(A.SLAB_LEN)                    -- SLAB_LEN  
                   ,TO_CHAR(A.SLAB_WTH)                    -- SLAB_WTH  
                   ,A.SLAB_TAPER                           -- SLAB_TAPER
                   ,TO_CHAR(A.SLAB_WTH_HEAD)               -- SLAB_WTH_HEAD
                   ,TO_CHAR(A.SLAB_WTH_TAIL)               -- SLAB_WTH_TAIL
                   ,TO_CHAR(A.WTH_CHG_STS)                 -- WTH_CHG_STS
                   ,TO_CHAR(WTH_CHG_END)                   -- WTH_CHG_END   
                   ,TO_CHAR(A.SLAB_THK)                    -- SLAB_THK  
                   ,TO_CHAR(A.SLAB_WGT)                    -- SLAB_WGT  
                   ,DECODE(A.HCR_CLF,'C','0','1')          -- HCR_FL
                   ,B.FERR_MODE                            -- FERR_MODE
                   ,TO_CHAR(B.FERR_CON_STA_TGT_TEMP)       -- FERR_CON_STA_TGT_TEMP  
                   ,TO_CHAR(B.FERR_CON_END_TGT_TEMP)       -- FERR_CON_END_TGT_TEMP  
                   ,TO_CHAR(B.EXTRACT_TGT_TEMP)            -- EXTRACT_TGT_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_TGT_TEMP)           -- RM2_EXIT_TGT_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_MIN_TEMP)           -- RM2_EXIT_MIN_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_MAX_TEMP)           -- RM2_EXIT_MAX_TEMP
                   ,TO_CHAR(B.STRIP_AIM_THK)               -- STRIP_AIM_THK 
                   ,TO_CHAR(B.STRIP_MAX_THK)               -- STRIP_MAX_THK 
                   ,TO_CHAR(B.STRIP_MIN_THK)               -- STRIP_MIN_THK 
                   ,TO_CHAR(B.STRIP_CHG_TGT_THK)           -- STRIP_CHG_TGT_THK 
                   ,TO_CHAR(B.STRIP_CHG_MAX_THK)           -- STRIP_CHG_MAX_THK 
                   ,TO_CHAR(B.STRIP_CHG_MIN_THK)           -- STRIP_CHG_MIN_THK                     
                   ,TO_CHAR(B.STRIP_AIM_WTH)               -- STRIP_AIM_WTH
                   ,TO_CHAR(B.STRIP_MAX_WTH)               -- STRIP_MAX_WTH 
                   ,TO_CHAR(B.STRIP_MIN_WTH)               -- STRIP_MIN_WTH 
                   ,TO_CHAR(B.STRIP_TGT_TEMP)              -- STRIP_AIM_TEMP
                   ,TO_CHAR(B.STRIP_MAX_TEMP)              -- STRIP_MAX_TEMP 
                   ,TO_CHAR(B.STRIP_MIN_TEMP)              -- STRIP_MIN_TEMP    
                   ,B.CROWN_AIM_C40                        -- CROWN_AIM_C40
                   ,B.CROWN_MAX_C40                        -- CROWN_MAX_C40 
                   ,B.CROWN_MIN_C40                        -- CROWN_MIN_C40 
                   ,B.FM_SYM_STRIP_FLATNESS_DEV            -- FM_SYM_STRIP_FLATNESS_DEV 
                   ,B.FM_ASY_STRIP_FLATNESS_DEV            -- FM_ASY_STRIP_FLATNESS_DEV 
                   ,B.STRIP_WEDGE_MIN                      -- STRIP_WEDGE_MIN
                   ,B.STRIP_WEDGE_MAX                      -- STRIP_WEDGE_MAX
                   ,B.COOLING_MODE                         -- COOLING_MODE
                   ,B.DUAL_PAHSE                           -- DUAL_PAHSE
                   ,TO_CHAR(B.DUAL_TEMP)                   -- DUAL_TEMP 
                   ,TO_CHAR(B.DUAL_TIME)                   -- DUAL_TIME 
                   ,TO_CHAR(B.UNCOIL_HEAD_LEN)             -- UNCOIL_HEAD_LEN                       
                   ,TO_CHAR(B.UNCOIL_TAIL_LEN)             -- UNCOIL_TAIL_LEN                       
                   ,TO_CHAR(B.UNCOOL_AREA_LEN)             -- UNCOOL_AREA_LEN                       
                   ,TO_CHAR(B.COOLING_RATE_TOP)            -- COOLING_RATE_TOP                                          
                   ,TO_CHAR(B.COOLING_RATE_BOT)            -- COOLING_RATE_BOT                                          
                   ,TO_CHAR(B.COOL_EXIT_TGT_TEMP)          -- COOL_EXIT_TGT_TEMP                                            
                   ,TO_CHAR(B.COOL_EXIT_MAX_TEMP)          -- COOL_EXIT_MAX_TEMP                                            
                   ,TO_CHAR(B.COOL_EXIT_MIN_TEMP)          -- COOL_EXIT_MIN_TEMP                                            
                   ,B.SAMPLE_NO                            -- SAMPLE_NO
                   ,B.INSPECT_YN                           -- INSPECT_YN
                   ,TO_CHAR(B.BINDING_AMT_CIRC)            -- BINDING_AMT_CIRC                                          
                   ,TO_CHAR(B.BINDING_AMT_RADI)            -- BINDING_AMT_RADI  
                   ,TO_CHAR(B.SMP_YS)                      -- SMP_YS                                            
                   ,TO_CHAR(B.SMP_YP)                      -- SMP_YP    
                   ,B.ALLOY_COMP_THK_DEV                   -- ALLOY_COMP_THK_DEV
                   ,B.DILAT_CURVE                          -- DILAT_CURVE
                   ,B.DIAMOND_FLAG                         -- DIAMOND_FLAG
                   ,B.STS_FLAG                             -- STS_FLAG
                   ,SUBSTR(B.ORD_NO,1,15)                  -- ORD_NO
                   ,B.COIL_LAYER                           -- COIL_LAYER
                   ,B.HAEA_TAIL_CD                         -- HAEA_TAIL_CD  
                   ,B.PDI_COMM                             -- PDI_COMM 
                   ,DECODE(B.CHEM_CLF,'0','2',B.CHEM_CLF)  -- CHEM_KIND
                   ,TO_CHAR(B.CHEM_Al)                     -- CHEM_Al
                   ,TO_CHAR(B.CHEM_As)                     -- CHEM_As
                   ,TO_CHAR(B.CHEM_B)                      -- CHEM_B
                   ,TO_CHAR(B.CHEM_Be)                     -- CHEM_Be
                   ,TO_CHAR(B.CHEM_Bi)                     -- CHEM_Bi
                   ,TO_CHAR(B.CHEM_C)                      -- CHEM_C
                   ,TO_CHAR(B.CHEM_Ca)                     -- CHEM_Ca
                   ,TO_CHAR(B.CHEM_Ce)                     -- CHEM_Ce
                   ,TO_CHAR(B.CHEM_Co)                     -- CHEM_Co
                   ,TO_CHAR(B.CHEM_Cr)                     -- CHEM_Cr
                   ,TO_CHAR(B.CHEM_Cu)                     -- CHEM_Cu
                   ,TO_CHAR(B.CHEM_H)                      -- CHEM_H      
                   ,TO_CHAR(B.CHEM_La)                     -- CHEM_La               
                   ,TO_CHAR(B.CHEM_Mg)                     -- CHEM_Mg          
                   ,TO_CHAR(B.CHEM_Mn)                     -- CHEM_Mn
                   ,TO_CHAR(B.CHEM_Mo)                     -- CHEM_Mo          
                   ,TO_CHAR(B.CHEM_N)                      -- CHEM_N
                   ,TO_CHAR(B.CHEM_Nb)                     -- CHEM_Nb
                   ,TO_CHAR(B.CHEM_Ni)                     -- CHEM_Ni
                   ,TO_CHAR(B.CHEM_O)                      -- CHEM_O
                   ,TO_CHAR(B.CHEM_P)                      -- CHEM_P
                   ,TO_CHAR(B.CHEM_Pb)                     -- CHEM_Pb
                   ,TO_CHAR(B.CHEM_Pd)                     -- CHEM_Pd
                   ,TO_CHAR(B.CHEM_S)                      -- CHEM_S
                   ,TO_CHAR(B.CHEM_Sb)                     -- CHEM_Sb
                   ,TO_CHAR(B.CHEM_Se)                     -- CHEM_Se
                   ,TO_CHAR(B.CHEM_Si)                     -- CHEM_Si
                   ,TO_CHAR(B.CHEM_Sn)                     -- CHEM_Sn
                   ,TO_CHAR(B.CHEM_Ta)                     -- CHEM_Ta
                   ,TO_CHAR(B.CHEM_Te)                     -- CHEM_Te
                   ,TO_CHAR(B.CHEM_Ti)                     -- CHEM_Ti
                   ,TO_CHAR(B.CHEM_V)                      -- CHEM_V
                   ,TO_CHAR(B.CHEM_W)                      -- CHEM_W
                   ,TO_CHAR(B.CHEM_Zn)                     -- CHEM_Zn
                   ,TO_CHAR(B.CHEM_Zr)                     -- CHEM_Zr
                   ,''                                     -- RESERVE_FIELD1
                   ,''                                     -- RESERVE_FIELD2
                   ,''                                     -- RESERVE_FIELD3
                   ,''                                     -- RESERVE_FIELD4
                   ,''                                     -- RESERVE_FIELD5
              FROM  TBF02_SPEC_MILL     A
                   ,TBF02_SPEC_MILL_DET B
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_MILL_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
                   ,(SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO   >   ?
                        AND  FL             =   ? )  D        
             WHERE  A.ROLL_MANA_NO   =   D.CHG_ROLL_MANA_NO
               AND  A.SLAB_EDT_SEQ   =   B.SLAB_EDT_SEQ(+)
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ
       ]]>
   </query> 	
	
   <query id="NIF024080_L2ROLLCOILUpdInsSend.insert" desc="it's query from TBH06_L2_COIL_NO_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO TBH06_L2_COIL_NO_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_LEN
                   ,SET_SEQ
                   ,COIL_NO)		   
            SELECT  B.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                   -- MSG_FLAG
                   ,'4003'                                -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')  -- TRANS_DTIME
                   ,''                                    -- SEND_LEN
                   ,?                                     -- SET_SEQ
                   ,A.SLAB_NO                             -- COIL_NO
              FROM  TBF02_SPEC_MILL  A
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_COIL_NO_INS 
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') B
                   ,(SELECT  CHG_ROLL_MANA_NO
                       FROM  TBF02_CHG_ROLL
                      WHERE  ROLL_MANA_NO   >   ?
                        AND  FL             =   ? )  C        
             WHERE  A.ROLL_MANA_NO   =   C.CHG_ROLL_MANA_NO
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ

       ]]>
   </query>   	
	
   <query id="NIF024080_NewRollManaNoSel.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
            SELECT  A.ROLL_MANA_NO
              FROM  TBF02_SPEC_MILL  A
             WHERE  A.ROLL_MANA_NO    =   ?                              
       ]]>
   </query>
	
   <query id="NIF024080_SpecMillNewUpd.update" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_SPEC_MILL  A
               SET (A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  
		           =  (SELECT  ?
		                      ,C.SLAB_SEQ
                         FROM (SELECT  ROW_NUMBER () OVER (ORDER BY B.ROLL_SLAB_SEQ) SLAB_SEQ
		                              ,B.SLAB_EDT_SEQ
		                         FROM  TBF02_SPEC_MILL  B
                                WHERE  B.ROLL_MANA_NO    =    ?
		                          AND  B.ROLL_SLAB_SEQ   >    ?)  C
		                WHERE  C.SLAB_EDT_SEQ   =   A.SLAB_EDT_SEQ) 
                   ,A.ROLL_EDT_SEQ    =    ?
             WHERE  A.ROLL_MANA_NO    =    ?
               AND  A.ROLL_SLAB_SEQ   >    ?                              
       ]]>
   </query>
	
   <query id="NIF024080_MillIdxNewUpd.update" desc="it's query from TBF02_MILL_IDX Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_MILL_IDX  A
               SET (A.ROLL_MANA_NO, A.ROLL_EDT_SEQ)  
                   =  (SELECT  B.ROLL_MANA_NO
                              ,B.ROLL_EDT_SEQ
                         FROM  TBF02_SPEC_MILL  B
                        WHERE  B.SLAB_EDT_SEQ   =   A.SLAB_EDT_SEQ) 
             WHERE  A.ROLL_MANA_NO    =    ?                              
       ]]>
   </query>
		
   <query id="NIF024080_SpecRollReArrange.update" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_SPEC_ROLL  A
               SET (A.ROLL_SLAB_CNT
		           ,A.ROLL_SLAB_WGT
		           ,HCR_CLF
		           ,MILL_LEN
		           ,SPM_CNT)
                   =  (SELECT  COUNT(B.SLAB_EDT_SEQ)
                              ,SUM(B.SLAB_WGT)
                              ,DECODE(SUM(B.HCR_CLF),0,'C','H')
                              ,SUM(B.MILL_LEN)
                              ,SUM(B.SPM_CNT)
		                 FROM (SELECT  B.SLAB_EDT_SEQ
                                      ,B.SLAB_WGT
		                              ,DECODE(B.HCR_CLF,'H',1,0)       HCR_CLF
		                              ,B.MILL_LEN
		                              ,DECODE(B.SPM_PROC_YN,'Y',1,0)   SPM_CNT 
                                 FROM  TBF02_SPEC_MILL  B
                                WHERE  B.ROLL_MANA_NO   =   ?)  B )
             WHERE  A.ROLL_MANA_NO    =    ?                              
       ]]>
   </query>
	
   <query id="NIF024080_SpecRollNewIns.insert" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBF02_SPEC_ROLL
		           (ROLL_EDT_SEQ
		           ,ROLL_MANA_NO
		           ,ROLL_NO
		           ,ROLL_SLAB_CNT
		           ,ROLL_SLAB_WGT
		           ,HCR_CLF
		           ,MILL_LEN
		           ,SPM_CNT
		           ,STATUS_CD
		           ,FL
		           ,REG_DTIME
		           ,REG_ID)
            SELECT  ?                                     -- ROLL_EDT_SEQ                              
		           ,?                                     -- ROLL_MANA_NO
		           ,''                                    -- ROLL_NO
		           ,COUNT(B.SLAB_EDT_SEQ)                 -- ROLL_SLAB_CNT
                   ,SUM(B.SLAB_WGT)                       -- ROLL_SLAB_WGT
                   ,DECODE(SUM(B.HCR_CLF),0,'C','H')      -- HCR_CLF
                   ,SUM(B.MILL_LEN)                       -- MILL_LEN
                   ,SUM(B.SPM_CNT)                        -- SPM_CNT
		           ,'A'                                   -- STATUS_CD
		           ,''                                    -- FL
		           ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')  -- REG_DTIME
		           ,?                                     -- REG_ID
              FROM (SELECT  B.SLAB_EDT_SEQ
                           ,B.SLAB_WGT
                           ,DECODE(B.HCR_CLF,'H',1,0)       HCR_CLF
                           ,B.MILL_LEN
                           ,DECODE(B.SPM_PROC_YN,'Y',1,0)   SPM_CNT 
                      FROM  TBF02_SPEC_MILL  B
                     WHERE  B.ROLL_MANA_NO   =   ?)  B 
                              
       ]]>
   </query>
	
   <query id="NIF024080_L2ROLLCurNewSend.insert" desc="it's query from TBH06_L2_ROLL_UNIT_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_ROLL_UNIT_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_DC
                   ,RECV_DC
                   ,SERIAL_NO
                   ,RESERVED
                   ,SEND_CLF
                   ,ROLL_UNIT_NO
                   ,UNIT_SLAB_CNT)		   
            SELECT  B.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO)  -- SEQ_NO
                   ,'N'                                     -- MSG_FLAG
                   ,'34'                                    -- SEND_LEN
                   ,'HMFU10'                                -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')    -- TRANS_DTIME
                   ,'FU'                                    -- SEND_DC
                   ,'HM'                                    -- RECV_DC
                   ,''                                      -- SERIAL_NO
                   ,''                                      -- RESERVED
                   ,?                                       -- SEND_CLF ('1': INSERT, '2': UPDATE  '3' : DELETE)
                   ,A.ROLL_MANA_NO                          -- ROLL_UNIT_NO 
                   ,A.ROLL_SLAB_CNT                         -- UNIT_SLAB_CNT
              FROM  TBF02_SPEC_ROLL  A
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_ROLL_UNIT_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') B
             WHERE  A.ROLL_MANA_NO   =   ?
		     ORDER  BY  A.ROLL_MANA_NO
       ]]>
   </query>  	
	
   <query id="NIF024080_L2RHTUpdSend.insert" desc="it's query from TBH06_L2_RHT_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_RHT_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_DC
                   ,RECV_DC
                   ,SERIAL_NO
                   ,RESERVED
                   ,SEND_CLF
                   ,SLAB_NO                
                   ,COIL_NO
                   ,ROLL_UNIT_NO           
                   ,ROLL_UNIT_SEQ          
                   ,SLAB_THK               
                   ,SLAB_WTH               
                   ,SLAB_LEN               
                   ,SLAB_WGT
                   ,STL_GRD
                   ,SPEC_ABBSYM
                   ,EXTRACT_TGT_TEMP       
                   ,EXTRACT_MAX_TEMP       
                   ,EXTRACT_MIN_TEMP       
                   ,CHARGING_TGT_TEMP      
                   ,CHARGING_MAX_TEMP      
                   ,HCR_FL                 
                   ,INFUR_MIN_HOUR         
                   ,INFUR_MAX_HOUR         
                   ,EQ_HT_MIN_HOUR         
                   ,EQ_HT_MAX_HOUR         
                   ,CHARGE_NO              
                   ,CAST_NO
                   ,CHEM_KIND
                   ,CHEM_AL
                   ,CHEM_AS
                   ,CHEM_B
                   ,CHEM_BE
                   ,CHEM_Bi
                   ,CHEM_C
                   ,CHEM_CA
                   ,CHEM_CE
                   ,CHEM_CO
                   ,CHEM_CR
                   ,CHEM_CU
                   ,CHEM_H      
                   ,CHEM_LA               
                   ,CHEM_MG          
                   ,CHEM_MN
                   ,CHEM_MO          
                   ,CHEM_N
                   ,CHEM_NB
                   ,CHEM_NI
                   ,CHEM_O
                   ,CHEM_P
                   ,CHEM_S
                   ,CHEM_SB
                   ,CHEM_SE
                   ,CHEM_SI
                   ,CHEM_TI
                   ,CHEM_SN
                   ,CHEM_TA
                   ,CHEM_TE
                   ,CHEM_PB
                   ,CHEM_PD
                   ,CHEM_V
                   ,CHEM_W
                   ,CHEM_ZN
                   ,CHEM_ZR)		   
            SELECT  C.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                    -- MSG_FLAG
                   ,'520'                                  -- SEND_LEN
                   ,'HMFU20'                               -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')   -- TRANS_DTIME
                   ,'FU'                                   -- SEND_DC
                   ,'HM'                                   -- RECV_DC
                   ,''                                     -- SERIAL_NO
                   ,''                                     -- RESERVED
                   ,'2'                                    -- SEND_CLF
                   ,A.SLAB_NO                              -- SLAB_NO                
                   ,A.COIL_NO                              -- COIL_NO
                   ,A.ROLL_MANA_NO                         -- ROLL_UNIT_NO           
                   ,TO_CHAR(A.ROLL_SLAB_SEQ)               -- ROLL_UNIT_SEQ          
                   ,TO_CHAR(A.SLAB_THK)                    -- SLAB_THK               
                   ,TO_CHAR(A.SLAB_WTH)                    -- SLAB_WTH               
                   ,TO_CHAR(A.SLAB_LEN)                    -- SLAB_LEN               
                   ,TO_CHAR(A.SLAB_WGT)                    -- SLAB_WGT
                   ,A.SPEC_STL_GRD                         -- STL_GRD
                   ,A.SPEC_ABBSYM                          -- SPEC_ABBSYM
                   ,A.CHG_TMP_TGT                          -- EXTRACT_TGT_TEMP       
                   ,A.CHG_TMP_MAX                          -- EXTRACT_MAX_TEMP       
                   ,A.CHG_TMP_MIN                          -- EXTRACT_MIN_TEMP       
                   ,A.CRACK_TGT                            -- CHARGING_TGT_TEMP      
                   ,A.CRACK_MAX                            -- CHARGING_MAX_TEMP      
                   ,DECODE(A.HCR_CLF,'C','0','1')          -- HCR_FL                 
                   ,A.FUR_TME_MIN                          -- INFUR_MIN_HOUR         
                   ,A.FUR_TME_MAX                          -- INFUR_MAX_HOUR         
                   ,A.CRACK_TME_MIN                        -- EQ_HT_MIN_HOUR         
                   ,A.CRACK_TME_MAX                        -- EQ_HT_MAX_HOUR         
                   ,SUBSTR(A.SLAB_NO,1,10)                 -- CHARGE_NO              
                   ,A.CAST_NO                              -- CAST_NO
                   ,B.CHEM_CLF                             -- CHEM_KIND
                   ,TO_CHAR(B.CHEM_Al)                     -- CHEM_Al
                   ,TO_CHAR(B.CHEM_As)                     -- CHEM_As
                   ,TO_CHAR(B.CHEM_B)                      -- CHEM_B
                   ,TO_CHAR(B.CHEM_Be)                     -- CHEM_Be
                   ,TO_CHAR(B.CHEM_Bi)                     -- CHEM_Bi
                   ,TO_CHAR(B.CHEM_C)                      -- CHEM_C
                   ,TO_CHAR(B.CHEM_Ca)                     -- CHEM_Ca
                   ,TO_CHAR(B.CHEM_Ce)                     -- CHEM_Ce
                   ,TO_CHAR(B.CHEM_Co)                     -- CHEM_Co
                   ,TO_CHAR(B.CHEM_Cr)                     -- CHEM_Cr
                   ,TO_CHAR(B.CHEM_Cu)                     -- CHEM_Cu
                   ,TO_CHAR(B.CHEM_H)                      -- CHEM_H      
                   ,TO_CHAR(B.CHEM_La)                     -- CHEM_La               
                   ,TO_CHAR(B.CHEM_Mg)                     -- CHEM_Mg          
                   ,TO_CHAR(B.CHEM_Mn)                     -- CHEM_Mn
                   ,TO_CHAR(B.CHEM_Mo)                     -- CHEM_Mo          
                   ,TO_CHAR(B.CHEM_N)                      -- CHEM_N
                   ,TO_CHAR(B.CHEM_Nb)                     -- CHEM_Nb
                   ,TO_CHAR(B.CHEM_Ni)                     -- CHEM_Ni
                   ,TO_CHAR(B.CHEM_O)                      -- CHEM_O
                   ,TO_CHAR(B.CHEM_P)                      -- CHEM_P
                   ,TO_CHAR(B.CHEM_S)                      -- CHEM_S
                   ,TO_CHAR(B.CHEM_Sb)                     -- CHEM_Sb
                   ,TO_CHAR(B.CHEM_Se)                     -- CHEM_Se
                   ,TO_CHAR(B.CHEM_Si)                     -- CHEM_Si
                   ,TO_CHAR(B.CHEM_Ti)                     -- CHEM_Ti
                   ,TO_CHAR(B.CHEM_Sn)                     -- CHEM_Sn
                   ,TO_CHAR(B.CHEM_Ta)                     -- CHEM_Ta
                   ,TO_CHAR(B.CHEM_Te)                     -- CHEM_Te
                   ,TO_CHAR(B.CHEM_Pb)                     -- CHEM_Pb
                   ,TO_CHAR(B.CHEM_Pd)                     -- CHEM_Pd
                   ,TO_CHAR(B.CHEM_V)                      -- CHEM_V
                   ,TO_CHAR(B.CHEM_W)                      -- CHEM_W
                   ,TO_CHAR(B.CHEM_Zn)                     -- CHEM_Zn
                   ,TO_CHAR(B.CHEM_Zr)                     -- CHEM_Zr
              FROM  TBF02_SPEC_MILL     A
                   ,TBF02_SPEC_MILL_DET B
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_RHT_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
             WHERE  A.ROLL_MANA_NO   =   ?
               AND  A.SLAB_EDT_SEQ   =   B.SLAB_EDT_SEQ(+)
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ
       ]]>
   </query> 	
	
   <query id="NIF024080_L2MILLUpdSend.insert" desc="it's query from TBH06_L2_MILL_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO  TBH06_L2_MILL_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,SEND_LEN
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SLAB_NO                
                   ,COIL_NO
                   ,ROLL_MANA_NO           
                   ,CHARGE_NO   
                   ,CAST_NO
                   ,ROLL_SLAB_SEQ 
                   ,TRANS_FLAG
                   ,STL_GRD
                   ,SPEC_ABBSYM
                   ,ROUTE
                   ,MC_NO
                   ,SLAB_LEN  
                   ,SLAB_WTH  
                   ,SLAB_TAPER
                   ,SLAB_WTH_HEAD
                   ,SLAB_WTH_TAIL
                   ,WTH_CHG_STS
                   ,WTH_CHG_END   
                   ,SLAB_THK  
                   ,SLAB_WGT  
                   ,HCR_CLF
                   ,FERR_MODE
                   ,FERR_CON_STA_TGT_TEMP  
                   ,FERR_CON_END_TGT_TEMP  
                   ,EXTRACT_TGT_TEMP 
                   ,RM2_EXIT_TGT_TEMP 
                   ,RM2_EXIT_MIN_TEMP 
                   ,RM2_EXIT_MAX_TEMP
                   ,STRIP_AIM_THK 
                   ,STRIP_MAX_THK 
                   ,STRIP_MIN_THK 
                   ,STRIP_CHG_TGT_THK 
                   ,STRIP_CHG_MAX_THK 
                   ,STRIP_CHG_MIN_THK                     
                   ,STRIP_AIM_WTH
                   ,STRIP_MAX_WTH 
                   ,STRIP_MIN_WTH 
                   ,STRIP_AIM_TEMP
                   ,STRIP_MAX_TEMP 
                   ,STRIP_MIN_TEMP    
                   ,CROWN_AIM_C40
                   ,CROWN_MAX_C40 
                   ,CROWN_MIN_C40 
                   ,FM_SYM_STRIP_FLATNESS_DEV 
                   ,FM_ASY_STRIP_FLATNESS_DEV 
                   ,STRIP_WEDGE_MIN
                   ,STRIP_WEDGE_MAX
                   ,COOLING_MODE
                   ,DUAL_PAHSE
                   ,DUAL_TEMP 
                   ,DUAL_TIME 
                   ,UNCOIL_HEAD_LEN                       
                   ,UNCOIL_TAIL_LEN                       
                   ,UNCOOL_AREA_LEN                       
                   ,COOLING_RATE_TOP                                          
                   ,COOLING_RATE_BOT                                          
                   ,COOL_EXIT_TGT_TEMP                                            
                   ,COOL_EXIT_MAX_TEMP                                            
                   ,COOL_EXIT_MIN_TEMP                                            
                   ,SAMPLE_NO
                   ,INSPECT_YN
                   ,BINDING_AMT_CIRC                                          
                   ,BINDING_AMT_RADI  
                   ,SMP_YS                                            
                   ,SMP_YP    
                   ,ALLOY_COMP_THK_DEV
                   ,DILAT_CURVE
                   ,DIAMOND_FLAG
                   ,STS_FLAG
                   ,ORD_NO
                   ,COIL_LAYER
                   ,HAEA_TAIL_CD  
                   ,PDI_COMM 
                   ,CHEM_CLF
                   ,CHEM_AL
                   ,CHEM_AS
                   ,CHEM_B
                   ,CHEM_BE
                   ,CHEM_BI
                   ,CHEM_C
                   ,CHEM_CA
                   ,CHEM_CE
                   ,CHEM_CO
                   ,CHEM_CR
                   ,CHEM_CU
                   ,CHEM_H      
                   ,CHEM_LA               
                   ,CHEM_MG          
                   ,CHEM_MN
                   ,CHEM_MO          
                   ,CHEM_N
                   ,CHEM_NB
                   ,CHEM_NI
                   ,CHEM_O
                   ,CHEM_P
                   ,CHEM_PB
                   ,CHEM_PD
                   ,CHEM_S
                   ,CHEM_SB
                   ,CHEM_SE
                   ,CHEM_SI
                   ,CHEM_SN
                   ,CHEM_TA
                   ,CHEM_TE
                   ,CHEM_TI
                   ,CHEM_V
                   ,CHEM_W
                   ,CHEM_ZN
                   ,CHEM_ZR
                   ,RESERVE_FIELD1
                   ,RESERVE_FIELD2
                   ,RESERVE_FIELD3
                   ,RESERVE_FIELD4
                   ,RESERVE_FIELD5)		   
            SELECT  C.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO, A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                    -- MSG_FLAG
                   ,'833'                                  -- SEND_LEN
                   ,'4001'                                 -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')   -- TRANS_DTIME
                   ,A.SLAB_NO                              -- SLAB_NO                
                   ,A.COIL_NO                              -- COIL_NO
                   ,A.ROLL_MANA_NO                         -- ROLL_MANA_NO           
                   ,SUBSTR(A.SLAB_NO,1,10)                 -- CHARGE_NO   
                   ,A.CAST_NO                              -- CAST_NO
                   ,TO_CHAR(A.ROLL_SLAB_SEQ)               -- ROLL_SLAB_SEQ 
                   ,'2'                                    -- TRANS_FLAG
                   ,A.SPEC_STL_GRD                         -- STL_GRD
                   ,A.SPEC_ABBSYM                          -- SPEC_ABBSYM
                   ,''                                     -- ROUTE
                   ,A.CCM_PRC_LINE                         -- MC_NO
                   ,TO_CHAR(A.SLAB_LEN)                    -- SLAB_LEN  
                   ,TO_CHAR(A.SLAB_WTH)                    -- SLAB_WTH  
                   ,A.SLAB_TAPER                           -- SLAB_TAPER
                   ,TO_CHAR(A.SLAB_WTH_HEAD)               -- SLAB_WTH_HEAD
                   ,TO_CHAR(A.SLAB_WTH_TAIL)               -- SLAB_WTH_TAIL
                   ,TO_CHAR(A.WTH_CHG_STS)                 -- WTH_CHG_STS
                   ,TO_CHAR(WTH_CHG_END)                   -- WTH_CHG_END   
                   ,TO_CHAR(A.SLAB_THK)                    -- SLAB_THK  
                   ,TO_CHAR(A.SLAB_WGT)                    -- SLAB_WGT  
                   ,DECODE(A.HCR_CLF,'C','0','1')          -- HCR_FL
                   ,B.FERR_MODE                            -- FERR_MODE
                   ,TO_CHAR(B.FERR_CON_STA_TGT_TEMP)       -- FERR_CON_STA_TGT_TEMP  
                   ,TO_CHAR(B.FERR_CON_END_TGT_TEMP)       -- FERR_CON_END_TGT_TEMP  
                   ,TO_CHAR(B.EXTRACT_TGT_TEMP)            -- EXTRACT_TGT_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_TGT_TEMP)           -- RM2_EXIT_TGT_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_MIN_TEMP)           -- RM2_EXIT_MIN_TEMP 
                   ,TO_CHAR(B.RM2_EXIT_MAX_TEMP)           -- RM2_EXIT_MAX_TEMP
                   ,TO_CHAR(B.STRIP_AIM_THK)               -- STRIP_AIM_THK 
                   ,TO_CHAR(B.STRIP_MAX_THK)               -- STRIP_MAX_THK 
                   ,TO_CHAR(B.STRIP_MIN_THK)               -- STRIP_MIN_THK 
                   ,TO_CHAR(B.STRIP_CHG_TGT_THK)           -- STRIP_CHG_TGT_THK 
                   ,TO_CHAR(B.STRIP_CHG_MAX_THK)           -- STRIP_CHG_MAX_THK 
                   ,TO_CHAR(B.STRIP_CHG_MIN_THK)           -- STRIP_CHG_MIN_THK                     
                   ,TO_CHAR(B.STRIP_AIM_WTH)               -- STRIP_AIM_WTH
                   ,TO_CHAR(B.STRIP_MAX_WTH)               -- STRIP_MAX_WTH 
                   ,TO_CHAR(B.STRIP_MIN_WTH)               -- STRIP_MIN_WTH 
                   ,TO_CHAR(B.STRIP_TGT_TEMP)              -- STRIP_AIM_TEMP
                   ,TO_CHAR(B.STRIP_MAX_TEMP)              -- STRIP_MAX_TEMP 
                   ,TO_CHAR(B.STRIP_MIN_TEMP)              -- STRIP_MIN_TEMP    
                   ,B.CROWN_AIM_C40                        -- CROWN_AIM_C40
                   ,B.CROWN_MAX_C40                        -- CROWN_MAX_C40 
                   ,B.CROWN_MIN_C40                        -- CROWN_MIN_C40 
                   ,B.FM_SYM_STRIP_FLATNESS_DEV            -- FM_SYM_STRIP_FLATNESS_DEV 
                   ,B.FM_ASY_STRIP_FLATNESS_DEV            -- FM_ASY_STRIP_FLATNESS_DEV 
                   ,B.STRIP_WEDGE_MIN                      -- STRIP_WEDGE_MIN
                   ,B.STRIP_WEDGE_MAX                      -- STRIP_WEDGE_MAX
                   ,B.COOLING_MODE                         -- COOLING_MODE
                   ,B.DUAL_PAHSE                           -- DUAL_PAHSE
                   ,TO_CHAR(B.DUAL_TEMP)                   -- DUAL_TEMP 
                   ,TO_CHAR(B.DUAL_TIME)                   -- DUAL_TIME 
                   ,TO_CHAR(B.UNCOIL_HEAD_LEN)             -- UNCOIL_HEAD_LEN                       
                   ,TO_CHAR(B.UNCOIL_TAIL_LEN)             -- UNCOIL_TAIL_LEN                       
                   ,TO_CHAR(B.UNCOOL_AREA_LEN)             -- UNCOOL_AREA_LEN                       
                   ,TO_CHAR(B.COOLING_RATE_TOP)            -- COOLING_RATE_TOP                                          
                   ,TO_CHAR(B.COOLING_RATE_BOT)            -- COOLING_RATE_BOT                                          
                   ,TO_CHAR(B.COOL_EXIT_TGT_TEMP)          -- COOL_EXIT_TGT_TEMP                                            
                   ,TO_CHAR(B.COOL_EXIT_MAX_TEMP)          -- COOL_EXIT_MAX_TEMP                                            
                   ,TO_CHAR(B.COOL_EXIT_MIN_TEMP)          -- COOL_EXIT_MIN_TEMP                                            
                   ,B.SAMPLE_NO                            -- SAMPLE_NO
                   ,B.INSPECT_YN                           -- INSPECT_YN
                   ,TO_CHAR(B.BINDING_AMT_CIRC)            -- BINDING_AMT_CIRC                                          
                   ,TO_CHAR(B.BINDING_AMT_RADI)            -- BINDING_AMT_RADI  
                   ,TO_CHAR(B.SMP_YS)                      -- SMP_YS                                            
                   ,TO_CHAR(B.SMP_YP)                      -- SMP_YP    
                   ,B.ALLOY_COMP_THK_DEV                   -- ALLOY_COMP_THK_DEV
                   ,B.DILAT_CURVE                          -- DILAT_CURVE
                   ,B.DIAMOND_FLAG                         -- DIAMOND_FLAG
                   ,B.STS_FLAG                             -- STS_FLAG
                   ,SUBSTR(B.ORD_NO,1,15) ORD_NO                               -- ORD_NO
                   ,B.COIL_LAYER                           -- COIL_LAYER
                   ,B.HAEA_TAIL_CD                         -- HAEA_TAIL_CD  
                   ,B.PDI_COMM                             -- PDI_COMM 
                   ,DECODE(B.CHEM_CLF,'0','2',B.CHEM_CLF)  -- CHEM_KIND
                   ,TO_CHAR(B.CHEM_Al)                     -- CHEM_Al
                   ,TO_CHAR(B.CHEM_As)                     -- CHEM_As
                   ,TO_CHAR(B.CHEM_B)                      -- CHEM_B
                   ,TO_CHAR(B.CHEM_Be)                     -- CHEM_Be
                   ,TO_CHAR(B.CHEM_Bi)                     -- CHEM_Bi
                   ,TO_CHAR(B.CHEM_C)                      -- CHEM_C
                   ,TO_CHAR(B.CHEM_Ca)                     -- CHEM_Ca
                   ,TO_CHAR(B.CHEM_Ce)                     -- CHEM_Ce
                   ,TO_CHAR(B.CHEM_Co)                     -- CHEM_Co
                   ,TO_CHAR(B.CHEM_Cr)                     -- CHEM_Cr
                   ,TO_CHAR(B.CHEM_Cu)                     -- CHEM_Cu
                   ,TO_CHAR(B.CHEM_H)                      -- CHEM_H      
                   ,TO_CHAR(B.CHEM_La)                     -- CHEM_La               
                   ,TO_CHAR(B.CHEM_Mg)                     -- CHEM_Mg          
                   ,TO_CHAR(B.CHEM_Mn)                     -- CHEM_Mn
                   ,TO_CHAR(B.CHEM_Mo)                     -- CHEM_Mo          
                   ,TO_CHAR(B.CHEM_N)                      -- CHEM_N
                   ,TO_CHAR(B.CHEM_Nb)                     -- CHEM_Nb
                   ,TO_CHAR(B.CHEM_Ni)                     -- CHEM_Ni
                   ,TO_CHAR(B.CHEM_O)                      -- CHEM_O
                   ,TO_CHAR(B.CHEM_P)                      -- CHEM_P
                   ,TO_CHAR(B.CHEM_Pb)                     -- CHEM_Pb
                   ,TO_CHAR(B.CHEM_Pd)                     -- CHEM_Pd
                   ,TO_CHAR(B.CHEM_S)                      -- CHEM_S
                   ,TO_CHAR(B.CHEM_Sb)                     -- CHEM_Sb
                   ,TO_CHAR(B.CHEM_Se)                     -- CHEM_Se
                   ,TO_CHAR(B.CHEM_Si)                     -- CHEM_Si
                   ,TO_CHAR(B.CHEM_Sn)                     -- CHEM_Sn
                   ,TO_CHAR(B.CHEM_Ta)                     -- CHEM_Ta
                   ,TO_CHAR(B.CHEM_Te)                     -- CHEM_Te
                   ,TO_CHAR(B.CHEM_Ti)                     -- CHEM_Ti
                   ,TO_CHAR(B.CHEM_V)                      -- CHEM_V
                   ,TO_CHAR(B.CHEM_W)                      -- CHEM_W
                   ,TO_CHAR(B.CHEM_Zn)                     -- CHEM_Zn
                   ,TO_CHAR(B.CHEM_Zr)                     -- CHEM_Zr
                   ,''                                     -- RESERVE_FIELD1
                   ,''                                     -- RESERVE_FIELD2
                   ,''                                     -- RESERVE_FIELD3
                   ,''                                     -- RESERVE_FIELD4
                   ,''                                     -- RESERVE_FIELD5
              FROM  TBF02_SPEC_MILL     A
                   ,TBF02_SPEC_MILL_DET B
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_MILL_INS
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
             WHERE  A.ROLL_MANA_NO   =   ?
               AND  A.SLAB_EDT_SEQ   =   B.SLAB_EDT_SEQ(+)
		     ORDER  BY  A.ROLL_MANA_NO
                       ,A.ROLL_SLAB_SEQ
       ]]>
   </query> 	
	
   <query id="NIF024080_L2ROLLCOILUpdSend.insert" desc="it's query from TBH06_L2_COIL_NO_INS Table" fetchSize="10">
       <![CDATA[
            INSERT  INTO TBH06_L2_COIL_NO_INS
                   (SEQ_NO
                   ,MSG_FLAG
                   ,TC_ID
                   ,TRANS_DTIME
                   ,SEND_LEN
                   ,SET_SEQ
                   ,COIL_NO)		   
            SELECT  B.SEQ_NO + 
		            ROW_NUMBER() OVER (ORDER BY A.ROLL_SLAB_SEQ)  -- SEQ_NO
                   ,'N'                                   -- MSG_FLAG
                   ,'4003'                                -- TC_ID
                   ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')  -- TRANS_DTIME
                   ,''                                    -- SEND_LEN
                   ,?                                     -- SET_SEQ
                   ,A.SLAB_NO                             -- COIL_NO
              FROM  TBF02_SPEC_MILL  A
                   ,(SELECT  NVL(MAX(SEQ_NO),0) SEQ_NO
                       FROM  TBH06_L2_COIL_NO_INS 
                      WHERE  TRANS_DTIME like TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') B
             WHERE  A.ROLL_MANA_NO   =   ?
		     ORDER  BY  A.ROLL_SLAB_SEQ

       ]]>
   </query>     
	
   <query id="NIF024080_SpecRollFLInt.update" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_SPEC_ROLL  A
               SET  A.FL    =    ''
            where a.FL is not null   
       ]]>
   </query>
	
   <query id="NIF024080_SpecMillFLInt.update" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_SPEC_MILL  A
               SET  A.FL    =    ''
            where a.FL is not null   
       ]]>
   </query>
	
   <query id="NIF024080_MillIdxFLInt.update" desc="it's query from TBF02_MILL_IDX Table" fetchSize="10">
       <![CDATA[
            UPDATE  TBF02_MILL_IDX  A
               SET  A.FL    =    ''
            where a.FL is not null   
       ]]>
   </query>
	
</queryMap>