NVL(?, 'N') OR (B.STL_GRD = A.STL_GRD /* AND D.SLAB_INGR_DEC_GRD = '1' */)) -- 同牌号 AND ('Y' <> NVL(?, 'N') OR GF_NIB028720(B.SLAB_NO, A.ORD_NO, A.ORD_SEQ) = 'YY') -- 检查成分项目 ORDER BY B.SLAB_WGT DESC, B.LOC ASC ]]> NVL(?, 'N') OR B.STL_GRD = A.STL_GRD) -- 同牌号 ------------------------------------------------------------------------------------------ --MODIFY BY SJW 091010 --DESC: 成品同牌号更改为spec_stl_grd AND ('Y' <> NVL(?, 'N') OR C.SPEC_STL_GRD = D.SPEC_STL_GRD) -- 同牌号 ------------------------------------------------------------------------------------------ AND GF_NIB028780(B.COIL_NO, A.ORD_NO, A.ORD_SEQ) = 'YY' -- 检查尺寸通过 AND ('Y' <> NVL(?, 'N') OR GF_NIB028720(C.SLAB_NO, A.ORD_NO, A.ORD_SEQ) = 'YY') -- 检查成分项目 AND ('Y' <> NVL(?, 'N') OR GF_NIB028750(B.COIL_NO, A.ORD_NO, A.ORD_SEQ) = 'YY') -- 检查材质项目 ORDER BY COIL_WGT DESC, LOC ASC ]]>