| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="SMS WORK INSTRUCTION LEVEL2 SEND">
- <query id="NIF012110_ChgSeqInf_INSERT.call" desc="充当降级历史记录" fetchSize="10">
- <![CDATA[
- {call ZL_HOST_DCS01.XGLG_CHEM_ANAY_COMM(:1,:2)}
- ]]>
- </query>
-
- <query id="NIF012110_ChgSeqInf.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
- <![CDATA[
- SELECT CHG_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE PRC_LINE = ?
- AND CHARGE_MANA_NO = ?
- AND L2_SEND = 'N'
- AND STATUS_CD = 'A'
- ]]>
- </query>
- <query id="NIF012110_L2Charge.insert" desc="it's query from TBG06_L2_CHARGE_INS Table" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG06_L2_CHARGE_INS
- (SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,PLAN_CHARGE_NO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,STL_GRD
- ,SPEC_ABBSYM
- ,PLAN_CHARGE_WGT
- ,HM_STR_DTIME
- ,BLOW_STR_DTIME
- ,PRE_BOF_STR_DTIME
- ,PRE_BOF_END_DTIME
- ,PRE_CAS_STR_DTIME
- ,PRE_CAS_END_DTIME
- ,PRE_RH_STR_DTIME
- ,PRE_RH_END_DTIME
- ,PRE_LF_STR_DTIME
- ,PRE_LF_END_DTIME
- ,TREAT_RT_CD
- ,BOF_TEMP_TGT
- ,CAS_TEMP_TGT
- ,RH_TEMP_TGT
- ,LF_TEMP_TGT)
- SELECT SEND_SEQ + ROWNUM -- SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,LPAD(TO_CHAR(SEND_SEQ + ROWNUM),4,'0') -- SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,PLAN_CHARGE_NO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,STL_GRD
- ,SPEC_ABBSYM
- ,PLAN_CHARGE_WGT
- ,HM_STR_DTIME
- ,BLOW_STR_DTIME
- ,PRE_BOF_STR_DTIME
- ,PRE_BOF_END_DTIME
- ,PRE_CAS_STR_DTIME
- ,PRE_CAS_END_DTIME
- ,PRE_RH_STR_DTIME
- ,PRE_RH_END_DTIME
- ,PRE_LF_STR_DTIME
- ,PRE_LF_END_DTIME
- ,TREAT_RT_CD
- ,BOF_TEMP_TGT
- ,CAS_TEMP_TGT
- ,RH_TEMP_TGT
- ,LF_TEMP_TGT
- FROM (SELECT 'N' MSG_FLAG
- ,'L3KR00003' TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') TRANS_DTIME
- ,C.SEQ_NO SEND_SEQ
- ,'' SEND_RESERV
- ,'I' SEND_CLF
- ,A.CHARGE_MANA_NO PLAN_CHARGE_NO
- ,A.CAST_MANA_NO CAST_NO
- ,A.CAST_EDT_CHARGE_CNT CAST_EDT_CHARGE_CNT
- ,A.CAST_CHARGE_SEQ CAST_CHARGE_SEQ
- ,A.STL_GRD STL_GRD
- ,A.SPEC_ABBSYM SPEC_ABBSYM
- ,A.PREV_CHARGE_WGT PLAN_CHARGE_WGT
- ,A.HM_STR_DTIME HM_STR_DTIME
- ,A.BLOW_STR_DTIME BLOW_STR_DTIME
- ,A.PRE_BOF_STR_DTIME PRE_BOF_STR_DTIME
- ,A.PRE_BOF_END_DTIME PRE_BOF_END_DTIME
- ,A.PRE_CAS_STR_DTIME PRE_CAS_STR_DTIME
- ,A.PRE_CAS_END_DTIME PRE_CAS_END_DTIME
- ,A.PRE_RH_STR_DTIME PRE_RH_STR_DTIME
- ,A.PRE_RH_END_DTIME PRE_RH_END_DTIME
- ,A.PRE_LF_STR_DTIME PRE_LF_STR_DTIME
- ,A.PRE_LF_END_DTIME PRE_LF_END_DTIME
- ,A.TREAT_RT_CD TREAT_RT_CD
- ,A.BOF_TEMP_TGT BOF_TEMP_TGT
- ,A.CAS_TEMP_TGT CAS_TEMP_TGT
- ,A.RH_TEMP_TGT RH_TEMP_TGT
- ,A.LF_TEMP_TGT LF_TEMP_TGT
- FROM TBF01_SPEC_CHARGE A
- ,TBF01_CHARGE_IDX B,
- (SELECT NVL(MAX(SEQ_NO),0) SEQ_NO
- FROM TBG06_L2_CHARGE_INS
- WHERE TRANS_DTIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
- WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
- AND B.L2_SEND = 'N'
- AND B.STATUS_CD = 'A'
- AND B.PRC_LINE = ?
- AND B.CHG_SEQ <= ?
- ORDER BY A.CHARGE_MANA_NO)
- ]]>
- </query>
- <query id="NIF012110_L2Ccm.insert" desc="it's query from TBG06_L2_CCM_INS Table" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG06_L2_CCM_INS
- (SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,PLAN_CHARGE_NO
- ,STL_GRD
- ,SPEC_ABBSYM
- ,CC_DEVNO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,PLAN_CHARGE_WGT
- ,PLAN_CC_STA_DTIME
- ,PLAN_CC_END_DTIME
- ,TD_TEMP_AVE
- ,TD_TEMP_MIN
- ,TD_TEMP_MAX
- ,SOLIDE_TEMP1
- ,SOLIDE_TEMP2
- ,CCM_SPEED_MIN1
- ,CCM_SPEED_MAX1
- ,CCM_SPEED_AVG1
- ,CCM_SPEED_MIN2
- ,CCM_SPEED_MAX2
- ,CCM_SPEED_AVG2
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_CNT
- ,SLAB_WGT)
- SELECT SEND_SEQ + ROWNUM -- SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,LPAD(TO_CHAR(SEND_SEQ + ROWNUM),4,'0') -- SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,PLAN_CHARGE_NO
- ,STL_GRD
- ,SPEC_ABBSYM
- ,CC_DEVNO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,PLAN_CHARGE_WGT
- ,PLAN_CC_STA_DTIME
- ,PLAN_CC_END_DTIME
- ,TD_TEMP_AVE
- ,TD_TEMP_MIN
- ,TD_TEMP_MAX
- ,SOLIDE_TEMP1
- ,SOLIDE_TEMP2
- ,CCM_SPEED_MIN1
- ,CCM_SPEED_MAX1
- ,CCM_SPEED_AVG1
- ,CCM_SPEED_MIN2
- ,CCM_SPEED_MAX2
- ,CCM_SPEED_AVG2
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_CNT
- ,SLAB_WGT
- FROM (SELECT 'N' MSG_FLAG
- ,'L3KR00004' TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') TRANS_DTIME
- ,D.SEQ_NO SEND_SEQ
- ,'' SEND_RESERV
- ,'I' SEND_CLF
- ,A.CHARGE_MANA_NO PLAN_CHARGE_NO
- ,A.STL_GRD STL_GRD
- ,A.SPEC_ABBSYM SPEC_ABBSYM
- ,DECODE(A.CCM_PRC_LINE,'1','J1','J2') CC_DEVNO
- ,A.CAST_MANA_NO CAST_NO
- ,A.CAST_EDT_CHARGE_CNT CAST_EDT_CHARGE_CNT
- ,A.CAST_CHARGE_SEQ CAST_CHARGE_SEQ
- ,A.PREV_CHARGE_WGT PLAN_CHARGE_WGT
- ,A.PRE_CCM_STR_DTIME PLAN_CC_STA_DTIME
- ,A.PRE_CCM_END_DTIME PLAN_CC_END_DTIME
- ,A.TD_TEMP_AVG TD_TEMP_AVE
- ,A.TD_TEMP_MIN TD_TEMP_MIN
- ,A.TD_TEMP_MAX TD_TEMP_MAX
- ,A.SOLIDE_TEMP_TGT1 SOLIDE_TEMP1
- ,A.SOLIDE_TEMP_TGT2 SOLIDE_TEMP2
- ,A.CC_SPEED_MIN1 CCM_SPEED_MIN1
- ,A.CC_SPEED_MAX1 CCM_SPEED_MAX1
- ,A.CC_SPEED_AVG1 CCM_SPEED_AVG1
- ,A.CC_SPEED_MIN2 CCM_SPEED_MIN2
- ,A.CC_SPEED_MAX2 CCM_SPEED_MAX2
- ,A.CC_SPEED_AVG2 CCM_SPEED_AVG2
- ,A.CCM_THK SLAB_THK
- ,A.CCM_WTH SLAB_WTH
- ,A.SLAB_CNT SLAB_CNT
- ,B.SLAB_WGT SLAB_WGT
- FROM TBF01_SPEC_CHARGE A
- ,(SELECT CHARGE_EDT_SEQ, SUM(SLAB_WGT) SLAB_WGT
- FROM TBF01_SPEC_SLAB
- GROUP BY CHARGE_EDT_SEQ) B
- ,TBF01_CHARGE_IDX C
- ,(SELECT NVL(MAX(SEQ_NO),0) SEQ_NO
- FROM TBG06_L2_CCM_INS
- WHERE TRANS_DTIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') D
- WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
- AND A.CHARGE_EDT_SEQ = C.CHARGE_EDT_SEQ
- AND C.L2_SEND = 'N'
- AND C.STATUS_CD = 'A'
- AND C.PRC_LINE = ?
- AND C.CHG_SEQ <= ?
- ORDER BY A.CHARGE_MANA_NO )
- ]]>
- </query>
-
- <query id="NIF012110_L2SlabCut.insert" desc="it's query from TBG06_L2_SLAB_CUT_INS Table" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG06_L2_SLAB_CUT_INS
- (SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,PLAN_CHARGE_NO
- ,PLAN_SLAB_NO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,STL_GRD
- ,SPEC_ABBSYM
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,HCR_CLF)
- SELECT SEND_SEQ + ROWNUM -- SEQ_NO
- ,MSG_FLAG -- MSG_FLAG
- ,TC_ID -- TC_ID
- ,TRANS_DTIME -- TRANS_DTIME
- ,LPAD(TO_CHAR(SEND_SEQ + ROWNUM),4,'0') -- SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF -- SEND_CLF
- ,PLAN_CHARGE_NO -- PLAN_CHARGE_NO
- ,PLAN_SLAB_NO -- PLAN_SLAB_NO
- ,CAST_NO -- CAST_NO
- ,CAST_EDT_CHARGE_CNT -- CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ -- CAST_CHARGE_SEQ
- ,STL_GRD -- STL_GRD
- ,SPEC_ABBSYM -- SPEC_ABBSYM
- ,SLAB_THK -- SLAB_THK
- ,SLAB_WTH -- SLAB_WTH
- ,SLAB_LEN -- SLAB_LEN
- ,HCR_CLF -- HCR_CLF
- FROM (SELECT 'N' MSG_FLAG
- ,'L3KR00005' TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') TRANS_DTIME
- ,D.SEQ_NO SEND_SEQ
- ,'' SEND_RESERV
- ,'I' SEND_CLF
- ,B.CHARGE_MANA_NO PLAN_CHARGE_NO
- ,B.SLAB_MANA_NO PLAN_SLAB_NO
- ,B.CAST_MANA_NO CAST_NO
- ,A.CAST_EDT_CHARGE_CNT CAST_EDT_CHARGE_CNT
- ,A.CAST_CHARGE_SEQ CAST_CHARGE_SEQ
- ,B.STL_GRD STL_GRD
- ,B.SPEC_ABBSYM SPEC_ABBSYM
- ,B.SLAB_THK SLAB_THK
- ,B.SLAB_WTH SLAB_WTH
- ,B.SLAB_LEN SLAB_LEN
- ,B.HCR_CLF HCR_CLF
- FROM TBF01_SPEC_CHARGE A
- ,TBF01_SPEC_SLAB B
- ,TBF01_CHARGE_IDX C
- ,(SELECT NVL(MAX(SEQ_NO),0) SEQ_NO
- FROM TBG06_L2_SLAB_CUT_INS
- WHERE TRANS_DTIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') D
- WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
- AND A.CHARGE_EDT_SEQ = C.CHARGE_EDT_SEQ
- AND C.L2_SEND = 'N'
- AND C.STATUS_CD = 'A'
- AND C.PRC_LINE = ?
- AND C.CHG_SEQ <= ?
- ORDER BY B.CHARGE_MANA_NO
- ,B.SLAB_MANA_NO )
- ]]>
- </query>
- <query id="NIF012110_L2SlabCut02.insert" desc="it's query from TBG06_L2_SLAB_CUT_INS Table" fetchSize="10">
- <![CDATA[
- INSERT INTO tbg06_l2_ord_ins
- (SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,SLAB_NO
- ,ORD_NO
- ,ORD_SEQ
- ,REG_DTIME
- ,REG_ID)
- SELECT SEND_SEQ + ROWNUM -- SEQ_NO
- ,MSG_FLAG -- MSG_FLAG
- ,TC_ID -- TC_ID
- ,TRANS_DTIME -- TRANS_DTIME
- ,LPAD(TO_CHAR(SEND_SEQ + ROWNUM),4,'0') -- SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF -- SEND_CLF
- ,PLAN_SLAB_NO -- PLAN_SLAB_NO
- ,ORD_NO -- ORD_NO
- ,ORD_SEQ -- ORD_SEQ
- ,REG_DTIME -- REG_DTIME
- ,REG_ID -- REG_ID
- FROM (SELECT 'N' MSG_FLAG
- ,'L3KR00005' TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') TRANS_DTIME
- ,D.SEQ_NO SEND_SEQ
- ,'' SEND_RESERV
- ,'I' SEND_CLF
-
- ,B.SLAB_MANA_NO PLAN_SLAB_NO
- ,b.ORD_NO ord_no
- ,b.ord_seq ord_seq
- ,'USER002' REG_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') REG_DTIME
- FROM TBF01_SPEC_CHARGE A
- ,TBF01_SPEC_SLAB B
- ,TBF01_CHARGE_IDX C
- ,(SELECT NVL(MAX(SEQ_NO),0) SEQ_NO
- FROM TBG06_L2_ORD_INS
- WHERE TRANS_DTIME LIKE TO_CHAR(SYSDATE, 'YYYYMM') || '%') D
- WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
- AND A.CHARGE_EDT_SEQ = C.CHARGE_EDT_SEQ
- AND C.L2_SEND = 'N'
- AND C.STATUS_CD = 'A'
- AND C.PRC_LINE = :1
- AND C.CHG_SEQ <= :2
- ORDER BY B.CHARGE_MANA_NO
- ,B.SLAB_MANA_NO )
- ]]>
- </query>
- <query id="NIF012110_L2SlabCut.delete" desc="it's query from TBG06_L2_SLAB_CUT_INS Table" fetchSize="10">
- <![CDATA[
- delete TBG06_L2_ORD_INS T
- WHERE SUBSTR(T.TRANS_DTIME,1,8) <= TO_CHAR(SYSDATE - 20,'YYYYMMDD')
- and t.MSG_FLAG = 'C'
- ]]>
- </query>
- <query id="NIF012110_ChargeProgUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_SPEC_CHARGE
- SET PROG_CD = 'JBB'
- ,MOD_DTIME = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')
- ,MOD_ID = ?
- WHERE CHARGE_EDT_SEQ IN (SELECT CHARGE_EDT_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'N'
- AND STATUS_CD = 'A'
- AND PRC_LINE = ?
- AND CHG_SEQ <= ?)
- ]]>
- </query>
-
- <query id="NIF012110_ChargeInf.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
- <![CDATA[
- SELECT A.CHARGE_EDT_SEQ
- ,A.CHARGE_MANA_NO
- ,B.PREV_CHARGE_WGT
- FROM TBF01_SPEC_CHARGE B
- ,TBF01_CHARGE_IDX A
- WHERE B.CHARGE_EDT_SEQ = A.CHARGE_EDT_SEQ
- AND A.L2_SEND = 'N'
- AND A.STATUS_CD = 'A'
- AND A.PRC_LINE = ?
- AND A.CHG_SEQ <= (SELECT CHG_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE CHARGE_MANA_NO = ?
- AND L2_SEND = 'N'
- AND STATUS_CD = 'A')
- ORDER BY A.CHG_SEQ
- ]]>
- </query>
-
- <query id="NIF012110_ChargeIdxUpd.update" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_CHARGE_IDX
- SET L2_SEND = 'Y'
- WHERE L2_SEND = 'N'
- AND STATUS_CD = 'A'
- AND PRC_LINE = ?
- AND CHG_SEQ <= ?
- ]]>
- </query>
-
- </queryMap>
|
