'Z' --常化卷屏蔽 20220909 AND ((A.PROD_LINE IN ('C','L') AND H.CUR_PROG_CD = 'SGB') OR (H.CUR_PROG_CD in ('SED') AND SUBSTR(H.ORD_NO,0,1) IN ('4','5')) OR (SUBSTR(H.ORD_NO, 0, 2) IN ('W4', 'W5')) OR (SUBSTR(H.ORD_NO, 0, 6) IN ('XGEC-L'))) AND H.ORD_NO||'&' like ? || '%' AND H.ORD_SEQ||'&' like ? || '%' AND H.OLD_SAMPL_NO||'&' LIKE ? || '%' ]]> '' or H.COIL_OUTDIA <> 0)THEN H.COIL_OUTDIA ELSE C_PKG_UIF.F_FUN_GET_OUTSIDE(H.COIL_INDIA,H.ACT_WGT,H.COIL_WTH)end) COIL_OUTDIA ,H.COIL_OUTDIA ,H.COIL_THK,H.COIL_WTH,H.ACT_WGT,H.ORD_FL,H.ORD_NO,H.ORD_SEQ,P.C_PRODNM_CD PRODNM_CD,H.SPEC_ABBSYM ,P.C_SPEC_STL_GRD SPEC_STL_GRD,H.ORD_USE_CD,H.SPEC_STL_GRD STL_GRD,H.PATH_MILL_CD,H.INGR_DEC_GRD,H.EXTSHAPE_DEC_GRD ,H.SIZE_DEC_RST,H.WGT_DEC_RST,H.PROC_DEC_RST,H.MATLQLTY_DEC_GRD,H.TOT_DEC_GRD,H.MILL_DTIME ,H.CRK_CD1,H.CRK_CD2,H.CRK_CD3,H.CRK_CD4,H.CRK_CD5,H.CAL_WGT,H.OLD_SAMPL_NO ,H.YARD_ENTRY_DTIME ,H.SAMPL_NO,H.SAMPL_CUT_LOC ,R.FM_EXT_STRIP_THK_AVG ,R.FM_EXT_STRIP_TEMP_AVG,R.DC_TEMP_AVG,R.FM_EXT_STRIP_CROWN_AVG FROM TBH02_COIL_COMM H,TBH02_MILL_RESULT R,TBE02_ORD_PRC P WHERE H.COIL_NO = R.COIL_NO AND H.ORD_NO = P.ORD_NO(+) AND H.ORD_SEQ = P.ORD_SEQ(+) AND H.OLD_SAMPL_NO = ? ]]> '' or H.COIL_OUTDIA <> 0)THEN H.COIL_OUTDIA ELSE C_PKG_UIF.F_FUN_GET_OUTSIDE(H.COIL_INDIA,H.ACT_WGT,H.COIL_WTH)end) COIL_OUTDIA , H.COIL_OUTDIA, H.COIL_THK, H.COIL_WTH, H.ACT_WGT, H.ORD_FL, H.ORD_NO, H.ORD_SEQ, P.C_PRODNM_CD PRODNM_CD, H.SPEC_ABBSYM, P.C_SPEC_STL_GRD SPEC_STL_GRD, H.ORD_USE_CD, H.SPEC_STL_GRD STL_GRD, H.PATH_MILL_CD, H.INGR_DEC_GRD, H.EXTSHAPE_DEC_GRD, H.SIZE_DEC_RST, H.WGT_DEC_RST, H.PROC_DEC_RST, H.MATLQLTY_DEC_GRD, H.TOT_DEC_GRD, H.MILL_DTIME, H.CRK_CD1, H.CRK_CD2, H.CRK_CD3, H.CRK_CD4, H.CRK_CD5, H.CAL_WGT, H.OLD_SAMPL_NO, ? CR_PLANT_TRS_CLF, ? CR_PLANT_TRS_NO, ? CR_PLANT_TRS_DTIME, R.FM_EXT_STRIP_THK_AVG, R.FM_EXT_STRIP_TEMP_AVG, R.DC_TEMP_AVG, R.FM_EXT_STRIP_CROWN_AVG, H.MILL_DTIME, H.SAMPL_NO, H.SAMPL_CUT_LOC, H.ORD_NO, H.ORD_SEQ, H.ORD_FL, ? CR_PLANT_TRS_SEQ, H.SPEC_STL_GRD BEF_STL_GRD FROM TBH02_COIL_COMM H, TBH02_MILL_RESULT R, TBE02_ORD_PRC P WHERE H.COIL_NO = R.COIL_NO AND H.ORD_NO = P.ORD_NO(+) AND H.ORD_SEQ = P.ORD_SEQ(+) AND H.COIL_NO = (SELECT COIL_NO FROM TBH02_COIL_COMM WHERE OLD_SAMPL_NO = ?) ]]>