| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="炼钢工序类别作业所需时间标准">
- <query id="UIF012070_CHARGE_INS.find" desc=" 查询已经下发开始生产的炉次信息 " fetchSize="10">
- <![CDATA[
- /*查查询转炉信息*/
- SELECT B.CAST_MANA_NO,/* 浇次管理号*/
- B.CHARGE_RT, /*炉次去向*/
- B.CAST_CHARGE_SEQ,/* 浇次内顺序*/
- A.PRC_LINE ,/*转炉号*/
- B.CHARGE_MANA_NO ,/* 炉次管理号*/
- B.STL_GRD,/*钢号*/
- B.PREV_CHARGE_WGT ,/* 预定出钢量*/
- B.LINE_PROC_CD ,/* 处理路径代码*/
- E.INSTR_RT, /*指示BOF处理路径*/
- B.CCM_THK,/* 浇铸厚度*/
- B.CCM_WTH ,/* 浇铸宽度*/
- B.ORD_SLAB_CNT,/* 订单板坯块数*/
- B.NONORD_SLAB_CNT,/* 余材板坯块数*/
- B.PRE_BOF_STR_DTIME,/* 计划出钢开始*/
- T1.SM_CFNM PROG_CD,/* 进程代码*/
- A.STATUS_CD , /*状态区分*/
- T3.SM_CFNM STATUS_CFNM,/* 状态区分*/
- T2.SM_CFNM HCR_CLF,/* 热送代*/
- A.L2_SEND,/* L2传送*/
- B.MILL_FL,/* 轧制编制区分*/
- B.CHARGE_EDT_SEQ,/* 炉次编制号*/
- C.RTN_CHARGE_CLF,/* 回送代码*/
- DECODE(D.DSN_KIND,'1','Y','') DSN_KIND /*客户特殊要求*/
- FROM TBF01_CHARGE_IDX A,
- TBF01_SPEC_CHARGE B,
- tbg02_charge_comm C,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3,
- (SELECT DISTINCT B.CHARGE_MANA_NO,C.DSN_KIND
- FROM TBF01_SPEC_CHARGE A
- ,TBF01_SPEC_SLAB B
- ,TBB01_ORD_INGR C
- WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ
- AND B.ORD_NO = C.ORD_NO
- AND B.ORD_SEQ = C.ORD_SEQ
- AND A.STATUS_CD IN ('A','B')
- AND C.DSN_KIND = '1') D,
- ------------------------
- (SELECT TT.PLAN_CHARGE_NO,TT.INSTR_RT
- FROM TBG02_CHARGE_COMM TT
- WHERE TT.CHARGE_STAT IN ('1','2')
- ) E
- WHERE 'B' = 'B'
- AND A.STATUS_CD = 'B'
- AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ /*炉次编制号*/
- AND B.CHARGE_MANA_NO = C.NEW_PLAN_CHARGE_NO(+) /*炉次管理号*/
- AND B.PROG_CD = T1.SM_CD /*进程代码*/
- AND B.HCR_CLF = T2.SM_CD /*热送代码*/
- AND B.STATUS_CD = T3.SM_CD /*状态区分*/
- AND B.CHARGE_MANA_NO = D.CHARGE_MANA_NO(+)
- AND B.CHARGE_MANA_NO = E.PLAN_CHARGE_NO
- ORDER BY A.CHG_SEQ ASC
- ]]>
- </query>
- <query id="UIF012070_ST_PROC.find" desc="查询各作业路线信息" fetchSize="10">
- <![CDATA[
- SELECT '' CHK
- ,SM_CD
- ,SM_CFNM
- ,CD_SEQ
- FROM TBZ00_COMMCD WHERE LG_CD LIKE 'G02003%'
- ]]>
- </query>
- <query id="UIF012070_CHCK_PROC.find" desc="作业路线线路信息" fetchSize="10">
- <![CDATA[
- SELECT T.SM_CD FROM TBZ00_COMMCD T
- WHERE T.LG_CD = 'F01004'
- AND T.SM_CFNM = ? /*查询作业线路对应的代码*/
- ]]>
- </query>
- <query id="UIF012070_UPDATE_PROC.insert" desc="查询各连铸机浇铸时间标准" fetchSize="10">
- <![CDATA[
- begin
- INSERT INTO TBG06_L2_CHARGE_INS
- (SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,SEND_SEQ
- ,SEND_RESERV
- ,SEND_CLF
- ,PLAN_CHARGE_NO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,STL_GRD
- ,SPEC_ABBSYM
- ,PLAN_CHARGE_WGT
- ,HM_STR_DTIME
- ,BLOW_STR_DTIME
- ,PRE_BOF_STR_DTIME
- ,PRE_BOF_END_DTIME
- ,PRE_CAS_STR_DTIME
- ,PRE_CAS_END_DTIME
- ,PRE_RH_STR_DTIME
- ,PRE_RH_END_DTIME
- ,PRE_LF_STR_DTIME
- ,PRE_LF_END_DTIME
- ,TREAT_RT_CD
- ,BOF_TEMP_TGT
- ,CAS_TEMP_TGT
- ,RH_TEMP_TGT
- ,LF_TEMP_TGT)
- SELECT SEND_SEQ + ROWNUM SEQ_NO -- SEQ_NO
- ,MSG_FLAG
- ,TC_ID
- ,TRANS_DTIME
- ,LPAD(TO_CHAR(SEND_SEQ + ROWNUM),4,'0') -- SEND_SEQ
- ,SEND_RESERV
- ,'U' SEND_CLF
- ,PLAN_CHARGE_NO
- ,CAST_NO
- ,CAST_EDT_CHARGE_CNT
- ,CAST_CHARGE_SEQ
- ,STL_GRD
- ,SPEC_ABBSYM
- ,PLAN_CHARGE_WGT
- ,HM_STR_DTIME
- ,BLOW_STR_DTIME
- ,PRE_BOF_STR_DTIME
- ,PRE_BOF_END_DTIME
- ,PRE_CAS_STR_DTIME
- ,PRE_CAS_END_DTIME
- ,PRE_RH_STR_DTIME
- ,PRE_RH_END_DTIME
- ,PRE_LF_STR_DTIME
- ,PRE_LF_END_DTIME
- ,TREAT_RT_CD
- ,BOF_TEMP_TGT
- ,CAS_TEMP_TGT
- ,RH_TEMP_TGT
- ,LF_TEMP_TGT
-
- FROM(
- SELECT 'N' MSG_FLAG
- ,T.TC_ID TC_ID
- ,TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') TRANS_DTIME
- ,T.SEQ_NO SEND_SEQ
- ,T.TREAT_RT_CD SEND_RESERV
- ,T.SEND_CLF SEND_CLF
- ,T.PLAN_CHARGE_NO PLAN_CHARGE_NO
- ,T.CAST_NO CAST_NO
- ,T.CAST_EDT_CHARGE_CNT CAST_EDT_CHARGE_CNT
- ,T.CAST_CHARGE_SEQ CAST_CHARGE_SEQ
- ,T.STL_GRD STL_GRD
- ,T.SPEC_ABBSYM SPEC_ABBSYM
- ,T.PLAN_CHARGE_WGT PLAN_CHARGE_WGT
- ,T.HM_STR_DTIME HM_STR_DTIME
- ,T.BLOW_STR_DTIME BLOW_STR_DTIME
- ,T.PRE_BOF_STR_DTIME PRE_BOF_STR_DTIME
- ,T.PRE_BOF_END_DTIME PRE_BOF_END_DTIME
- ,T.PRE_CAS_STR_DTIME PRE_CAS_STR_DTIME
- ,T.PRE_CAS_END_DTIME PRE_CAS_END_DTIME
- ,T.PRE_RH_STR_DTIME PRE_RH_STR_DTIME
- ,T.PRE_RH_END_DTIME PRE_RH_END_DTIME
- ,T.PRE_LF_STR_DTIME PRE_LF_STR_DTIME
- ,T.PRE_LF_END_DTIME PRE_LF_END_DTIME
- ,? TREAT_RT_CD
- ,T.BOF_TEMP_TGT BOF_TEMP_TGT
- ,T.CAS_TEMP_TGT CAS_TEMP_TGT
- ,T.RH_TEMP_TGT RH_TEMP_TGT
- ,T.LF_TEMP_TGT LF_TEMP_TGT
- FROM (
- select * from tbg06_l2_charge_ins
- where plan_charge_no = ?
- ORDER BY TRANS_DTIME DESC
- ) T
- WHERE ROWNUM = 1
- )
- WHERE SEND_CLF <> 'D'; COMMIT;
- end;
- ]]>
- </query>
-
- <query id="UIF012070_COMM_PATH_CD.find" desc="查询工序路径的信息" fetchSize="10">
- <![CDATA[
- SELECT
- t2.SM_CD
- ,T2.SM_CFNM
- FROM TBZ00_COMMCD T2
- WHERE T2.LG_CD = 'F01004'
- AND T2.SM_CFNM = :1
- ]]>
- </query>
-
- <query id="UIF012070_01.CALLSTATEMENT" desc=" 切割计划变更处理 ">
- {call pkg_sip_comm.update_ccm_instruction(?)}
- </query>
- <query id="UIF012070_02.CALLSTATEMENT" desc=" 炉次计划变更处理 ">
- {call pkg_uig.PROD_STLGRD_CHG(?,?,?)}
- </query>
- <query id="UIF012070_LINE_PROC_SPEC.update" desc=" 修改作业路线 ">
- <![CDATA[
- UPDATE TBF01_SPEC_CHARGE T
- SET T.LINE_PROC_CD = (SELECT SM_CFNM FROM TBZ00_COMMCD TT WHERE TT.LG_CD = 'F01004' AND SM_CD = ?)
- WHERE T.PLAN_CHARGE_NO = ?
- ]]>
- </query>
- <query id="UIF012070_LINE_PROC_COMM.update" desc=" 修改作业路线 ">
- <![CDATA[
- UPDATE TBF01_SPEC_CHARGE T
- SET T.LINE_PROC_CD = :1
- ,TREAT_RT_CD = :2
- WHERE T.CHARGE_MANA_NO = :3
- ]]>
- </query>
- </queryMap>
|
