| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="XTBGCOMM_CHEK_CHARGE_COMM_01" desc="" fetchSize="10">
- <![CDATA[
- SELECT CHARGE_NO FROM TBG02_CHARGE_COMM
- WHERE CHARGE_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_CREATE_CHARGE_INSERT_01" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_CHARGE_COMM (
- CHARGE_NO
- ,PLAN_CHARGE_NO
- ,CHARGE_STAT
- ,INSTR_RT
- ,PRODNM_CD
- ,SPEC_ABBSYM
- ,STL_GRD
- ,HCR_CLF
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,CUR_PROG_CD
- ,CUR_PROG_CD_REG_PGM
- ,CUR_PROG_CD_REG_DTIME
- ,BEF_PROG_CD
- ,CAST_NO
- ,REG_DTIME
- ,SLAB_RT
- ,CHARGE_WGT --装入钢水量
- ,BOF_TAPPING_WGT --转炉出钢量
- ,CHARGE_INIT_DTIME
- )
- (SELECT 'J'||SUBSTR(A.CHARGE_MANA_NO,2,9)
- ,A.CHARGE_MANA_NO
- ,'2'
- ,A.LINE_PROC_CD
- ,A.PRODNM_CD
- ,A.SPEC_ABBSYM
- ,A.STL_GRD
- ,A.HCR_CLF
- ,A.CAST_EDT_CHARGE_CNT
- ,A.CAST_CHARGE_SEQ
- ,'JBB'
- ,''
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- ,'JBA'
- ,A.CAST_MANA_NO
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- ,A.CHARGE_RT
- ,A.PREV_CHARGE_WGT --预定出钢量
- ,A.PREV_CHARGE_WGT --预定出钢量
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- FROM TBF01_SPEC_CHARGE A
- WHERE '1' = '1'
- AND A.CHARGE_MANA_NO = ?
- )
- ]]>
- </query>
- <query id="XTBGCOMM_CREATE_CHARGE_D_INSERT_01" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_CHARGE_COMM_D
- (SUB_CHARGE_NO
- ,CHARGE_NO
- ,STL_GRD
- ,CHARGE_STAT
- ,CUR_PROG_CD
- ,CUR_PROG_CD_REG_PGM
- ,CUR_PROG_CD_REG_DTIME
- ,CHARGE_WGT
- ,SLAB_CNT
- ,SUB_CHARGE_CODE
- ,SLAB_RT
- ,CHARGE_INIT_DTIME
- )
- (SELECT 'J'||SUBSTR(CHARGE_MANA_NO,2,9)
- ,'J'||SUBSTR(CHARGE_MANA_NO,2,9)
- ,STL_GRD
- ,'2'
- ,'JBB'
- ,'TBGCREAE'
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- ,PREV_CHARGE_WGT CHARGE_WGT
- ,SLAB_CNT
- ,'A' SUB_CHARGE_CODE
- ,CHARGE_RT
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- FROM TBF01_SPEC_CHARGE
- WHERE CHARGE_MANA_NO = ?)
- ]]>
- </query>
- <query id="XTBGCOMM_CREATE_SLAB_INSERT_01" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_SLAB_COMM
- ( SLAB_NO
- ,sub_slab_no
- ,CHARGE_NO
- ,PLAN_SLAB_NO
- ,SLAB_STAT
- ,STL_GRD
- ,INSTR_SLAB_THK
- ,INSTR_SLAB_WTH
- ,INSTR_SLAB_LEN
- ,INSTR_SLAB_WGT
- ,PRODNM_CD
- ,ORD_FL
- ,ORD_NO
- ,ORD_SEQ
- ,HCR_CLF
- ,SPEC_ABBSYM
- ,REG_DTIME
- ,INSTR_ORD_FL
- ,ORG_ORD_NO
- ,ORG_ORD_SEQ
- ,INSTR_COIL_THK
- ,INSTR_COIL_WTH
- ,INSTR_COIL_LEN
- ,INSTR_COIL_INDIA
- ,INSTR_COIL_OUTDIA
- ,INSTR_COIL_WGT
- ,SLAB_RT
- ,CAST_NO
- ,DSN_SLAB_NO
- )
- SELECT T.SLAB_MANA_NO --'J'||SUBSTR(T.SLAB_MANA_NO,2,12)
- ,'J'||SUBSTR(T.SLAB_MANA_NO,2,12)
- ,'J'||SUBSTR(T.CHARGE_MANA_NO,2,9)
- ,T.SLAB_MANA_NO
- ,'1',T.STL_GRD
- ,T.SLAB_THK
- ,T.SLAB_WTH
- ,T.SLAB_LEN
- ,T.SLAB_WGT
- ,T.PRODNM_CD
- ,T.ORD_FL
- ,T.ORD_NO
- ,T.ORD_SEQ
- ,T.HCR_CLF
- ,T.SPEC_ABBSYM
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMDD')
- ,T.ORD_FL
- ,T.ORD_NO
- ,T.ORD_SEQ
- ,T.ORD_THK
- ,T.ORD_WTH
- ,T.ORD_LEN
- ,T.COIL_INDIA
- ,T.COIL_OUTDIA
- ,T.ORD_WGT
- ,T.SLAB_RT
- ,T.CAST_MANA_NO
- ,T.DSN_SLAB_NO
- FROM TBF01_SPEC_SLAB T
- WHERE T.SLAB_MANA_NO LIKE ?||'%'
- ]]>
- </query>
- <query id="XTBGCOMM_CREATE_SLAB_INSERT_02" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_SLAB_COMM
- ( SLAB_NO
- ,SUB_SLAB_NO
- ,CHARGE_NO
- ,PLAN_SLAB_NO
- ,SLAB_STAT
- ,STL_GRD
- ,INSTR_SLAB_THK
- ,INSTR_SLAB_WTH
- ,INSTR_SLAB_LEN
- ,INSTR_SLAB_WGT
- ,PRODNM_CD
- ,ORD_FL
- ,ORD_NO
- ,ORD_SEQ
- ,HCR_CLF
- ,SPEC_ABBSYM
- ,REG_DTIME
- ,INSTR_ORD_FL
- ,ORG_ORD_NO
- ,ORG_ORD_SEQ
- ,INSTR_COIL_THK
- ,INSTR_COIL_WTH
- ,INSTR_COIL_LEN
- ,INSTR_COIL_INDIA
- ,INSTR_COIL_OUTDIA
- ,INSTR_COIL_WGT
- ,SLAB_RT
- ,CAST_NO
- ,SURPLMATL_YN
- ,SLAB_INGR_DEC_GRD
- ,SLAB_INGR_DEC_KIND
- )
- SELECT SUBSTR(T.SLAB_MANA_NO,1,10)||lpad(B.SLAB_CNT,2,'0')||'0' --'J'||SUBSTR(T.SLAB_MANA_NO,2,12)
- ,'J'||SUBSTR(T.SLAB_MANA_NO,2,9)||lpad(B.SLAB_CNT,2,'0')||'0'
- ,'J'||SUBSTR(T.CHARGE_MANA_NO,2,9)
- ,SUBSTR(T.SLAB_MANA_NO,1,10)||'010'
- ,'1',T.STL_GRD
- ,T.SLAB_THK
- ,T.SLAB_WTH
- ,T.SLAB_LEN
- ,T.SLAB_WGT
- ,T.PRODNM_CD
- ,T.ORD_FL
- ,T.ORD_NO
- ,T.ORD_SEQ
- ,T.HCR_CLF
- ,T.SPEC_ABBSYM
- ,TO_CHAR(SYSDATE,'YYYYMMDDHHMMDD')
- ,'2' ORD_FL
- ,'' ORD_NO
- ,'' ORD_SEQ
- ,T.ORD_THK
- ,T.ORD_WTH
- ,T.ORD_LEN
- ,T.COIL_INDIA
- ,T.COIL_OUTDIA
- ,T.ORD_WGT
- ,T.SLAB_RT
- ,T.CAST_MANA_NO
- ,'S'
- /*,C.INGR_DEC_GRD
- ,'8' SLAB_INGR_DEC_KIND*/
- ,''
- ,''
- FROM TBF01_SPEC_SLAB T
- ,(SELECT SUBSTR(PLAN_SLAB_NO,1,10) CHARGE_MANA_NO,COUNT(SLAB_NO)+1 SLAB_CNT
- FROM TBG02_SLAB_COMM
- WHERE PLAN_SLAB_NO LIKE SUBSTR(?,1,10)||'%'
- GROUP BY SUBSTR(PLAN_SLAB_NO,1,10))B
- ,TBG02_CHARGE_COMM_D C
- ,TBG02_CHARGE_COMM D
- WHERE SUBSTR(T.SLAB_MANA_NO,1,10) = B.CHARGE_MANA_NO
- AND B.CHARGE_MANA_NO = D.PLAN_CHARGE_NO
- AND C.SUB_CHARGE_NO = D.CHARGE_NO
- AND T.SLAB_MANA_NO LIKE ?||'%'
- AND ROWNUM = 1
- ]]>
- </query>
- <query id="XTBGCOMM_CREATE_SLAB_D_INSERT_01" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_SLAB_COMM_D
- ( SLAB_NO
- ,SLAB_CUT_SEQ
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,ORD_THK
- ,ORD_WTH
- ,ORD_LEN
- ,ORD_WGT
- ,COIL_INDIA
- ,COIL_OUTDIA
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_FL )
- SELECT 'J'||SUBSTR(B.SLAB_MANA_NO,2,12) SLAB_NO
- ,A.SLAB_CUT_SEQ
- ,A.SLAB_THK
- ,A.SLAB_WTH
- ,A.SLAB_LEN
- ,A.ORD_THK
- ,A.ORD_WTH
- ,A.ORD_LEN
- ,A.ORD_WGT
- ,A.COIL_INDIA
- ,A.COIL_OUTDIA
- ,A.ORD_NO
- ,A.ORD_SEQ
- ,'2' ORD_FL
- FROM TBF01_SPEC_SLAB_D A
- ,TBF01_SPEC_SLAB B
- WHERE A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ
- AND B.SLAB_MANA_NO LIKE ?||'%'
- AND ROWNUM = 1
- ]]>
- </query>
- <query id="XTBGCOMM_CREATE_SLAB_D_INSERT_02" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO TBG02_SLAB_COMM_D
- ( SLAB_NO
- ,SLAB_CUT_SEQ
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,ORD_THK
- ,ORD_WTH
- ,ORD_LEN
- ,ORD_WGT
- ,COIL_INDIA
- ,COIL_OUTDIA
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_FL )
- SELECT 'J'||SUBSTR(B.SLAB_MANA_NO,2,9)||lpad(C.SLAB_CNT,2,'0')||'0' SLAB_NO
- ,A.SLAB_CUT_SEQ
- ,A.SLAB_THK
- ,A.SLAB_WTH
- ,A.SLAB_LEN
- ,A.ORD_THK
- ,A.ORD_WTH
- ,A.ORD_LEN
- ,A.ORD_WGT
- ,A.COIL_INDIA
- ,A.COIL_OUTDIA
- ,A.ORD_NO
- ,A.ORD_SEQ
- ,A.ORD_FL
- FROM TBF01_SPEC_SLAB_D A
- ,TBF01_SPEC_SLAB B
- , ( SELECT SUBSTR(PLAN_SLAB_NO,1,10) CHARGE_MANA_NO,COUNT(SLAB_NO) SLAB_CNT
- FROM TBG02_SLAB_COMM
- WHERE PLAN_SLAB_NO LIKE SUBSTR(?,1,10)||'%'
- GROUP BY SUBSTR(PLAN_SLAB_NO,1,10))C
- WHERE A.SLAB_EDT_SEQ = B.SLAB_EDT_SEQ
- AND SUBSTR(B.SLAB_MANA_NO,1,10) = C.CHARGE_MANA_NO
- AND B.SLAB_MANA_NO LIKE ?||'%'
- AND ROWNUM = 1
- ]]>
- </query>
- <query id="XTBGCOMM_SPEC_CHARGE_PROC_UPT_01" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_SPEC_CHARGE
- SET PROG_CD = ?
- ,STATUS_CD = ?
- WHERE CHARGE_MANA_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_SPEC_CHARGE_PROC_UPT_02" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBF01_CHARGE_IDX
- SET STATUS_CD = ?
- WHERE CHARGE_MANA_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_SPEC_SLAB_PROC_UPT_01" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBF01_SPEC_SLAB
- SET STATUS_CD = ?
- WHERE SLAB_MANA_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_SPEC_SLAB_PROC_UPT_02" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBF01_SPEC_SLAB_D
- SET STATUS_CD = ?
- WHERE SLAB_EDT_SEQ IN (SELECT SLAB_EDT_SEQ FROM TBF01_SPEC_SLAB WHERE SLAB_MANA_NO = ?)
- ]]>
- </query>
- <query id="XTBGCOMM_CHARGE_PROC_UPT_01" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CHARGE_COMM T
- SET T.CHARGE_STAT = ?
- ,T.BEF_PROG_CD = T.CUR_PROG_CD
- ,T.BEF_PROG_CD_REG_PGM = T.CUR_PROG_CD_REG_PGM
- ,T.BEF_PROG_CD_REG_DTIME = T.CUR_PROG_CD_REG_DTIME
- ,T.CUR_PROG_CD = ?
- ,T.CUR_PROG_CD_REG_PGM = ?
- ,T.CUR_PROG_CD_REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MMSS')
- WHERE T.CHARGE_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_CHARGE_PROC_UPT_02" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBG02_CHARGE_COMM_D T
- SET T.CHARGE_STAT = ?
- ,T.BEF_PROG_CD = T.CUR_PROG_CD
- ,T.BEF_PROG_CD_REG_PGM = T.CUR_PROG_CD_REG_PGM
- ,T.BEF_PROG_CD_REG_DTIME = T.CUR_PROG_CD_REG_DTIME
- ,T.CUR_PROG_CD = ?
- ,T.CUR_PROG_CD_REG_PGM = ?
- ,T.CUR_PROG_CD_REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- WHERE T.CHARGE_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_SLAB_PROC_UPT_01" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM T
- SET T.SLAB_STAT = ?
- ,T.BEF_PROG_CD = T.CUR_PROG_CD
- ,T.BEF_PROG_CD_PGM = T.CUR_PROG_CD_PGM
- ,T.BEF_PROG_CD_DTIME = T.CUR_PROG_CD_DTIME
- ,T.CUR_PROG_CD = ?
- ,T.CUR_PROG_CD_PGM = ?
- ,T.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- WHERE T.SLAB_NO = ?
- ]]>
- </query>
- <query id="XTBGCOMM_GET_SUBSLAB_NO" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM T
- SET T.SLAB_STAT = ?
- ,T.BEF_PROG_CD = T.CUR_PROG_CD
- ,T.BEF_PROG_CD_PGM = T.CUR_PROG_CD_PGM
- ,T.BEF_PROG_CD_DTIME = T.CUR_PROG_CD_DTIME
- ,T.CUR_PROG_CD = ?
- ,T.CUR_PROG_CD_PGM = ?
- ,T.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHHMMSS')
- WHERE T.SLAB_NO = ?
- ]]>
- </query>
- </queryMap>
|
