| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH020030_01.select" desc="UIH020030 " fetchSize="10">
- <![CDATA[
-
- select
- a.COIL_NO --?卷?
- ,a.SLAB_NO --板??
- ,a.STL_GRD --??
- ,a.ORD_NO --合同?
- ,a.PRODNM_CD --品名
- ,a.ORD_USE_CD --??用途
- ,a.SPEC_ABBSYM --?格略?
- ,C.DEL_TO_DATE DEVLMT_DTIME --交?期
- ,C.DEL_TO_DATE devlmt_dtime --交?期
- ,a.INSTR_ROUTE --??去向
- ,a.ROUTE --?去向
- ,a.SAMPL_PICK_YN --取?采取有无
- ,a.EXTSHAPE_INSPECT_YN --外???代?
- ,b.XIN_DATE --??日
- ,b.WKSHIFT --班次
- ,b.WKGROUP --?
- ,b.WK_EMP_NO --作?者
- ,a.INSTR_COIL_THK --??厚度
- ,a.INSTR_COIL_WTH --???度
- ,a.INSTR_COIL_LEN --???度
- ,a.INSTR_COIL_WGT --??重量
-
- ,a.INSTR_COIL_INDIA --??外?
- ,a.INSTR_COIL_OUTDIA --????
- ,a.COIL_THK --??厚度
- ,a.COIL_WTH --???度
- ,a.COIL_LEN --???度
- ,a.ACT_WGT --??重量
- ,a.CAL_WGT --?算重量
- ,a.COIL_OUTDIA --外?
- ,a.COIL_INDIA --??
- ,NVL(b.RHF_DESCAL_YN,1) RHF_DESCAL_YN --除?机是否加??后
- ,b.RM_ENT_DESCAL_YN --除?机是否RM入口
- ,b.RM_EXT_DESCAL_YN --除?机是否RM出口
- ,(b.RHF_DESCAL_YN+b.RM_ENT_DESCAL_YN+b.RM_EXT_DESCAL_YN) ZONG_DESCAL_YN --总除磷次数
- ,b.RM1_PASS_CNT --R1?制道次
- ,b.RM2_PASS_CNT --R2?制道次
- ,b.R1_EXT_TEMP --R1出口?度
- ,b.R2_EXT_TEMP --R2出口?度
- ,b.RM_EXT_AVG_THK --RM出口平均厚度
- ,b.RM_EXT_AVG_WTH --RM出口平均?度
- ,b.RM_EXT_AVG_LEN --RM出口平均?度
- ,b.F1_ENT_PASS_DTIME --FM入口通??刻
- ,b.F7_ENT_PASS_DTIME --FM出口通???
- ,b.F1_ENT_TEMP_AVG --F1入口?度平均
- ,b.F1_ENT_TEMP_MAX --F1入口?度最大
- ,b.F1_ENT_TEMP_MIN --F1入口?度最小
- ,b.FM_EXT_STRIP_THK --FM出口厚度?定
- ,b.FM_EXT_STRIP_THK_AVG --FM出口厚度平均
- ,b.FM_EXT_STRIP_THK_MIN --FM出口厚度最小
- ,b.FM_EXT_STRIP_THK_MAX --FM出口厚度最大
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.FM_EXT_STRIP_THK_OUT_OF_LEN/nvl(a.COIL_LEN,0))*100,2)) FM_EXT_STRIP_THK_OUT_OF_LEN --FM出口厚度不在范?
- ,b.FM_EXT_STRIP_WTH --FM出口?度?定
- ,b.FM_EXT_STRIP_WTH_AVG --FM出口?度平均
- ,b.FM_EXT_STRIP_WTH_MIN --FM出口?度最小
- ,b.FM_EXT_STRIP_WTH_MAX --FM出口?度最大
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.FM_EXT_STRIP_WTH_OUT_OF_LEN/a.COIL_LEN)*100,2)) FM_EXT_STRIP_WTH_OUT_OF_LEN--FM出口?度不在范?i
- ,b.FM_EXT_STRIP_CROWN --FM出口凸度额定
- ,b.FM_EXT_STRIP_CROWN_AVG --FM出口凸度平均
- ,b.FM_EXT_STRIP_CROWN_MIN --FM出口凸度最小
- ,b.FM_EXT_STRIP_CROWN_MAX --FM出口凸度最大
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.FM_EXT_STRIP_CROWN_OUT_OF_LEN/a.COIL_LEN)*100,2)) FM_EXT_STRIP_CROWN_OUT_OF_LEN --FM出口凸度不在范?
- ,b.FM_SYM_STRIP_FLATNESS_AVG --??平直度平均?
- ,b.FM_SYM_STRIP_FLATNESS_MAX --??平直度最大
- ,b.FM_SYM_STRIP_FLATNESS_MIN --??平直度最小
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.FM_SYM_STRIP_OUT_OF_RANGE/a.COIL_LEN)*100,2)) FM_SYM_STRIP_OUT_OF_RANGE --??平直度不在范?
- ,b.FM_ASY_STRIP_FLATNESS_AVG --非??平直度平均?
- ,b.FM_ASY_STRIP_FLATNESS_MAX --非??平直度最大
- ,b.FM_ASY_STRIP_FLATNESS_MIN --非??平直度最小
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.FM_ASY_STRIP_OUT_OF_RANGE/a.COIL_LEN)*100,2)) FM_ASY_STRIP_OUT_OF_RANGE --非??平直度不在范?
- ,b.FM_STRIP_WDG_AVG --楔型 出口平均?
- ,b.FM_STRIP_WDG_MAX --楔型 出口最大
- ,b.FM_STRIP_WDG_MIN --楔型 出口最小
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.FM_STRIP_WDG_OUT_OF_RANGE/a.COIL_LEN)*100,2)) FM_STRIP_WDG_OUT_OF_RANGE --楔型 出口 不在范?
- ,b.FM_EXT_STRIP_TEMP --FM精轧出口温度额定
- ,b.FM_EXT_STRIP_TEMP_AVG --FM出口温度平均
- ,b.FM_EXT_STRIP_TEMP_MIN --FM出口温度最小
- ,b.FM_EXT_STRIP_TEMP_MAX --FM出口温度最大
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.STRIP_OUT_OF_RANGE/a.COIL_LEN)*100,2)) STRIP_OUT_OF_RANGE --FM出口?度不在范?
- ,b.F7_MILL_SPEED_HEAD --穿?速度
- ,b.F7_MILL_SPEED_ACC1 --?制速度ACC1
- ,b.F7_MILL_SPEED_ACC2 --?制速度ACC2
- ,b.F7_MILL_SPEED_VMAX --?制速度VMAX
- ,b.F7_MILL_SPEED_VT --?制速度VT
- ,b.DC_TEMP --额定卷取温度
- ,b.DC_TEMP_AVG --卷取温度度平均值
- ,b.DC_TEMP_MIN --卷取温度最小值
- ,b.DC_TEMP_MAX --卷取温度最大值
- ,DECODE(A.COIL_LEN,'0','0','','0',ROUND((b.DC_TEMP_OUT_OF_RANGE/a.COIL_LEN)*100,2)) DC_TEMP_OUT_OF_RANGE --卷取温度不在范围
- ,b.DC_NO --卷取机?
- ,b.DC_ON_DTIME --?始卷取?刻
- ,b.DC_OFF_DTIME --?束卷取?刻
- ,b.MISSNO_CLF_CD --REJECT?分代?
- ,(select SM_CFNM MISSNO_CAUSE_CD from TBZ00_COMMCD where lg_cd = A.MISSNO_CAUSE_QY AND SM_CD = b.MISSNO_CAUSE_CD) MISSNO_CAUSE_CD --REJECT理由代?
- ,b.MISSNO_DTIME --REJECT?生??
- ,b.missno_bar_thk --废弃的宽厚重
- ,b.missno_bar_wth
- ,b.missno_bar_wgt
- ,a.old_sampl_no
- ,A.MISSNO_CAUSE_QY
- from TBH02_MILL_RESULT b,
- TBH02_COIL_COMM a
- ,TBE02_ORD_PRC C
- where a.coil_no = b.coil_no(+)
- AND A.ORD_NO = C.ORD_NO(+)
- AND A.ORD_SEQ = C.ORD_SEQ(+)
- and NVL(a.coil_no,' ') like ?||'%'
- and NVL(a.SLAB_NO,' ') like ?||'%'
- and NVL(a.OLD_SAMPL_NO,' ') like ?||'%'
- AND rownum = 1
- ]]>
- </query>
- <query id="UIH020030_02.select" desc="init " fetchSize="10">
- <![CDATA[
- select distinct yard_clf LABEL,yard_clf VALUE from tbh05_coil_yard where substr(yard_clf,0,4) = ?
- ]]>
- </query>
- <query id="UIH020030_03.select" desc="查询入炉状态，为2的可以进行轧制操作" fetchSize="10">
- <![CDATA[
- select RHF_STAT from tbh02_reheatfur where slab_no = ? and coil_no = ?
- ]]>
- </query>
- <query id="UIH020030_INIT.select" desc="去掉行数显示限制 " fetchSize="10">
- <![CDATA[
-
- SELECT COIL_NO LABEL
- ,COIL_NO VALUE
- FROM TBH02_COIL_COMM
- WHERE COIL_STAT = '1' OR COIL_STAT = '2'
- order by coil_no,COIL_STAT
- ]]>
- </query>
- <query id="UIH020030_EMP.select" desc="init " fetchSize="10">
- <![CDATA[
-
- SELECT EMP_NM label
- ,EMP_NM value
- FROM TBZ01_FAC_EMP_GROUP
- WHERE GROUP_CD = ?
- AND PROC_CD = 'RC'
- AND FAC_CD = 'R'
-
- ]]>
- </query>
-
- <query id="NIH020030_REJ_CD.select" desc="把Z05003换成H02001用做废弃理由代码 " fetchSize="10">
- <![CDATA[
-
- SELECT SM_CFNM label
- ,SM_CD value
- FROM TBZ00_COMMCD
- WHERE LG_CD = ?
- ]]>
- </query>
-
- <query id="UIH020030_SPEC_MILL.select" desc="在轧制表中只用到了 ORD_NO、ORD_SEQ，这里修改了为加热炉出炉使用 " fetchSize="10">
- <![CDATA[
- SELECT STL_GRD
- ,SPEC_ABBSYM
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_USEAGE_CD
- ,PRODNM_CD
- ,ORD_CUST_CD
- ,DELV_REQ_DATE
- ,PATH_MILL_CD
- ,PACK_METHOD
- ,ORD_INDIA
- ,ORD_OUTDIA
- ,ORD_THK
- ,ORD_WTH
- ,ORD_WGT
- ,DEST_CD
- ,ROUTE -- 去向
- ,SPM_PROC_YN --平整分卷指定判断
- ,SLAB_EDT_SEQ --板坯编制号
- ,CUST_CD --轧制使用
- ,STATUS_CD
- FROM TBF02_SPEC_MILL
- WHERE COIL_NO = ?
-
- ]]>
- </query>
-
- <query id="UIH020030_MILL.update" desc="init " fetchSize="10">
- <![CDATA[
-
- UPDATE TBH02_MILL_RESULT SET
- XIN_DATE = ?
- ,WKSHIFT = ?
- ,WKGROUP = ?
- ,WK_EMP_NO = ?
- ,FM_EXT_STRIP_THK = ?
- ,FM_EXT_STRIP_WTH = ?
- ,COIL_LEN = ?
- ,COIL_WGT = NVL(COIL_WGT , ?)
- ,COIL_OUTDIA = ?
- ,COIL_INDIA = ?
- ,DC_NO = ?
- ,DC_ON_DTIME = ?
- ,DC_OFF_DTIME = ?
- ,MISSNO_CLF_CD = ?
- ,MISSNO_CAUSE_CD = ?
- ,MISSNO_DTIME = ?
- ,SLAB_NO = ?
- ,MISSNO_BAR_THK = ?
- ,MISSNO_BAR_WTH = ?
- ,MISSNO_BAR_WGT = ?
- ,MILL_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,WK_EMP_USE_NO = ?
- ,WK_EMP_USE_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,MISSNO_CAUSE_QY = ?
- WHERE
- COIL_NO = ?
-
- ]]>
- </query>
- <query id="UIH020030_COIL.update" desc="init " fetchSize="10">
- <![CDATA[
-
- UPDATE TBH02_COIL_COMM SET
- SLAB_NO = ?
- ,COIL_STAT = ?
- ,Cur_Prog_Cd_Dtime = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,CUR_PROG_CD_PGM = 'PosSaveMillResult'
- ,BEF_PROG_CD = CUR_PROG_CD
- ,Bef_Prog_Cd_Dtime = Cur_Prog_Cd_Dtime
- ,BEF_PROG_CD_PGM = CUR_PROG_CD_PGM
- ,MILL_DTIME = ? --轧钢时间
- ,COIL_THK = ?
- ,COIL_WTH = ?
- ,COIL_LEN = ?
- ,ACT_WGT = NVL(ACT_WGT,?)
- ,CAL_WGT = ?
- ,COIL_OUTDIA = ?
- ,COIL_INDIA = ?
- ,MISSNO_CLF_CD = ?
- ,MISSNO_CAUSE_CD = ?
- ,MISSNO_DTIME = ?
- ,CUR_PROG_CD = ?
- ,COIL_CRE_DTIME = ?
- ,COIL_END_DTIME = ?
- ,MISSNO_CAUSE_QY = ?
-
- WHERE COIL_NO = ?
- ]]>
- </query>
-
- <query id="UIH020030_SLAB_END.update" desc="init " fetchSize="10">
- <![CDATA[
-
- UPDATE TBG02_SLAB_COMM set
- SLAB_STAT = '3'
- ,MATRL_END_CAUSE_CD = '1'
- ,MATRL_END_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- WHERE SLAB_NO = ?
-
- ]]>
- </query>
-
- <query id="UIH020030_MILL.insert" desc="init " fetchSize="10">
- <![CDATA[
-
- INSERT INTO TBH02_MILL_RESULT
- ( COIL_NO
- ,SLAB_NO
- ,XIN_DATE
- ,WKSHIFT
- ,WKGROUP
- ,WK_EMP_NO
- ,FM_EXT_STRIP_THK
- ,FM_EXT_STRIP_WTH
- ,COIL_LEN
- ,COIL_WGT
- ,COIL_OUTDIA
- ,COIL_INDIA
- ,DC_NO
- ,DC_ON_DTIME
- ,DC_OFF_DTIME
- ,MISSNO_CLF_CD
- ,MISSNO_CAUSE_CD
- ,MISSNO_DTIME
- ,MISSNO_BAR_THK
- ,MISSNO_BAR_WTH
- ,MISSNO_BAR_WGT
- ,WK_EMP_USE_NO
- ,WK_EMP_USE_DTIME
- ,MILL_DTIME
- ,MISSNO_CAUSE_QY
- )
- VALUES
- (
- ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,?
- )
-
- ]]>
- </query>
-
- <query id="UIH020030_COIL.insert" desc="init " fetchSize="10">
- <![CDATA[
-
- INSERT INTO TBH02_COIL_COMM
- ( COIL_NO
- ,SLAB_NO
- ,MILL_DTIME
- ,STL_GRD
- ,SPEC_ABBSYM
- ,ORD_NO
- ,ORD_SEQ
- ,ORD_USE_CD
- ,PRODNM_CD
- ,ORD_FL
- ,COIL_THK
- ,COIL_WTH
- ,COIL_LEN
- ,ACT_WGT
- ,CAL_WGT
- ,COIL_OUTDIA
- ,COIL_INDIA
- ,MISSNO_CLF_CD
- ,MISSNO_CAUSE_CD
- ,MISSNO_DTIME
- ,SPM_YN
- ,DEVLMT_DTIME
- ,ORDCUST_CD
- ,PATH_MILL_CD
- ,PACK_METHOD_CD
- ,INSTR_COIL_INDIA
- ,INSTR_COIL_OUTDIA
- ,INSTR_COIL_THK
- ,INSTR_COIL_WTH
- ,INSTR_COIL_WGT
- ,DEST_CD
- ,CUR_PROG_CD
- ,CUR_PROG_CD_DTIME
- ,CUR_PROG_CD_PGM
- ,EXTSHAPE_DEC_GRD
- ,COIL_CRE_DTIME
- ,COIL_END_DTIME
- ,COIL_STAT
- ,SPEC_STL_GRD
- ,MISSNO_CAUSE_QY
- )
- VALUES
- ( ?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,'SED'
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- ,'PosSaveMillResult'
- ,'1'
- ,?
- ,?
- ,?
- ,?
- ,?
- )
- ]]>
- </query>
- <query id="UIH020030_COIL_HIS.insert" desc="init " fetchSize="10">
- <![CDATA[
-
- INSERT INTO C_TBC02_COIL_COMM_HIS
- (PROD_LINE,
- MATERIAL_NO,
- HIS_FLAG,
- CUR_PROG_CD,
- CUR_PROG_CD_DTIME,
- CUR_PROG_CD_PGM,
- COIL_LEN,
- COIL_INDIA,
- COIL_OUTDIA,
- CAL_WGT,
- COIL_THK,
- COIL_WTH,
- ACT_WGT,
- ORD_FL,
- ORD_NO,
- ORD_SEQ,
- PRODNM_CD,
- SPEC_ABBSYM,
- SPEC_STL_GRD,
- ORD_USE_CD,
- STL_GRD,
- MILL_DTIME,
- REG_ID,
- REG_DTIME,
- UPDATE_FLAG)
- SELECT 'R',
- T.OLD_SAMPL_NO,
- '实绩录入',
- T.CUR_PROG_CD,
- T.CUR_PROG_CD_DTIME,
- T.CUR_PROG_CD_PGM,
- T.COIL_LEN,
- T.COIL_INDIA,
- T.COIL_OUTDIA,
- T.CAL_WGT,
- T.COIL_THK,
- T.COIL_WTH,
- T.ACT_WGT,
- T.ORD_FL,
- T.ORD_NO,
- T.ORD_SEQ,
- T.PRODNM_CD,
- T.SPEC_ABBSYM,
- T.SPEC_STL_GRD,
- T.ORD_USE_CD,
- T.STL_GRD,
- T.MILL_DTIME,
- ?,
- TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'),
- '修改前'
- FROM TBH02_COIL_COMM T
- WHERE T.COIL_NO = ?
- ]]>
- </query>
-
- <query id="UIH020030_COIL_HIS2.insert" desc="init " fetchSize="10">
- <![CDATA[
-
- INSERT INTO C_TBC02_COIL_COMM_HIS
- (PROD_LINE,
- MATERIAL_NO,
- HIS_FLAG,
- COIL_LEN,
- COIL_OUTDIA,
- COIL_THK,
- COIL_WTH,
- ACT_WGT,
- REG_ID,
- REG_DTIME,
- UPDATE_FLAG)
- values
- ('R',
- ?,
- '实绩修改',
- ?,
- ?,
- ?,
- ?,
- ?,
- ?,
- TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS'),
- '修改后')
- ]]>
- </query>
- </queryMap>
|
