A.LASU2_MAX THEN A.LASU_MAX ELSE A.LASU2_MAX END 最高拉速, CASE WHEN A.LASU_MIN>A.LASU2_MIN THEN A.LASU_MIN ELSE A.LASU2_MIN END 最低拉速, A.MEMO 备注2, T.PHOTO_NAME 相片 from RES_SPOTCHECK_DATA T LEFT JOIN (SELECT * FROM STL_CCM_OPTINFO UNION SELECT * FROM J#STL_CCM_OPTINFO) A on SUBSTR(T.SLAB_NO,1,10) = A.HEATNO LEFT JOIN TBZ01_REMARK_COMM@XG3Q B ON T.SLAB_NO = B.SLAB_NO $ order by UPLOAD_DATE ]]> '4' then '2' when NVL(L.CC_DEVNO,E.CC_DEVNO)='J2' and substr(A.SLAB_NO,11,1)<'5' then '3' when NVL(L.CC_DEVNO,E.CC_DEVNO)='J2' and substr(A.SLAB_NO,11,1)>'4' then '4' else '5' end STREAM_NO ,A.SLAB_NO ,A.STL_GRD ,A.SLAB_WTH ,CASE WHEN A.WEIGHT_WGT IS NOT NULL THEN to_char(ROUND(A.WEIGHT_WGT*1000-ROUND(A.SLAB_THK/1000 * A.SLAB_WTH/1000 * A.SLAB_LEN/1000 * 7.85 * 1000))) ELSE '' END SLAB_WGT_DIFF ,A.CUT_WKGROUP FROM TBG02_SLAB_COMM@XG3Q A ,TBG02_CHARGE_COMM@XG3Q E ,TBG02_CC_RESULT@XG3Q L WHERE SUBSTR(A.SLAB_NO,1,9) = SUBSTR(E.CHARGE_NO,1,9) AND A.CHARGE_NO = L.CHARGE_NO(+) $ AND E.BOF_STA_DTIME IS NOT NULL AND instr(NVL(A.SLAB_DCS_DETAIL,1),'二合一')=0 AND instr(NVL(A.SLAB_DCS_DETAIL,1),'三合一')=0 AND instr(NVL(A.SLAB_DCS_DETAIL,1),'低倍样')=0 AND SUBSTR(A.STL_GRD,1,2) <>'JB' AND (A.SLAB_RT = 'Z' OR (A.SLAB_RT = 'P' AND A.SLAB_THK <= 230)) AND A.WEIGHT_WGT IS NOT NULL AND (NVL(L.CC_DEVNO,E.CC_DEVNO)='J1' or NVL(L.CC_DEVNO,E.CC_DEVNO)='J2' or NVL(L.CC_DEVNO,E.CC_DEVNO)='J3') ORDER BY STL_GRD,SLAB_NO,SLAB_WTH ]]>