| 12345678910111213141516171819202122232425 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG020700_LD_WGT.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT (SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD LIKE 'Z05001' AND SM_CD = A.WKSHIFT) WKSHIFT
- ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD LIKE 'Z05002' AND SM_CD = A.WKGROUP) WKGROUP
- ,B.STL_GRD
- ,A.CHARGE_NO
- ,A.CC_DEVNO
- ,NVL(A.STLMELT_WGT,0) STLMELT_WGT
- ,NVL(A.CC_END_STLMELT_USE_WGT,0) CC_END_STLMELT_USE_WGT
- ,NVL(A.REM_WGT_IN_TD,0) REM_WGT_IN_TD
- ,DECODE(A.LD_OPEN_DTIME,'',(SELECT MAX(T.TREAT_DTIME) FROM TBG03_STLMAKE_PROG T WHERE T.TREAT_CD = 'J02' AND T.CHARGE_NO = A.CHARGE_NO)) LD_OPEN_DTIME
- ,DECODE(A.LD_CLOSE_DTIME,'',(SELECT MAX(T.TREAT_DTIME) FROM TBG03_STLMAKE_PROG T WHERE T.TREAT_CD = 'J03' AND T.CHARGE_NO = A.CHARGE_NO)) LD_CLOSE_DTIME
- ,'' REMARK
- FROM TBG02_CC_RESULT A
- ,TBG02_CHARGE_COMM B
- WHERE A.CHARGE_NO = B.CHARGE_NO
- AND SUBSTR(B.CASTING_END_DTIME,1,8) BETWEEN NVL(?,'00000000') AND NVL(?,40000000)
- AND A.CC_DEVNO LIKE ?||'%'
- AND A.WKSHIFT||'&' LIKE ?||'%'
- AND A.WKGROUP||'&' LIKE ?||'%'
- ]]>
- </query>
- </queryMap>
|
