SELECT SM_CD VALUE , SM_CFNM LABEL , CD_SEQ FROM TBZ00_COMMCD WHERE LG_CD = 'B01129' ORDER BY CD_SEQ SELECT DECODE(X.COMP_YN, 'Y', X.COMP_CAL, X.CHEM_CD) AS CHEM ,X.CHEM_CD ,X.COMP_YN ,X.DISPLAY_SEQ FROM TBB01_SEQ_INGR X WHERE EXISTS (SELECT 'X' FROM TBB02_WORK_INGR Y WHERE Y.CHEM_CD = X.CHEM_CD AND Y.CHEM_VAL_TP = 'L' --'L'表示炉次，'P'表示钢卷，'S'表示板坯 AND CHEM_VAL IS NOT NULL AND ROWNUM = 1) ORDER BY X.COMP_YN , X.DISPLAY_SEQ SELECT WI.CHARGE_NO , WI.PROC_CD , WI.CHEM_SEQ , GC.STL_GRD , GC.BEF_STL_GRD , decode(WI.PROC_CD||WI.CHEM_SEQ , GC.LST_INGR_CD , GC.INGR_DEC_GRD , NULL) INGR_DEC_GRD , GC.SLAB_RT , decode(GC.LST_INGR_CD, WI.PROC_CD||WI.CHEM_SEQ , GC.LST_INGR_REG_DTIME , '') LST_INGR_REG_DTIME , decode(GC.LST_INGR_CD, WI.PROC_CD||WI.CHEM_SEQ , GC.CHARGE_INGR_DEC_EMP_ID , '') CHARGE_INGR_DEC_EMP_ID , max(decode(WI.CHEM_CD , '{0}' , CHEM_L2_VAL )) CHEM_VAL{1} FROM TBB02_WORK_INGR WI , TBG02_CHARGE_COMM_D GC WHERE WI.CHARGE_NO = GC.CHARGE_NO(+) AND WI.CHARGE_NO(+) BETWEEN ? AND ? /* AND (WI.PROC_CD = ? OR WI.PROC_CD = ? OR WI.PROC_CD = ? OR WI.PROC_CD = ? ) */ AND (WI.PROC_CD IN ( ?, ?, ?, ? ) AND WI.CHEM_SEQ = ? AND GC.CHARGE_INIT_DTIME BETWEEN ? || '0000' AND ? || '9999' -- AND SUBSTR(GC.CHARGE_INIT_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 , GC.CHARGE_INGR_DEC_EMP_ID ORDER BY WI.CHARGE_NO DESC , INGR_DEC_GRD DESC SELECT * FROM (SELECT DECODE(FAC.COMP_YN, 'Y', SEQ.COMP_CAL, SEQ.CHEM_CD) CHEMCD, FAC.CHEM_CD CHEMCD_CAL, FAC.CHEM_MIN MIN_1, FAC.CHEM_MAX MAX_1 FROM TBB01_SEQ_INGR SEQ, TBB01_FAC_INGR FAC WHERE FAC.CHEM_CD = SEQ.CHEM_CD AND FAC.FAC_STL_GRD = ?) AA, (SELECT DECODE(TAF.COMP_YN, 'Y', SEQ.COMP_CAL, SEQ.CHEM_CD) CHEMCD, TAF.CHEM_CD CHEMCD_CAL, TAF.CHEM_MIN MIN_2, TAF.CHEM_MAX MAX_2 FROM TBB01_SEQ_INGR SEQ, TBB01_TAFAC_INGR TAF WHERE TAF.CHEM_CD = SEQ.CHEM_CD AND TAF.TAFAC_STL_GRD = ?) BB, TBB02_WORK_INGR WO WHERE AA.CHEMCD = BB.CHEMCD AND AA.CHEMCD_CAL = WO.CHEM_CD(+) --修改复合元素不显示值的问题 AND WO.CHARGE_NO(+) = ? AND WO.PROC_CD(+) = ? AND WO.CHEM_SEQ(+) = ? INSERT INTO OPTION_LOG (ID, PARAMS, STATUS, THREAD_ID, THREAD_NAME, CREATE_TIME) VALUES (?, ?, ?, ?, ?, ?) UPDATE OPTION_LOG SET STATUS = ?, MODIFY_TIME = ?, DURATION_TIME = ?, RESULT_SIZE= ? WHERE ID = ?