-
白少(提问者)
- --酸平产品质量记录模板
SELECT E.PROD_TIME E生产时间,
to_date(to_char(E.PROD_TIME,\'yyyyMMdd\'),\'yyyyMMdd\') \"E生产日期简写\",
B.CD_SHORT_ENG E钢种,
E.HEAT_ID E炉号,
E.MAT_ID E钢卷号,
E.MAT_THK E订单厚度,
E.MAT_WID E订单宽度,
E.MAT_ACT_THK E实际厚度,
E.MAT_ACT_WID E实际宽度,
E.MAT_WGT E实际重量,
decode(E.SURF_GRD,00,\'待判\',01,\'合格品\',03,\'二级品\',04,\'废品\',05,\'暂留\',06,\'再处理\',07,\'无主合格品\') E表面等级,
F.DEFECT_DESC E缺陷描述,
F.DEFECT_NAME E缺陷名称,
P.PROD_TIME P生产时间,
to_date(to_char(P.PROD_TIME,\'yyyyMMdd\'),\'yyyyMMdd\') \"P生产日期简写\",
BB.CD_SHORT_ENG P钢种,
P.MAT_ID P钢卷号,
P.MATNAME P名字,
p.occr_cd 计划去向,
P.MAT_THK P订单厚度,
P.MAT_WID P订单宽度,
p.mat_act_thk 实际厚度,
p.mat_act_lth 实际长度,
p.mat_act_wid 实际宽度,
P.MAT_WGT P实际重量,
P.MAT_ACT_WGT p冷轧毛重,
F.DISP_RESULT e表面质量判定,
FF.DISP_RESULT p表面质量判定,
FF.DEFECT_DESC P缺陷描述,
FF.DEFECT_NAME P缺陷名称,
DECODE(FF.CHK_POS,\'YL\',\'原料\',\'LZ\',\'冷轧\',\'JZ\',\'精整\',\'WB\',\'外部\') 缺陷来源,
decode(P.SURF_GRD,00,\'待判\',01,\'合格品\',03,\'二级品\',04,\'废品\',05,\'暂留\',06,\'再处理\',07,\'无主合格品\') P表面等级,
decode(P.CHEM_GRD,00,\'待判\',01,\'合格\',03,\'二级品\',04,\'废品\',05,\'暂留\',06,\'再处理\',07,\'无主合格品\') P成分等级,
decode(P.MTAL_GRD,00,\'待判\',01,\'合格\',03,\'二级品\',04,\'废品\',05,\'暂留\',06,\'再处理\',07,\'无主合格品\') P性能等级,
decode(P.PROD_GRD,00,\'待判\',01,\'合格品\',03,\'二级品\',04,\'废品\',05,\'暂留\',06,\'再处理\',07,\'无主合格品\') P终判等级
FROM PSS.QCM_C_PROD_RES E,PSS.QCM_C_PROD_RES P,(select * from PSS.QCM_C_PFACE where del_flag!=\'1\') F,(select * from PSS.QCM_C_PFACE where del_flag!=\'1\') FF,PSS.BBB_CD B,PSS.BBB_CD BB
WHERE P.MAT_TYPE = \'S\'
AND P.PRE_MAT_ID = E.MAT_ID
AND B.CD = E.STL_GRD_CD
AND BB.CD = P.STL_GRD_CD
AND E.MAT_ID = F.PLATE_ID(+)
AND P.MAT_ID = FF.PLATE_ID(+)
AND P.DEL_FLAG = \'0\'
${if(len(PMAT_ID) == 0,\"\",\" and P.MAT_ID like \'%\"+PMAT_ID+\"%\'\")}
AND P.PROD_TIME BETWEEN
TO_DATE(\'${STARTTIME}\', \'YYYY-MM-DD HH24:MI:SS\') AND
TO_DATE(\'${ENDTIME}\', \'YYYY-MM-DD HH24:MI:SS\') ORDER BY P.PROD_TIME 大佬你看怎么优化一下呢!
|