| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS MONITORING ">
- <query id="UIG020900_01.select" desc=" 取板坯运送前的信息，此时板坯在我方数据库。 ">
- <![CDATA[
- /*select a.SLAB_CUT_DTIME,
- C.REG_DTIME,
- A.SLAB_CUT_DTIME - c.REG_DTIME,
- a.SLAB_TOT_DEC_GRD,
- a.CAST_NO,
- a.ORD_NO || '-' || a.ORD_SEQ ord_no,
- a.CHARGE_NO,
- a.SLAB_NO,
- c.STL_GRD BEF_STL_GRD,
- a.STL_GRD,
- a.SLAB_THK,
- a.SLAB_WTH,
- a.SLAB_LEN,
- a.SLAB_WGT,
- C.LINE_PROC_CD,
- instr(c.LINE_PROC_CD,'L') LF,
- INSTR(C.LINE_PROC_CD,'R') RH,
- A.SLAB_INGR_DEC_DTIME,
- A.SLAB_INGR_DEC_GRD,
- A.SMS_YARD_EXT_DTIME,
- C.REG_DTIME MOD_DTIME,
- d.DEL_TO_DATE,
- a.SLAB_RT,
- b.CC_DEVNO,
- a.CUT_WKGROUP,
- a.NONORD_CAUSE_CD,
- a.EXTSHAPE_GRD,
- a.SLAB_INGR_DEC_KIND,
- a.SLAB_INGR_DEC_GRD,
- a.HCR_CLF,
- e.INGR_DEC_GRD,
- a.NONORD_CAUSE_CD
-
- from tbg02_slab_comm a,
- tbg02_charge_comm b,
- tbf01_spec_charge c,
- tbe02_ord_prc d,
- tbg02_charge_comm_d e,
- (select slabcmm.ORD_NO || slabcmm.ORD_SEQ,
- slabspec.ORD_NO || slabspec.ORD_SEQ,
- slabspec.STL_GRD,
- slabcmm.STL_GRD,
- slabcmm.SLAB_NO,
- 'Y' noord_yn
- from tbg02_slab_comm slabcmm,
- tbf01_spec_slab slabspec
- where slabcmm.PLAN_SLAB_NO = slabspec.SLAB_MANA_NO
- and slabcmm.ORD_NO || slabcmm.ORD_SEQ <> slabspec.ORD_NO||slabspec.ORD_SEQ )g
- where a.SLAB_NO = g.slab_no(+)
- and a.ORD_NO = d.ORD_NO(+)
- and a.ORD_SEQ = d.ORD_SEQ(+)
- and substr(a.SLAB_NO,1,10) = b.CHARGE_NO
- and b.PLAN_CHARGE_NO = c.CHARGE_MANA_NO
- and b.CHARGE_NO = e.SUB_CHARGE_NO
-
- AND substr(A.SLAB_CUT_DTIME,1,8) >= :1
- AND substr(A.SLAB_CUT_DTIME,1,8) <= :2
- and A.SLAB_CUT_DTIME - c.REG_DTIME > :3*1000000
- and b.CC_DEVNO like :4||'%'
- and a.CAST_NO like :5||'%'
- and a.ORD_NO like :6||'%'
- and b.CHARGE_NO like :7||'%'
- and a.SLAB_NO like :8||'%'
- and a.SLAB_TOT_DEC_GRD like :9||'%'
- and a.SLAB_RT like :10||'%'
- and a.NONORD_CAUSE_CD like :11||'%'
- AND instr(c.LINE_PROC_CD,:12)>'0'
- AND A.SLAB_WTH >= :13 AND A.SLAB_WTH <= :14
- AND c.STL_GRD LIKE :15||'%'
- AND B.INGR_DEC_GRD LIKE :16||'%'*/
-
- SELECT A.SLAB_CUT_DTIME
- ,A.CAST_NO
- ,A.ORD_NO
- ,SUBSTR(A.SUB_SLAB_NO,1,10) CHARGE_NO
- ,A.SLAB_NO
- ,f.STL_GRD BEF_STL_GRD
- ,A.STL_GRD
- ,NVL(B.L2_STEELCODE,G.H_SPEC_STL_GRD) SPEC_STL_GRD
- ,A.SLAB_THK
- ,A.SLAB_WTH
- ,A.SLAB_LEN
- ,A.SLAB_WGT
- ,A.SLAB_INGR_DEC_DTIME
- ,A.SLAB_TOT_DEC_GRD
- ,A.SMS_YARD_EXT_DTIME
- ,f.REG_DTIME
- ,A.SLAB_RT
- ,decode(A.CUT_WKGROUP,'A','甲班','B','乙班','C','丙班','D','丁班') CUT_WKGROUP
- ,decode(A.EXTSHAPE_GRD,'1','合格','2','不合格') EXTSHAPE_GRD
- ,(SELECT SM_CFNM FROM TBZ00_COMMCD WHERE SM_CD = A.SLAB_INGR_DEC_KIND AND LG_CD = 'B01133') SLAB_INGR_DEC_KIND
- ,A.SLAB_INGR_DEC_GRD INGR_DEC_GRD
- ,decode(A.HCR_CLF,'H','热送','C','冷送')HCR_CLF
- ,decode(PKG_G_QUERY.FIG010_NOORDER(A.SLAB_NO),'N','否','Y','是') NOORDER
- ,(select sm_cfnm from tbz00_commcd where lg_cd like 'E01010%' and sm_cd = A.NONORD_CAUSE_CD)NONORD_CAUSE_CD
- ,G.DEL_TO_DATE
- ,E.CC_DEVNO
- ,(select TO_DATE( A.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS') - TO_DATE( f.REG_DTIME,'YYYY-MM-DD HH24:MI:SS') from dual) CJHQ
- ,A.CUR_LOAD_LOC
- ,B.L2_SCH_NO
- FROM TBG02_SLAB_COMM A
- ,TBG02_CHARGE_COMM E
- ,TBF01_SPEC_SLAB F
- ,TBE02_ORD_PRC G
- ,TBD01_SLABDN_OBJ2 B
- --,TBD01_SLABDN_OBJ2_DETAIL C
- WHERE '1' = '1'
- AND A.PLAN_SLAB_NO = F.SLAB_MANA_NO(+)
- and a.ORD_NO = g.ORD_NO(+)
- and a.ORD_SEQ = g.ORD_SEQ(+)
- AND SUBSTR(A.SUB_SLAB_NO,1,10) = E.CHARGE_NO
- AND A.DSN_SLAB_NO = B.DSN_SLAB_NO(+)
- --AND B.DSN_SLAB_NO = C.DSN_SLAB_NO(+)
-
- and (select TO_DATE( A.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS') - TO_DATE( f.REG_DTIME,'YYYY-MM-DD HH24:MI:SS') from dual) > :1
- AND substr(A.SLAB_CUT_DTIME,1,8) >= :2
- AND substr(A.SLAB_CUT_DTIME,1,8) <= :3
- AND E.CC_DEVNO||'&' LIKE :4||'%'
- AND A.CAST_NO LIKE :5||'%'
- AND A.ORD_NO||'&' LIKE :6||'%'
- AND A.CHARGE_NO LIKE :7||'%'
- AND A.SLAB_NO LIKE :8||'%'
- AND A.SLAB_RT||'&' LIKE :9||'%'
- AND A.NONORD_CAUSE_CD||'&' LIKE :10||'%'
- -------------------------------------------
- AND A.SLAB_TOT_DEC_GRD||'&' LIKE :11||'%'
- AND A.SLAB_STAT LIKE :12||'%'
- AND A.STL_GRD LIKE :13||'%'
- AND E.CC_DEVNO LIKE :14||'%'
- AND B.L2_SCH_NO||'&' LIKE :15||'%'
- AND A.SLAB_THK BETWEEN :16 AND :17
- AND A.SLAB_WTH BETWEEN :18 AND :19
- ]]>
- </query>
- </queryMap>
|
