| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="MILL WORK INSTRUCTION CHANGING ROLL SEQUENCE">
- <query id="NIF024030_MILLStatusChk.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT SUM(DECODE(A.HCR_CLF,'H',1,0)) HCR_CNT
- ,SUM(DECODE(A.STATUS_CD,'B',1,0)) STATUS_CNT
- ,SUM(DECODE(B.COIL_STAT,'0',1,0)) COIL_STAT_CNT --add
- ,SUM(DECODE(C.SLAB_STAT,'1',1,0)) SLAB_STAT_CNT --add
- FROM TBF02_SPEC_MILL A
- ,TBH02_COIL_COMM B
- ,TBG02_SLAB_COMM C
- WHERE ROLL_MANA_NO BETWEEN ? AND ?
- AND A.COIL_NO = B.COIL_NO(+)
- AND A.SLAB_NO = C.SLAB_NO(+)
- ]]>
- </query>
-
- <query id="NIF024030_MILLStatusChkPosA.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT SUM(DECODE(A.HCR_CLF,'H',1,0)) HCR_CNT
- ,SUM(DECODE(A.STATUS_CD,'B',1,0)) STATUS_CNT
- ,SUM(DECODE(B.COIL_STAT,'0',1,0)) COIL_STAT_CNT --add
- ,SUM(DECODE(C.SLAB_STAT,'1',1,0)) SLAB_STAT_CNT --add
- FROM TBF02_SPEC_MILL A
- ,TBH02_COIL_COMM B
- ,TBG02_SLAB_COMM C
- WHERE ROLL_MANA_NO > ?
- AND ROLL_MANA_NO <= ?
- AND A.COIL_NO = B.COIL_NO(+)
- AND A.SLAB_NO = C.SLAB_NO(+)
- ]]>
- </query>
-
-
-
-
- <query id="NIF024030_SlabNoFind.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- --查找所有的移动板坯
- SELECT A.SLAB_NO_ST
- ,B.SLAB_NO_EN
- FROM (SELECT SLAB_NO SLAB_NO_ST
- FROM TBF02_SPEC_MILL
- WHERE ROLL_MANA_NO = ?
- AND ROLL_SLAB_SEQ = (SELECT MIN(ROLL_SLAB_SEQ)
- FROM TBF02_SPEC_MILL
- WHERE ROLL_MANA_NO = ?)) A,
- (SELECT SLAB_NO SLAB_NO_EN
- FROM TBF02_SPEC_MILL
- WHERE ROLL_MANA_NO = ?
- AND ROLL_SLAB_SEQ = (SELECT MAX(ROLL_SLAB_SEQ)
- FROM TBF02_SPEC_MILL
- WHERE ROLL_MANA_NO = ?)) B
- ]]>
- </query>
-
- <query id="NIF024030_RollManaNoAft.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT MIN(ROLL_MANA_NO) ROLL_MANA_NO
- FROM TBF02_SPEC_MILL
- WHERE ROLL_MANA_NO > ?
- ]]>
- </query>
- <query id="NIF024030_RollManaNoBef.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT MAX(ROLL_MANA_NO) ROLL_MANA_NO
- FROM TBF02_SPEC_MILL
- WHERE ROLL_MANA_NO < ?
- ]]>
- </query>
-
- <query id="NIF024030_LastRollManaNo.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT MAX(ROLL_MANA_NO) ROLL_MANA_NO
- FROM TBF02_SPEC_MILL
- ]]>
- </query>
-
- <query id="NIF024030_TempRoll.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 ROWNUM --ORG_SEQ
- ,CHG_SEQ
- ,ROLL_EDT_SEQ
- ,ROLL_MANA_NO
- ,CHG_ROLL_MANA_NO
- ,FL
- FROM (SELECT 0 CHG_SEQ
- ,ROLL_EDT_SEQ ROLL_EDT_SEQ
- ,ROLL_MANA_NO ROLL_MANA_NO
- ,'' CHG_ROLL_MANA_NO
- ,'' FL
- FROM TBF02_SPEC_ROLL
- ORDER BY ROLL_MANA_NO)*/
-
- INSERT INTO TBF02_CHG_ROLL
- (ORG_SEQ
- ,CHG_SEQ
- ,ROLL_EDT_SEQ
- ,ROLL_MANA_NO
- ,CHG_ROLL_MANA_NO
- ,FL)
-
- SELECT ROWNUM --ORG_SEQ
- ,
- CHG_SEQ,
- ROLL_EDT_SEQ,
- ROLL_MANA_NO,
- CHG_ROLL_MANA_NO,
- FL
- FROM (select *
- from (SELECT 0 CHG_SEQ,
- ROLL_EDT_SEQ ROLL_EDT_SEQ,
- ROLL_MANA_NO ROLL_MANA_NO,
- '' CHG_ROLL_MANA_NO,
- '' FL
- FROM TBF02_SPEC_ROLL
- where ROLL_MANA_NO is not null
- ORDER BY ROLL_MANA_NO desc)
- where rownum < 20
- order by ROLL_MANA_NO)
- ]]>
- </query>
-
- <query id="NIF024030_RollEdtSeqFind.select" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
- <![CDATA[
- SELECT A.ORG_SEQ SEQ_ST
- ,B.ORG_SEQ SEQ_EN
- ,C.ORG_SEQ SEQ_TG
- FROM (SELECT ORG_SEQ FROM TBF02_CHG_ROLL WHERE ROLL_MANA_NO = ?) A
- ,(SELECT ORG_SEQ FROM TBF02_CHG_ROLL WHERE ROLL_MANA_NO = ?) B
- ,(SELECT ORG_SEQ FROM TBF02_CHG_ROLL WHERE ROLL_MANA_NO = ?) C
- ]]>
- </query>
-
- <query id="NIF024030_TmpChgRoll.select" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
- <![CDATA[
- SELECT ORG_SEQ
- FROM TBF02_CHG_ROLL
- ORDER BY ORG_SEQ
- ]]>
- </query>
-
- <query id="NIF024030_TmpChgRoll.update" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_CHG_ROLL
- SET CHG_SEQ = ?
- ,FL = ?
- WHERE ORG_SEQ = ?
- ]]>
- </query>
-
- <query id="NIF024030_TmpChgRollChg.select" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
- <![CDATA[
- SELECT ORG_SEQ
- ,ROLL_MANA_NO
- ,FL
- FROM TBF02_CHG_ROLL
- ORDER BY CHG_SEQ
- ]]>
- </query>
- <query id="NIF024030_TmpChgRollManaNo.update" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_CHG_ROLL
- SET CHG_ROLL_MANA_NO = ?
- WHERE ORG_SEQ = ?
- ]]>
- </query>
-
- <query id="NIF024030_ChgManaNoUpd.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT CHG_ROLL_MANA_NO
- ,ROLL_MANA_NO
- FROM TBF02_CHG_ROLL
- WHERE FL = 'Y'
- ORDER BY CHG_ROLL_MANA_NO
- ]]>
- </query>
-
-
- <query id="NIF024030_SpecRollUpd.update" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_SPEC_ROLL
- SET ROLL_MANA_NO = ?
- ,FL = 'Y'
- WHERE ROLL_MANA_NO = ?
- AND FL IS NULL
- ]]>
- </query>
-
- <query id="NIF024030_SpecMillUpd.update" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_SPEC_MILL
- SET ROLL_MANA_NO = ?
- ,FL = 'Y'
- WHERE ROLL_MANA_NO = ?
- AND FL IS NULL
- ]]>
- </query>
-
- <query id="NIF024030_MillIdxUpd.update" desc="it's query from TBF02_MILL_IDX Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_MILL_IDX
- SET ROLL_MANA_NO = ?
- ,FL = 'Y'
- WHERE ROLL_MANA_NO = ?
- AND FL IS NULL
- ]]>
- </query>
-
- <query id="NIF024030_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 IN (SELECT A.CHG_ROLL_MANA_NO
- FROM TBF02_CHG_ROLL A
- WHERE A.FL = 'Y')
- ORDER BY A.ROLL_MANA_NO
- ]]>
- </query>
-
- <query id="NIF024030_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 IN (SELECT A.CHG_ROLL_MANA_NO
- FROM TBF02_CHG_ROLL A
- WHERE A.FL = 'Y')
- ORDER BY A.ROLL_MANA_NO
- ,A.ROLL_SLAB_SEQ
- ]]>
- </query>
-
- <query id="NIF024030_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) -- 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
- WHERE A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ(+)
- AND A.ROLL_MANA_NO IN (SELECT A.CHG_ROLL_MANA_NO
- FROM TBF02_CHG_ROLL A
- WHERE A.FL = 'Y')
- ORDER BY A.ROLL_MANA_NO
- ,A.ROLL_SLAB_SEQ
- ]]>
- </query>
-
- <query id="NIF024030_ChgRollManaNo.select" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- SELECT CHG_ROLL_MANA_NO
- FROM TBF02_CHG_ROLL
- WHERE FL = 'Y'
- ORDER BY CHG_ROLL_MANA_NO
- ]]>
- </query>
-
- <query id="NIF024030_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 = ?
- ORDER BY A.ROLL_SLAB_SEQ
- ]]>
- </query>
-
- <query id="NIF024030_ChgRoll.delete" desc="it's query from TBF02_CHG_ROLL Table" fetchSize="10">
- <![CDATA[
- DELETE
- FROM TBF02_CHG_ROLL
- ]]>
- </query>
- <query id="NIF024030_InitSpecRoll.update" desc="it's query from TBF02_SPEC_ROLL Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_SPEC_ROLL
- SET FL = NULL
- where fl is not null
-
- ]]>
- </query>
- <query id="NIF024030_InitSpecMill.update" desc="it's query from TBF02_SPEC_MILL Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_SPEC_MILL
- SET FL = NULL
- where fl is not null
- ]]>
- </query>
- <query id="NIF024030_InitMillIdx.update" desc="it's query from TBF02_MILL_IDX Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF02_MILL_IDX
- SET FL = NULL
- where fl is not null
- ]]>
- </query>
-
- </queryMap>
|
