| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="出钢参数接收现况分析(中厚板)">
- <query id="UIF013050.find" desc="冶炼计划情况汇总表" fetchSize="10">
- <![CDATA[
- /*
- select DISTINCT C.REG_DTIME --下发时间
- ,C.CAST_MANA_NO --浇次管理号
- ,C.CAST_EDT_SEQ --浇次内顺序
- ,c.ORD_THK --订单厚度
- ,c.ORD_WTH --订单宽度
- ,C.CHARGE_MANA_NO --转炉炉号
- ,b.STL_GRD --厂内牌号
- ,b.PREV_CHARGE_WGT--预定出钢量
- ,a.reg_dtime --实际炼钢时间
- ,B.INS_CHARGE_STR_DTIME --炼钢作业期限
- ,B.INS_CHARGE_END_DTIME --炼钢作业期限
- ,b.REG_ID --编制人
-
-
-
- from tbf01_spec_charge b
- ,TBG02_CHARGE_COMM A
- ,tbf01_spec_slab c
- ,tbe02_ord_prc d
- ,tba01_ord_line e
- where '1' = '1'
- AND A.PLAN_CHARGE_NO = B.CHARGE_MANA_NO
- and b.CHARGE_MANA_NO = c.CHARGE_MANA_NO
- and c.CHARGE_MANA_NO = b.CHARGE_MANA_NO
- and c.ORD_NO = d.ORD_NO(+)
- and c.ORD_SEQ = d.ORD_SEQ(+)
- and d.ORD_NO = e.ORD_NO
- and d.ORD_SEQ = e.ORD_SEQ
- and C.REG_DTIME between :1||'000000' and :2||'999999'
- and nvl(c.ord_no,' ') = nvl(:3,nvl(c.ORD_NO,' '))
- and nvl(c.ord_seq,' ') = nvl(:4,nvl(c.ORD_seq,' '))
- and d.DEL_TO_DATE between nvl(:5,00000000) and nvl(:6,99999999)
- and e.SPEC_STL_GRD = nvl(:7,e.SPEC_STL_GRD)
- and c.ORD_FL = nvl(:8,c.ORD_FL)
- and c.ORD_WTH = nvl(:9,c.ORD_WTH)
- and c.SLAB_RT = nvl(:10,c.SLAB_RT)
- */
-
- SELECT AA.REG_DTIME --下发时间
- ,AA.CAST_MANA_NO --浇次管理号
- ,AA.CAST_CHARGE_SEQ --浇次内顺序
- ,CC.ORD_NO --合同号
- ,CC.ORD_SEQ --订单号
- ,BB.SLAB_THK
- ,BB.SLAB_WTH
- ,CC.SPEC_STL_GRD
- ,AA.CHARGE_MANA_NO --转炉炉号
- ,AA.STL_GRD --厂内牌号
- ,AA.PREV_CHARGE_WGT--预定出钢量
- ,AA.REG_DTIME --实际炼钢时间
- ,AA.INS_CHARGE_STR_DTIME --炼钢作业期限
- ,AA.INS_CHARGE_END_DTIME --炼钢作业期限
- ,AA.REG_ID --编制人
- ,BB.ORD_WGT1 --订单材重量
- ,BB.ORD_WGT2 --余材重量
- ,BB.SLAB_RT --产线
- ,CC.XSQY
- ,CC.DEL_TO_DATE --交货期
- ,CC.KEEPWARM_YN --是否坑冷
- ,CC.DLIV_TP --运输方式
- ,(select SM_CFNM from tbz00_commcd where LG_CD like 'A01007' AND SM_CD = CC.ORD_USEAGE_CD) ORD_USEAGE_CD --订单用途
-
- FROM (
- select B.REG_DTIME --下发时间
- ,B.INS_CAST_MANA_NO CAST_MANA_NO --浇次管理号
- ,B.INS_CAST_CHARGE_SEQ CAST_CHARGE_SEQ --浇次内顺序
- ,B.CHARGE_MANA_NO --转炉炉号
- ,b.STL_GRD --厂内牌号
- ,b.PREV_CHARGE_WGT--预定出钢量
- ,B.INS_CHARGE_STR_DTIME --炼钢作业期限
- ,B.INS_CHARGE_END_DTIME --炼钢作业期限
- ,b.REG_ID --编制人
- from tbf01_spec_charge b
- where '1' = '1'
- ) AA,
- (
- SELECT T.CHARGE_MANA_NO
- ,T.SLAB_THK
- ,T.SLAB_WTH
- ,T.ORD_NO
- ,T.ORD_SEQ
- ,SUM(DECODE(T.ORD_FL,'1',T.SLAB_WGT,0)) ORD_WGT1
- ,SUM(DECODE(T.ORD_FL,'2',T.SLAB_WGT,0)) ORD_WGT2
- ,T.SLAB_RT
- ,T.ORD_FL
- FROM TBF01_SPEC_SLAB T
- GROUP BY T.CHARGE_MANA_NO,T.SLAB_THK,T.SLAB_WTH,T.ORD_NO,T.ORD_SEQ,T.SLAB_RT,T.ORD_FL
- ) BB,
- (
- select D.ORD_NO --合同号
- ,D.ORD_SEQ --订单号
- ,d.DEL_TO_DATE --交货期
- ,d.KEEPWARM_YN --是否坑冷
- ,e.DLIV_TP --运输方式
- ,D.ORD_USEAGE_CD --订单用途
- ,E.SPEC_STL_GRD
- ,E.XSQY --销售区域
- from tbe02_ord_prc d
- ,tba01_ord_line e
- where '1' = '1'
- AND D.ORD_NO = E.ORD_NO
- AND D.ORD_SEQ = E.ORD_SEQ
- ) CC
- WHERE AA.CHARGE_MANA_NO = BB.CHARGE_MANA_NO
- AND BB.ORD_NO = CC.ORD_NO(+)
- AND BB.ORD_SEQ = CC.ORD_SEQ(+)
- and AA.REG_DTIME between :1||'000000' and :2||'999999'
- and nvl(CC.ord_no,' ') = nvl(:3,nvl(CC.ORD_NO,' '))
- and nvl(CC.ord_seq,' ') = nvl(:4,nvl(CC.ORD_seq,' '))
- and nvl(CC.DEL_TO_DATE,'00000000') between nvl(:5,00000000) and nvl(:6,99999999)
- and nvl(CC.SPEC_STL_GRD,' ') = nvl(:7,nvl(CC.SPEC_STL_GRD,' '))
- and BB.SLAB_RT = NVL(:8,BB.SLAB_RT)
- AND BB.ORD_FL = NVL(:9,BB.ORD_FL)
- AND BB.SLAB_WTH = NVL(:10,BB.SLAB_WTH)
- AND CC.XSQY||'&' like :11||'%'
- AND nvl(CC.DLIV_TP,' ') = NVL(:12,nvl(CC.DLIV_TP,' '))
- AND AA.INS_CHARGE_STR_DTIME >= NVL(:13,'00000000')
- AND AA.INS_CHARGE_END_DTIME <= NVL(:14,'99999999')
- order by AA.CAST_MANA_NO,AA.CAST_CHARGE_SEQ
-
- ]]>
- </query>
- </queryMap>
|
