| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="订单进程详细信息查询">
- <query id="UIE013020.OrdPrc.Select" desc="" fetchSize="10">
- <![CDATA[
- SELECT T1.L2_SCH_NO P_DSN_SLAB_NO
- ,NVL(SUM(DECODE(T1.PROC_STAT,'07',T1.SLAB_WGT)),0) WGT07 --品质设计待机(TBZ00_COMMCD WHERE LG_CD = D01007)
- ,NVL(SUM(DECODE(T1.PROC_STAT,'01',T1.SLAB_WGT)),0) WGT01 --等待设计
- ,NVL(SUM(DECODE(T1.PROC_STAT,'02',T1.SLAB_WGT)),0) WGT02 --板坯设计
- ,NVL(SUM(DECODE(T1.PROC_STAT,'03',T1.SLAB_WGT)),0) WGT03 --炉次浇次设计
- ,NVL(SUM(DECODE(T1.PROC_STAT,'04',T1.SLAB_WGT)),0) WGT04 --出钢指示
- ,NVL(SUM(DECODE(T1.PROC_STAT,'05',T1.SLAB_WGT)),0) WGT05 --生产完成
- ,NVL(SUM(DECODE(T1.PROC_STAT,'06',T1.SLAB_WGT)),0) WGT06 --移送至中厚板
-
- FROM TBD01_SLABDN_OBJ2 T1
- WHERE T1.L2_SCH_NO LIKE :1||'%'
- AND T1.ORD_NO||'&' LIKE :2||'%'
- AND T1.ORD_SEQ||'&' LIKE :3||'%'
- AND T1.FAC_STL_GRD LIKE :4||'%'
- GROUP BY T1.L2_SCH_NO
- ]]>
- </query>
- <query id="UIE013020.OrdPrcDet.Select" desc="" fetchSize="10">
- <![CDATA[
- SELECT MAT_NO
- ,P_DSN_SLAB_NO
- ,STL_GRD
- ,ORD_NO
- ,ORD_SEQ
- ,SLAB_STAT
- ,SLAB_THK
- ,SLAB_WTH
- ,SLAB_LEN
- ,SLAB_WGT
- ,SEQ
- FROM (
- SELECT T1.DSN_SLAB_NO MAT_NO
- ,T1.P_DSN_SLAB_NO P_DSN_SLAB_NO
- ,T1.FAC_STL_GRD STL_GRD
- ,T1.ORD_NO ORD_NO
- ,T1.ORD_SEQ ORD_SEQ
- ,T1.PROC_STAT SLAB_STAT
- ,T1.SLAB_THK SLAB_THK
- ,T1.SLAB_WTH SLAB_WTH
- ,T1.SLAB_LEN SLAB_LEN
- ,T1.SLAB_WGT SLAB_WGT
- ,'01' SEQ
- FROM TBD01_SLABDN_OBJ2 T1
- WHERE T1.PROC_STAT IN ('07','01')
- UNION ALL
-
- SELECT T2.DSN_SLAB_NO MAT_NO
- ,T3.P_DSN_SLAB_NO P_DSN_SLAB_NO
- ,T2.FAC_STL_GRD STL_GRD
- ,T3.ORD_NO ORD_NO
- ,T3.ORD_SEQ ORD_SEQ
- ,T3.PROC_STAT SLAB_STAT
- ,T2.SLAB_THK SLAB_THK
- ,T2.SLAB_WTH SLAB_WTH
- ,T2.SLAB_LEN SLAB_LEN
- ,T2.SLAB_WGT SLAB_WGT
- ,'02' SEQ
- FROM TBD01_SLABDN_RST2 T2
- ,TBD01_SLABDN_OBJ2 T3
- WHERE T2.DSN_SLAB_NO = T3.DSN_SLAB_NO
- AND T3.PROC_STAT IN ('02','03')
- UNION ALL
-
- SELECT T4.SLAB_MANA_NO MAT_NO
- ,T5.P_DSN_SLAB_NO P_DSN_SLAB_NO
- ,T4.STL_GRD STL_GRD
- ,T5.ORD_NO ORD_NO
- ,T5.ORD_SEQ ORD_SEQ
- ,T5.PROC_STAT SLAB_STAT
- ,T4.SLAB_THK SLAB_THK
- ,T4.SLAB_WTH SLAB_WTH
- ,T4.SLAB_LEN SLAB_LEN
- ,T4.SLAB_WGT SLAB_WGT
- ,'03' SEQ
- FROM TBF01_SPEC_SLAB T4
- ,TBD01_SLABDN_OBJ2 T5
- WHERE T4.DSN_SLAB_NO = T5.DSN_SLAB_NO
- AND T5.PROC_STAT = '04'
- AND T4.STATUS_CD IN ('A','B')
- UNION ALL
-
- SELECT T6.SLAB_NO MAT_NO
- ,T7.P_DSN_SLAB_NO P_DSN_SLAB_NO
- ,T6.STL_GRD STL_GRD
- ,T7.ORD_NO ORD_NO
- ,T7.ORD_SEQ ORD_SEQ
- ,T7.PROC_STAT SLAB_STAT
- ,T6.SLAB_THK SLAB_THK
- ,T6.SLAB_WTH SLAB_WTH
- ,T6.SLAB_LEN SLAB_LEN
- ,T6.SLAB_WGT SLAB_WGT
- ,'04' SEQ
- FROM TBG02_SLAB_COMM T6
- ,TBD01_SLABDN_OBJ2 T7
- WHERE T6.DSN_SLAB_NO = T7.DSN_SLAB_NO
- AND T7.PROC_STAT IN ('05','06')
- AND T6.SLAB_STAT IN ('2','3')
- ) A
- WHERE '1' = '1'
- AND A.P_DSN_SLAB_NO = :1
- AND A.ORD_NO||'&' LIKE :2||'%'
- AND A.ORD_SEQ||'&' LIKE :3||'%'
- AND A.STL_GRD||'&' LIKE :4||'%'
- AND A.SLAB_STAT||'&' LIKE :5||'%'
- ORDER BY SEQ,MAT_NO,SLAB_STAT
- ]]>
- </query>
- </queryMap>
|
