| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="MILL WORK INSTRUCTION LEVEL2 SEND">
- <query id="NIF024050_RollSlabSeq.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
-
- -- ADD STATUS_CD IN ('A','B')) A 因为回出现扎回编制到计划的情况 会导致多条数据
- SELECT A.ROLL_MANA_NO ROLL_MANA_ST, A.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_ST
- ,B.ROLL_MANA_NO ROLL_MANA_EN, B.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_EN
- FROM (SELECT ROLL_MANA_NO, ROLL_SLAB_SEQ
- FROM TBF02_SPEC_MILL
- WHERE SLAB_NO = ?
- AND STATUS_CD IN ('A','B')) A
- ,(SELECT ROLL_MANA_NO, ROLL_SLAB_SEQ
- FROM TBF02_SPEC_MILL
- WHERE SLAB_NO = ?
- AND STATUS_CD IN ('A','B')) B
- ]]>
- </query>
-
- <query id="NIF024050_RollSlab.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT A.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_ST
- ,B.ROLL_SLAB_SEQ ROLL_SLAB_SEQ_EN
- FROM (SELECT MIN(ROLL_SLAB_SEQ) ROLL_SLAB_SEQ FROM TBF02_SPEC_MILL WHERE ROLL_MANA_NO = ?) A
- ,(SELECT MAX(ROLL_SLAB_SEQ) ROLL_SLAB_SEQ FROM TBF02_SPEC_MILL WHERE ROLL_MANA_NO = ?) B
-
- ]]>
- </query>
-
- <query id="NIF024050_L2ROLLSend.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
- ,'1' -- SEND_CLF
- ,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 BETWEEN ? AND ?
- ORDER BY A.ROLL_MANA_NO
- ]]>
- </query>
-
- <query id="NIF024050_L2RHTSend.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
- ,'1' -- 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
- WHERE A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
- AND A.ROLL_MANA_NO BETWEEN ? AND ?
- ORDER BY A.ROLL_MANA_NO
- ,A.ROLL_SLAB_SEQ
- ]]>
- </query>
-
- <query id="NIF024050_L2MILLSend.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
- ,'1' -- 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(get_tbf02_coilthkmax(a.SPEC_STL_GRD, a.ORD_THK,a.HOT_THK_MAX)) +
- TO_CHAR(get_tbf02_coilthkmin(a.SPEC_STL_GRD, a.ORD_THK,a.HOT_THK_MIN))) / 2
- ,TO_CHAR(get_tbf02_coilthkmax(a.SPEC_STL_GRD, a.ORD_THK,a.HOT_THK_MAX)) -- STRIP_MAX_THK
- ,TO_CHAR(get_tbf02_coilthkmin(a.SPEC_STL_GRD, a.ORD_THK,a.HOT_THK_MIN)) -- 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
- ,'' --get_tbf02_coilthkmin(A.SPEC_STL_GRD,A.ORD_THK) -- RESERVE_FIELD4
- ,'' --get_tbf02_coilthkmax(A.SPEC_STL_GRD,A.ORD_THK) -- 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.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
- AND A.ROLL_MANA_NO BETWEEN ? AND ?
- ]]>
- </query>
-
- <query id="NIF024050_RollManaNo.select" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
- <![CDATA[
- SELECT ROLL_MANA_NO
- FROM TBF02_SPEC_ROLL
- WHERE ROLL_MANA_NO BETWEEN ? AND ?
- ORDER BY ROLL_MANA_NO
- ]]>
- </query>
-
- <query id="NIF024050_L2ROLLCOILSend.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 = ?
- ]]>
- </query>
- <query id="NIF024050_MillIdx.update" desc="it's query from TBF02_MILL_IDX Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_MILL_IDX
- SET L2_SEND = 'Y'
- WHERE ROLL_MANA_NO BETWEEN ? AND ?
- ]]>
- </query>
-
- <query id="NIF024050_AftRollManaNoChk.select" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
- <![CDATA[
- SELECT COUNT(ROLL_MANA_NO) ROLL_CNT
- FROM TBF02_SPEC_ROLL
- WHERE ROLL_MANA_NO > ?
- ]]>
- </query>
-
- <query id="NIF024050_L2ROLLReSend.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
- ,'2' -- SEND_CLF
- ,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="NIF024050_L2RHTReSend.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
- ,'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
- ,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
- WHERE A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
- AND A.ROLL_MANA_NO > ?
- ORDER BY A.ROLL_MANA_NO
- ,A.ROLL_SLAB_SEQ
- ]]>
- </query>
-
- <query id="NIF024050_L2MILLReSend.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 - B.STRIP_AIM_WTH) -- STRIP_MAX_WTH
- ,TO_CHAR(B.STRIP_AIM_WTH - 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
- WHERE A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
- AND A.ROLL_MANA_NO > ?
- ORDER BY A.ROLL_MANA_NO
- ,A.ROLL_SLAB_SEQ
- ]]>
- </query>
-
- <query id="NIF024050_ReRollManaNo.select" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
- <![CDATA[
- SELECT ROLL_MANA_NO
- FROM TBF02_SPEC_ROLL
- WHERE ROLL_MANA_NO > ?
- ORDER BY ROLL_MANA_NO
- ]]>
- </query>
-
- <query id="NIF024050_L2ROLLCOILReSend.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 = ?
- ]]>
- </query>
-
- </queryMap>
|
