SELECT DISTINCT decode(SI.COMP_YN , 'Y' , SI.COMP_CAL , SI.CHEM_CD) CHEM , WI.CHEM_CD , SI.COMP_YN , SI.DISPLAY_SEQ FROM TBB02_WORK_INGR WI , TBB01_SEQ_INGR SI WHERE WI.CHEM_CD = SI.CHEM_CD AND WI.CHEM_VAL_TP = 'L' --'L'表示炉次，'P'表示钢卷，'S'表示板坯 AND CHEM_VAL IS NOT NULL AND WI.CHARGE_NO(+) LIKE ? AND WI.CHEM_SEQ = ? , max(decode(WI.CHEM_CD , '{0}' , CHEM_VAL )) CHEM_VAL{1} , max(decode(TI.CHEM_CD , '{0}' , CHEM_MIN )) CHEM_MIN{1} , max(decode(TI.CHEM_CD , '{0}' , CHEM_MAX )) CHEM_MAX{1} SELECT WI.CHARGE_NO , WI.PROC_CD , WI.CHEM_SEQ , GC.STL_GRD , decode(WI.PROC_CD||MAX(WI.CHEM_SEQ) , GC.LST_INGR_CD , GC.INGR_DEC_GRD , NULL) INGR_DEC_GRD , max(decode(TDI.CHEM_CD , 'TT' , CHEM_DCS_RST )) CHEM_DCS_RST , TI.tafac_stl_grd , GC.SLAB_RT , decode(GC.LST_INGR_CD, WI.PROC_CD||WI.CHEM_SEQ , GC.LST_INGR_REG_DTIME , '') LST_INGR_REG_DTIME AND SUBSTR(GC.INGR_DEC_DTIME , 1 , 8) BETWEEN ? AND ? GROUP BY WI.CHARGE_NO , WI.PROC_CD , WI.CHEM_SEQ , GC.STL_GRD , GC.BEF_STL_GRD , GC.INGR_DEC_GRD , GC.LST_INGR_REG_DTIME , GC.LST_INGR_CD , GC.SLAB_RT , TI.tafac_stl_grd ORDER BY WI.CHARGE_NO DESC , INGR_DEC_GRD DESC FROM TBB02_WORK_INGR WI , TBG02_CHARGE_COMM GC , TBB01_MAP_INGR MI,TBB01_TAFAC_INGR TI,TBB02_TADCS_INGR TDI WHERE WI.CHARGE_NO = GC.CHARGE_NO(+) AND WI.CHARGE_NO = TDI.CHARGE_NO(+) AND WI.PROC_CD = TDI.PROC_CD(+) AND WI.CHEM_SEQ = TDI.CHEM_SEQ(+) AND GC.STL_GRD = MI.FAC_STL_GRD(+) AND GC.SLAB_RT = MI.FAC_CODE(+) AND MI.TAFAC_STL_GRD = TI.TAFAC_STL_GRD