| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="SMS WORK INSTRUCTION RH, LF LINE CHANGING ">
-
- <query id="NIF012170_ChargeManaNoInf.select" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
- <![CDATA[
- SELECT A.CHARGE_EDT_SEQ
- ,A.PRC_LINE
- ,A.PATH_PROC_CD
- ,A.LINE_PROC_CD
- ,A.STL_GRD
- ,B.RH_TGT_TEMP
- ,B.LF_TGT_TEMP
- ,B.VD_TGT_TEMP
- ,C.L2_SEND
- ,C.CHG_SEQ
- FROM TBF01_SPEC_CHARGE A
- ,TBG01_OPRN_STD B
- ,TBF01_CHARGE_IDX C
- WHERE A.CHARGE_MANA_NO = ?
- AND A.STL_GRD = B.STL_GRD(+)
- AND A.STATUS_CD IN ('A','B')
- AND A.CHARGE_EDT_SEQ = C.CHARGE_EDT_SEQ
- ]]>
- </query>
- <query id="NIF012170_TreatRtInf.select" desc="it's query from TBZ00_COMMCD Table" fetchSize="10">
- <![CDATA[
- SELECT SM_CD
- FROM TBZ00_COMMCD
- WHERE LG_CD = 'F01004'
- AND SM_CFNM = ?
- ]]>
- </query>
- <query id="NIF012170_ChargeProcLineUpd.update" desc="it's query from TBF01_SPEC_CHARGE Table" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_SPEC_CHARGE
- SET PATH_PROC_CD = ?
- ,LINE_PROC_CD = ?
- ,TREAT_RT_CD = ?
- ,RH_TEMP_TGT = ?
- ,LF_TEMP_TGT = ?
- ,VD_TEMP_TGT = ?
- WHERE CHARGE_EDT_SEQ = ?
- ]]>
- </query>
-
- <query id="NIF012170_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 C.SEQ_NO + ROWNUM -- SEQ_NO
- ,'N' -- MSG_FLAG
- ,'L3KR00003' -- TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') -- TRANS_DTIME
- ,LPAD(TO_CHAR(C.SEQ_NO + ROWNUM),4,'0') -- SEND_SEQ
- ,'' -- SEND_RESERV
- ,'U' -- 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 = 'Y'
- AND B.STATUS_CD IN ('A','B')
- AND B.PRC_LINE = ?
- AND B.CHG_SEQ >= (SELECT CHG_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND STATUS_CD IN ('A','B')
- AND PRC_LINE = ?
- AND CHARGE_EDT_SEQ = ?)
- ]]>
- </query>
- <query id="NIF012170_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 D.SEQ_NO + ROWNUM -- SEQ_NO
- ,'N' -- MSG_FLAG
- ,'L3KR00004' -- TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') -- TRANS_DTIME
- ,LPAD(TO_CHAR(D.SEQ_NO + ROWNUM),4,'0') -- SEND_SEQ
- ,'' -- SEND_RESERV
- ,'U' -- 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 = 'Y'
- AND C.STATUS_CD IN ('A','B')
- AND C.PRC_LINE = ?
- AND C.CHG_SEQ >= (SELECT CHG_SEQ
- FROM TBF01_CHARGE_IDX
- WHERE L2_SEND = 'Y'
- AND STATUS_CD IN ('A','B')
- AND PRC_LINE = ?
- AND CHARGE_EDT_SEQ = ?)
- ]]>
- </query>
-
- </queryMap>
|
