| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG050010_01.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT '' CHK
- ,A.ROLL_MANA_NO
- ,SUBSTR(C.OLD_SAMPL_NO,1,10) ROLL_BATCH_NO -- 批号
- ,COUNT(*) SLAB_CNT
- ,WMSYS.WM_CONCAT(DISTINCT SUBSTR(B.SLAB_NO,1,10)) CHARGE_NO
- ,WMSYS.WM_CONCAT(DISTINCT B.STL_GRD) STL_GRD
- ,WMSYS.WM_CONCAT(DISTINCT B.SLAB_THK||'*'||B.SLAB_WTH) SLAB_SIZE
- ,WMSYS.WM_CONCAT(B.SLAB_NO) SLAB_NO
- ,D.ROLL_BATCH_WGT
- ,D.REG_DTIME
- ,E.SM_CFNM SLAB_FAC
- FROM TBF02_SPEC_MILL A
- ,TBG02_SLAB_COMM B
- ,TBH02_COIL_COMM C
- ,TBG04_ROLL_TRANS D
- ,(SELECT T.SM_CFNM ,TT.SLAB_NO FROM TBZ00_COMMCD T
- ,TBG02_SLAB_COMM TT
- WHERE T.LG_CD = 'B01132' AND T.SM_CD = SUBSTR(TT.SLAB_NO,3,1))E
- WHERE '1' = '1'
- AND A.SLAB_NO = B.SLAB_NO(+)
- AND A.COIL_NO = C.COIL_NO
- AND SUBSTR(C.OLD_SAMPL_NO,1,10) = D.ROLL_BATCH_NO(+)
- AND B.SLAB_NO = E.SLAB_NO
- AND A.ROLL_MANA_NO LIKE nvl(?,'NULL')||'%'
- GROUP BY A.ROLL_MANA_NO,SUBSTR(C.OLD_SAMPL_NO,1,10),D.ROLL_BATCH_WGT,E.SM_CFNM,D.REG_DTIME
- ORDER BY A.ROLL_MANA_NO DESC,SUBSTR(C.OLD_SAMPL_NO,1,10) ASC
- ]]>
- </query>
- <query id="UIG050010_01.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG04_ROLL_TRANS T
- SET T.ROLL_BATCH_WGT = ?
- ,REG_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- WHERE T.ROLL_NO = ?
- AND T.ROLL_BATCH_NO = ?
- ]]>
- </query>
- <query id="UIG050010_01.insert" desc=" " fetchSize="10">
- <![CDATA[
- insert into TBG04_ROLL_TRANS
- ( ROLL_BATCH_WGT,ROLL_NO,ROLL_BATCH_NO,REG_DTIME)
- values(?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'))
- ]]>
- </query>
- </queryMap>
|
