| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="SMS WORK INSTRUCTION LEVEL2 CANCEL">
-
- <query id="NIF012140_ChgSeqInf.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
- <![CDATA[
- SELECT CHG_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND PRC_LINE = ?
- AND CHARGE_MANA_NO = ?
- ]]>
- </query>
- <query id="NIF012140_ChgCntChk.select" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
- <![CDATA[
- SELECT SUM(DECODE(STATUS_CD,'B',1,0)) STATUS_CNT
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND PRC_LINE = ?
- AND CHG_SEQ >= ?
- ]]>
- </query>
-
- <query id="NIF012140_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 B.SEQ_NO + ROWNUM -- SEQ_NO
- ,'N' -- MSG_FLAG
- ,'L3KR00003' -- TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') -- TRANS_DTIME
- ,LPAD(TO_CHAR(B.SEQ_NO + ROWNUM),4,'0') -- SEND_SEQ
- ,'' -- SEND_RESERV
- ,'D' -- 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
- ,(SELECT NVL(MAX(SEQ_NO),0) SEQ_NO
- FROM TBG06_L2_CHARGE_INS
- WHERE TRANS_DTIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') B
- WHERE A.CHARGE_EDT_SEQ IN (SELECT CHARGE_EDT_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND PRC_LINE = ?
- AND CHG_SEQ >= ? )
- ]]>
- </query>
- <query id="NIF012140_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 C.SEQ_NO + ROWNUM -- SEQ_NO
- ,'N' -- MSG_FLAG
- ,'L3KR00004' -- TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') -- TRANS_DTIME
- ,LPAD(TO_CHAR(C.SEQ_NO + ROWNUM),4,'0') -- SEND_SEQ
- ,'' -- SEND_RESERV
- ,'D' -- 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
- ,(SELECT NVL(MAX(SEQ_NO),0) SEQ_NO
- FROM TBG06_L2_CCM_INS
- WHERE TRANS_DTIME LIKE TO_CHAR(SYSDATE, 'YYYYMMDD') || '%') C
- WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
- AND A.CHARGE_EDT_SEQ IN (SELECT CHARGE_EDT_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND PRC_LINE = ?
- AND CHG_SEQ >= ? )
- ]]>
- </query>
-
- <query id="NIF012140_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 -- MSG_FLAG
- ,'L3KR00005' TC_ID -- TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') TRANS_DTIME -- TRANS_DTIME
- ,D.SEQ_NO SEND_SEQ -- SEND_SEQ
- ,'D' SEND_CLF -- SEND_CLF
- ,B.CHARGE_MANA_NO PLAN_CHARGE_NO -- PLAN_CHARGE_NO
- ,B.SLAB_MANA_NO PLAN_SLAB_NO -- PLAN_SLAB_NO
- ,B.CAST_MANA_NO CAST_NO -- CAST_NO
- ,A.CAST_EDT_CHARGE_CNT CAST_EDT_CHARGE_CNT -- CAST_EDT_CHARGE_CNT
- ,A.CAST_CHARGE_SEQ CAST_CHARGE_SEQ -- CAST_CHARGE_SEQ
- ,B.STL_GRD STL_GRD -- STL_GRD
- ,B.SPEC_ABBSYM SPEC_ABBSYM -- SPEC_ABBSYM
- ,B.SLAB_THK SLAB_THK -- SLAB_THK
- ,B.SLAB_WTH SLAB_WTH -- SLAB_WTH
- ,B.SLAB_LEN SLAB_LEN -- SLAB_LEN
- ,B.HCR_CLF 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 = 'Y'
- AND C.PRC_LINE = ?
- AND C.CHG_SEQ >= ?
- ORDER BY B.SLAB_MANA_NO )
- ]]>
- </query>
-
- <query id="NIF012140_ChargeProgUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_SPEC_CHARGE
- SET PROG_CD = 'JBA'
- WHERE CHARGE_EDT_SEQ IN (SELECT CHARGE_EDT_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND PRC_LINE = ?
- AND CHG_SEQ >= ? )
- ]]>
- </query>
-
- <query id="NIF012140_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_CHARGE_IDX A
- ,TBF01_SPEC_CHARGE B
- WHERE B.CHARGE_EDT_SEQ = A.CHARGE_EDT_SEQ
- AND A.L2_SEND = 'Y'
- AND A.STATUS_CD = 'A'
- AND A.PRC_LINE = ?
- AND A.CHG_SEQ >= ?
- ORDER BY A.CHG_SEQ
- ]]>
- </query>
-
- <query id="NIF012140_ChargeIdxUpd.update" desc="it's query from TBF01_CHARGE_IDX Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_CHARGE_IDX
- SET L2_SEND = 'N'
- WHERE L2_SEND = 'Y'
- AND STATUS_CD = 'A'
- AND PRC_LINE = ?
- AND CHG_SEQ >= ?
- ]]>
- </query>
-
- </queryMap>
|
