| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS MONITORING ">
- <query id="UIG030040_LD_INFO.select" desc="获得中间包等待信息">
- <![CDATA[
- SELECT ''CHK
- ,LD_NO
- ,CURR_CHARGE_NO
- ,LD_STAT
- ,LD_GRADE
- ,LD_CUR_FORM_BDLG
- ,nvl(LD_CUR_FORM_BKJZ_YN,'N') LD_CUR_FORM_BKJZ_YN
- ,LD_CUR_FORM_BKDZ
- ,LD_ROAST_STAT_DTIME
- ,LD_ROAST_END_DTIME
- ,LD_ROAST_STATION_ID
- ,LD_ACCESSORY
- ,LD_CUR_LOC
- ,CCM_DEP_DTIME
- ,BOF_IN_DTIME
- ,'' LD_MODFY
- ,CURR_CHARGE_NO
- ,LD_FAC
- ,LD_TQ_FAC
- FROM TBG03_LADLE_PROG
- WHERE LD_NO LIKE 'R%'
- ORDER BY LD_STAT ASC,LD_NO ASC
- ]]>
- </query>
- <query id="UIG030041_LD_INFO.select" desc="获得待机结晶器信息">
- <![CDATA[
- SELECT LD_NO LABEL,LD_NO VALUE FROM TBG03_LADLE_PROG
- WHERE LD_NO LIKE 'R%'
- AND LD_STAT = '1'
- ]]>
- </query>
- <query id="UIG030041_CHARGE_READY.select" desc="获得待机结晶器信息">
- <![CDATA[
- SELECT A.CHARGE_NO,B.LD_NO FROM TBG03_SMS_TRACKING A
- ,TBG02_CHARGE_COMM B
- WHERE A.CHARGE_NO = B.CHARGE_NO
- AND A.TREAT_CD = 'B1'
- AND B.LD_NO IS NULL
- ]]>
- </query>
- <query id="UIG030041_CHARGE_INFO.select" desc="获得待机结晶器信息">
- <![CDATA[
- SELECT CHARGE_NO LABEL,CHARGE_NO VALUE,CHARGE_STAT FROM TBG02_CHARGE_COMM T
- WHERE T.CHARGE_STAT <> '3'
- ]]>
- </query>
- </queryMap>
|
