| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG040062_JH.select" desc=" 加回 " fetchSize="10">
- <![CDATA[
- SELECT '' CHK
- ,C.SLAB_NO
- ,C.SLAB_STAT
- ,C.STL_GRD
- ,C.ORD_FL
- ,C.SLAB_THK
- ,C.SLAB_WTH
- ,C.SLAB_LEN
- ,C.SLAB_WGT
- ,C.CUR_LOAD_LOC
- ,C.CUR_PROG_CD
- ,'加回' BACK_TP
- ,A.MISSNO_CAUSE_CD
- ,B.MISSNO_CAUSE_CD
- ,B.MISSNO_DTIME
- ,B.MISSNO_WK_EMP_NO
- ,B.MISSNO_WKSHIFT
- ,B.MISSNO_WKGROUP
- ,C.SCRAP_WGT
- ,C.ORD_NO
- ,C.ORD_SEQ
- ,C.ORG_ORD_NO
- ,C.ORG_ORD_SEQ
- ,C.CUR_PROG_CD
- ,C.BEF_PROG_CD
- FROM TBH02_COIL_COMM A
- ,TBH02_RHF_MISSNO B
- ,TBG02_SLAB_COMM C
- WHERE '1' = '1'
- AND A.SLAB_NO = B.SLAB_NO
- AND A.SLAB_NO = C.SLAB_NO
- AND C.CUR_LOAD_LOC NOT LIKE 'Z%'
- --AND A.MISSNO_CLF_CD = 'S' --- 加回 轧回 区分
- AND B.MISSNO_CLF = '2' --- 1炉前取消，2炉后加回，3轧回
- AND B.REG_DTIME BETWEEN ?||'000000' AND ?||'999999'
- AND A.SLAB_NO LIKE ?||'%'
- ORDER BY A.SLAB_NO
- ]]>
- </query>
- <query id="UIG040062_ZH.select" desc=" 轧回 " fetchSize="10">
- <![CDATA[
- SELECT '' CHK
- ,C.SLAB_NO
- ,C.SLAB_STAT
- ,C.STL_GRD
- ,C.ORD_FL
- ,C.SLAB_THK
- ,C.SLAB_WTH
- ,C.SLAB_LEN
- ,C.SLAB_WGT
- ,C.CUR_LOAD_LOC
- ,'轧回' BACK_TP
- ,A.MISSNO_CAUSE_CD
- ,B.MISSNO_CAUSE_CD
- ,B.MISSNO_DTIME
- ,B.MISSNO_WK_EMP_NO
- ,B.MISSNO_WKSHIFT
- ,B.MISSNO_WKGROUP
- ,C.SCRAP_WGT
- ,C.ORD_NO
- ,C.ORD_SEQ
- ,C.ORG_ORD_NO
- ,C.ORG_ORD_SEQ
- ,C.CUR_PROG_CD
- ,C.BEF_PROG_CD
- FROM TBH02_COIL_COMM A
- ,TBH02_RHF_MISSNO B
- ,TBG02_SLAB_COMM C
- WHERE '1' = '1'
- AND A.SLAB_NO = B.SLAB_NO
- AND A.SLAB_NO = C.SLAB_NO
- AND C.CUR_LOAD_LOC NOT LIKE 'Z%'
- --AND A.MISSNO_CLF_CD = 'S' --- 加回 轧回 区分
- AND B.MISSNO_CLF = '3' --- 1炉前取消，2炉后加回，3轧回
- AND B.REG_DTIME BETWEEN ?||'000000' AND ?||'999999'
- AND A.SLAB_NO LIKE ?||'%'
- ORDER BY A.SLAB_NO
- ]]>
- </query>
- <query id="UIG040062_CLEAR_SLABYARD.update" desc=" clear yard_addr " fetchSize="10">
- <![CDATA[
- UPDATE TBG04_SLAB_YARD T
- SET T.SLAB_NO = ''
- ,T.BEF_STORE_LOC = ''
- ,T.REG_ID = ''
- ,CR_NO = ''
- ,ORD_FLAG = ''
- ,T.REG_DTIME = ''
- WHERE T.SLAB_NO = :1
- ]]>
- </query>
- <query id="UIG040062_SLABCOMM_JH.update" desc=" 加回 " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM T
- SET T.BEF_LOAD_LOC = T.CUR_LOAD_LOC
- ,T.BEF_LOAD_LOC_DTIME = T.CUR_LOAD_LOC_DTIME
- ,T.CUR_LOAD_LOC = :1
- ,T.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
-
- ,T.SLAB_STOCK_TYPE = '3' -- 加回
- ,T.MILL_SCH_STAT = ''
- ,T.SLAB_STAT = '2'
-
- ,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 = 'RRC'
- ,T.ORD_FL = '2'
- ,T.ORG_ORD_NO = T.ORD_NO
- ,T.ORG_ORD_SEQ = T.ORD_SEQ
- ,T.ORD_NO = ''
- ,T.ORD_SEQ = ''
- ,T.CUR_PROG_CD_PGM = 'UIG040062'
- ,T.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
-
- ,T.SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,T.SLAB_STOCK_SHIFT = :2
- ,T.SLAB_STOCK_GROUP = :3
- ,T.SLAB_STOCK_REG_ID = :4
- WHERE T.SLAB_NO = :5
- ]]>
- </query>
- <query id="UIG040062_SLABCOMM_D_JH.update" desc=" 加回 " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM_D T
- SET T.ORD_FL = '2'
- ,T.ORD_NO = ''
- ,T.ORD_SEQ = ''
- WHERE T.SLAB_NO = :1
- ]]>
- </query>
- <query id="UIG040062_SLABYARD.update" desc=" 加回 " fetchSize="10">
- <![CDATA[
- UPDATE TBG04_SLAB_YARD T
- SET T.SLAB_NO = :1
- ,T.BEF_STORE_LOC = 'RFI'
- ,T.REG_ID = 'UIG040062'
- ,CR_NO = ''
- ,ORD_FLAG = ''
- ,T.REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- WHERE T.YARD_ADDR = :2
- AND T.STORELAY = :3
- ]]>
- </query>
- <query id="UIG040062_SLABCOMM_ZH.update" desc=" 轧回 " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM T
- SET T.BEF_LOAD_LOC = T.CUR_LOAD_LOC
- ,T.BEF_LOAD_LOC_DTIME = T.CUR_LOAD_LOC_DTIME
- ,T.CUR_LOAD_LOC = :1
- ,T.CUR_LOAD_LOC_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
-
- ,t.slab_stock_type = '4' -- 加回
- ,T.MILL_SCH_STAT = ''
- ,T.SLAB_STAT = '2'
- ,T.ORD_FL = '2'
-
- ,T.ORG_ORD_NO = T.ORD_NO
- ,T.ORG_ORD_SEQ = T.ORD_SEQ
- ,T.ORD_NO = ''
- ,T.ORD_SEQ = ''
-
- ,T.SLAB_THK = :2
- ,T.SLAB_WTH = :3
- ,T.SLAB_LEN = :4
- ,T.SLAB_WGT = :5
- ,T.SCRAP_WGT = :6
-
- ,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 = 'RRC'
- ,T.CUR_PROG_CD_PGM = 'UIG040062'
- ,T.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
-
- ,T.SLAB_STOCK_ENT_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,T.SLAB_STOCK_SHIFT = :7
- ,T.SLAB_STOCK_GROUP = :8
- ,T.SLAB_STOCK_REG_ID = :9
- WHERE T.SLAB_NO = :10
- ]]>
- </query>
- <query id="UIG040062_SLABCOMM_D_ZH.update" desc=" 轧回 " fetchSize="10">
- <![CDATA[
- UPDATE TBG02_SLAB_COMM_D T
- SET T.ORD_FL = '2'
- WHERE T.SLAB_NO = ?
- ]]>
- </query>
- </queryMap>
|
