CURSOR AvrgQtyDataCall(in_base_unit_code VARCHAR2, in_dwg_no VARCHAR2, in_seq_no VARCHAR2, in_stl_thck NUMBER) IS SELECT NVL(MIN('Y'),'N') AVRG_INDC, NVL(MAX(AVRG_PERC_QTY),0) PERC_CNT, NVL(MAX(CASE WHEN in_base_unit_code = 'L030' AND SUBSTR(in_dwg_no,13,2) BETWEEN '00' AND '50' THEN 0 ELSE AVRG_HOLE_QTY END),0) HOLE_QTY, NVL(MAX(CASE WHEN in_base_unit_code = 'L030' AND SUBSTR(in_dwg_no,13,2) BETWEEN '00' AND '50' THEN AVRG_TORCH_SET_QTY_2 WHEN in_base_unit_code = 'L030' THEN AVRG_TORCH_SET_QTY ELSE AVRG_TORCH_SET_QTY END),0) TORCH_SET_QTY FROM HP.WA010C WHERE SEQ_NO = in_seq_no AND BASE_UNIT_CODE = in_base_unit_code AND in_stl_thck BETWEEN BASE_MIN_THCK AND BASE_MAX_THCK其中的BASE_MIN_THCK 和 BASE_MAX_THCK就不知在哪定义的.to:snowy_howe(天下有雪) 是在functions下定义的(create or replace FUNCTION sf_CutStdMhByPl)
SELECT NVL(MIN('Y'),'N') AVRG_INDC,
NVL(MAX(AVRG_PERC_QTY),0) PERC_CNT,
NVL(MAX(CASE WHEN in_base_unit_code = 'L030' AND SUBSTR(in_dwg_no,13,2) BETWEEN '00' AND '50' THEN 0
ELSE AVRG_HOLE_QTY END),0) HOLE_QTY,
NVL(MAX(CASE WHEN in_base_unit_code = 'L030' AND SUBSTR(in_dwg_no,13,2) BETWEEN '00' AND '50' THEN AVRG_TORCH_SET_QTY_2
WHEN in_base_unit_code = 'L030' THEN AVRG_TORCH_SET_QTY
ELSE AVRG_TORCH_SET_QTY END),0) TORCH_SET_QTY
FROM HP.WA010C
WHERE SEQ_NO = in_seq_no
AND BASE_UNIT_CODE = in_base_unit_code
AND in_stl_thck BETWEEN BASE_MIN_THCK AND BASE_MAX_THCK其中的BASE_MIN_THCK 和 BASE_MAX_THCK就不知在哪定义的.to:snowy_howe(天下有雪) 是在functions下定义的(create or replace FUNCTION sf_CutStdMhByPl)