1.32 --DESC: 出现轧制计划重复做多次的情况，不确定是人工修改了状态还是某个程序改变了轧制计划的状态，故在此控制 AND A.SLAB_NO NOT IN (SELECT SLAB_NO FROM TBF02_SPEC_MILL WHERE STATUS_CD IN ('A','B')) -------------------------------------------------------------------------------------------- AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = K.ORD_NO(+) AND A.ORD_SEQ = K.ORD_SEQ(+) AND A.ORD_NO = QL.ORD_NO(+) AND A.ORD_SEQ = QL.ORD_SEQ(+) AND A.ORD_NO = DE.ORD_NO(+) AND A.ORD_SEQ = DE.ORD_SEQ(+) AND A.STL_GRD = D.FAC_STL_GRD(+) AND E.ORD_NO = A.ORD_NO AND E.ORD_SEQ = A.ORD_SEQ AND Z.CUST_CD = A.CUST_CD AND T.SM_CD = A.SLAB_RT AND A.SLAB_THK BETWEEN F.SLAB_THK_MIN AND F.SLAB_THK_MAX AND A.SLAB_WTH BETWEEN F.SLAB_WID_MIN AND F.SLAB_WID_MAX AND A.SLAB_LEN BETWEEN F.SLAB_LEN_MIN AND F.SLAB_LEN_MAX AND F.PLT = 'H' AND F.FUR_LINE = '1' AND A.SLAB_LEN BETWEEN 4500 AND 11000 AND E.RCVORD_CLF <> 'M' --跺位锁定的不要显示 MODIFY BY SJW 090807 AND NVL(A.YARD_LOCK_YN,'N') <> 'Y' ------------------------------------------------------------------------------------------------ --MODIFY BY SJW 091024 --DESC: 排除找不到宽度组的错误数据 AND A.INSTR_COIL_WTH > 0 ------------------------------------------------------------------------------------------------ AND A.INSTR_COIL_WTH >= ? AND A.INSTR_COIL_WTH < ? AND A.STL_GRD LIKE ? ||'%' -- AND D.FAC_STL_GRP LIKE ? ||'%' AND nvl( D.FAC_STL_GRP,' ') LIKE ? ||'%' AND A.ORD_NO || A.ORD_SEQ LIKE ? ||'%' || ? ||'%' AND E.ORD_USEAGE_CD LIKE ? ||'%' AND A.CUR_LOAD_LOC LIKE ? ||'%' AND A.INSTR_COIL_THK >= ? AND A.INSTR_COIL_THK < ? AND A.CUR_PROG_CD = 'RBA' AND A.SLAB_STAT = '2' AND A.ORD_FL = '1' AND A.CUR_LOAD_LOC LIKE 'Z%' AND E.ORD_PROG_CD IN ('D','E') ORDER BY C.WTH_AIM DESC, C.HOT_THK_AIM DESC, E.DEL_TO_DATE ASC, NVL(E.EMGMTR_NMG_CLF,'N') DESC, A.CUR_LOAD_LOC DESC /*****************************选择编制的板坯********************************************************/ ]]> = T.MINI AND A.INSTR_COIL_THK < T.MAXI )THK_GRP_CD ,C.HOT_THK_AIM -- 热厚度AIM ,C.HOT_THK_MIN -- 热厚度MIN ,C.HOT_THK_MAX -- 热厚度MAX ,C.WTH_AIM -- 宽度AlM ,C.WTH_MIN -- 宽度MIN ,C.WTH_MAX -- 宽度MAX ,(SELECT T.WTH_GRP_CD FROM TBF02_ROLL_WTH_GRP T -- 宽度组代码 WHERE T.PLT = 'H' AND A.INSTR_COIL_WTH >= T.MINI AND A.INSTR_COIL_WTH < T.MAXI )WTH_GRP_CD ,B.ORD_LEN ,B.ORD_WGT ,'C' -- 热送代号 ,A.ORD_NO -- 合同号 ,A.ORD_SEQ -- 订单号 ,E.ORD_USEAGE_CD -- 订单用途代码 ,A.SPEC_ABBSYM -- 标准号 ,E.ORDCUST_CD -- 客户代码 ,E.CUST_CD -- 客户代码 ,E.DEST_CD -- 目的地代码 ,E.del_to_date -- 交货期 ,E.UST_CD -- UST区分 ,'H' -- 去向 ,A.INSTR_COIL_THK -- 订单厚度 ,A.INSTR_COIL_WTH -- 订单宽度 ,A.INSTR_COIL_WGT -- 订单重量 ,E.ORD_UNIT_WGT_MIN -- 订单单重下限 ,E.ORD_UNIT_WGT_MAX -- 订单单重上限 ,A.INSTR_COIL_INDIA -- 订单内径 ,A.INSTR_COIL_OUTDIA -- 订单外径 ,E.PACK_METHOD -- 包装方法 ,'' -- 轧制工艺流程 ,E.SPM_PROC_YN -- 平整分卷指定判断 ,B.COIL_CUT_CNT -- 刚卷分割数 ,'' -- 目标加热温度 ,'' -- 目标出炉温度 ,(SELECT NVL(F.FUR_TME,0) FROM TBF02_FUR_TIME F WHERE F.PLT = 'H' AND F.FUR_LINE = 1 AND F.STL_GRD = A.STL_GRD AND F.SLAB_THK_MIN <= A.SLAB_THK AND F.SLAB_THK_MAX > A.SLAB_THK AND F.HCR_CLF = 'C') FUR_TME ,'' -- 轧制时间 ,A.CUR_LOAD_LOC -- 堆置位置 ,'' -- 计划加热炉装炉日期 ,'' -- 计划轧制时间 ,'' -- 错误 ,'A' -- 状态区分 ,'' -- 标识 ,'' ,'' ,'' ,A.SLAB_STOCK_TYPE ,E.ORD_USEAGE_CD ,E.C_SPEC_ABBSYM ,E.C_ORD_THK ,E.C_ORD_WTH ,E.ORD_UNIT_WGT ,E.ORD_UNIT_WGT_MIN ,E.ORD_UNIT_WGT_MAX ,E.C_ORD_INDIA ,E.C_ORD_OUTDIA ,E.C_SPEC_STL_GRD ,E.PROD_LINE FROM TBG02_SLAB_COMM A, TBD00_STLGRD D, TBE02_ORD_PRC E, TBB01_ORD_HEAD H, (SELECT SLAB_NO, COUNT(SLAB_CUT_SEQ) COIL_CUT_CNT, SUM(ORD_LEN) ORD_LEN, SUM(ORD_WGT) ORD_WGT FROM TBG02_SLAB_COMM_D GROUP BY SLAB_NO) B, TBB01_ORD_PROD C -----------------------MODIFY BY WXY 100302--------------------------- -----------------------DESC: 板坯号变更------------------------------ WHERE A.SUB_SLAB_NO = B.SLAB_NO ------------------------------------------------------------------- AND A.SLAB_NO = ? AND A.SLAB_NO NOT IN (SELECT SLAB_NO FROM tbf02_sch_mill) AND A.STL_GRD = D.FAC_STL_GRD(+) AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = H.ORD_NO(+) AND A.ORD_SEQ = H.ORD_SEQ(+) AND E.ORD_NO = A.ORD_NO AND E.ORD_SEQ = A.ORD_SEQ AND A.CUR_PROG_CD = 'RBA' AND A.SLAB_STAT = '2' AND A.ORD_FL = '1' /* AND A.CUR_LOAD_LOC LIKE 'Z%' */ ORDER BY A.SLAB_WTH DESC, A.SLAB_LEN DESC, A.CUR_LOAD_LOC DESC /*************************************************************************************/ ]]> = ? AND A.ORD_WTH < ? AND A.STL_GRD LIKE ? ||'%' -- AND D.FAC_STL_GRP LIKE ? ||'%' AND NVL(D.FAC_STL_GRP,' ') LIKE ? ||'%' AND A.ORD_NO || A.ORD_SEQ LIKE ? ||'%' || ? ||'%' AND E.ORD_USEAGE_CD LIKE ? ||'%' AND A.CUR_LOAD_LOC LIKE ? ||'%' AND A.ORD_THK >= ? AND A.ORD_THK < ? ORDER BY A.ROLL_SLAB_SEQ /********************************选择要取消的编制板坯*****************************************************/ ]]>