SELECT CC.OLD_SAMPL_NO COIL_NO ,CC.SPEC_ABBSYM ,CC.SPEC_STL_GRD ,CC.COIL_THK ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , CC.ORD_USE_CD) ORD_USE_CD ,CC.SMP_NO ,CC.SMP_CUT_LOC ,CC.ORD_NO ,CC.ORD_SEQ ,DECODE(LC.SMP_PROG_CD , 'C' , '试样检验待机' , 'D', '试样判定待机') SMP_PROG_CD FROM TBB02_LOT_COM LC ,C_TBC02_COIL_COMM CC WHERE LC.SMP_NO = CC.SMP_NO AND CC.SMP_DIR_PIC_YN = 'Y' AND LC.SMP_PROG_CD IN('C' , 'D') SELECT CC.OLD_SAMPL_NO COIL_NO ,CC.SPEC_ABBSYM ,CC.SPEC_STL_GRD ,CC.COIL_THK ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , CC.ORD_USE_CD) ORD_USE_CD ,CC.SMP_NO ,CC.SMP_CUT_LOC ,CC.ORD_NO ,CC.ORD_SEQ ,DECODE(LC.SMP_PROG_CD , 'C' , '试样检验待机' , 'D', '试样判定待机') SMP_PROG_CD FROM TBB02_LOT_COM LC ,C_TBC02_COIL_COMM CC WHERE LC.SMP_NO = CC.SMP_NO AND CC.SMP_DIR_PIC_YN = 'Y' AND LC.SMP_PROG_CD = ? SELECT SQ.QLTY_CD ,SQ.QLTY_CD_CFNM ,RQ.QLTY_SEQ ,IQ.QLTY_MIN ,IQ.QLTY_MAX ,DECODE(RQ.QLTY_SEQ , NULL , WQ.QLTY_VAL_WK , RQ.QLTY_VAL_WK) QLTY_VAL_WK ,IQ.QLTY_DEC_CD ,IQ.SMP_NO ,IQ.SMP_CUT_LOC FROM TBB02_WORK_QLTY WQ ,TBB02_REWORK_QLTY RQ ,TBB02_INS_QLTY IQ ,TBB01_SEQ_QLTY SQ WHERE WQ.SMP_NO = IQ.SMP_NO AND WQ.SMP_CUT_LOC = IQ.SMP_CUT_LOC AND WQ.QLTY_CD = IQ.QLTY_CD AND IQ.QLTY_CD = SQ.QLTY_CD AND RQ.SMP_NO(+) = IQ.SMP_NO AND RQ.SMP_CUT_LOC(+) = IQ.SMP_CUT_LOC AND RQ.QLTY_CD(+) = IQ.QLTY_CD AND IQ.SMP_NO = ? AND IQ.SMP_CUT_LOC = ? SELECT CC.OLD_SAMPL_NO COIL_NO ,CC.SPEC_ABBSYM ,CC.SPEC_STL_GRD ,CC.COIL_THK ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , CC.ORD_USE_CD) ORD_USE_CD ,CC.SMP_NO ,CC.SMP_CUT_LOC ,CC.ORD_NO ,CC.ORD_SEQ ,DECODE(LC.SMP_PROG_CD , 'C' , '试样检验待机' , 'D', '试样判定待机') SMP_PROG_CD FROM TBB02_LOT_COM LC ,C_TBL02_COIL_COMM CC WHERE LC.SMP_NO = CC.SMP_NO AND CC.SMP_DIR_PIC_YN = 'Y' AND LC.SMP_PROG_CD IN('C' , 'D') SELECT CC.OLD_SAMPL_NO COIL_NO ,CC.SPEC_ABBSYM ,CC.SPEC_STL_GRD ,CC.COIL_THK ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , CC.ORD_USE_CD) ORD_USE_CD ,CC.SMP_NO ,CC.SMP_CUT_LOC ,CC.ORD_NO ,CC.ORD_SEQ ,DECODE(LC.SMP_PROG_CD , 'C' , '试样检验待机' , 'D', '试样判定待机') SMP_PROG_CD FROM TBB02_LOT_COM LC ,C_TBL02_COIL_COMM CC WHERE LC.SMP_NO = CC.SMP_NO AND CC.SMP_DIR_PIC_YN = 'Y' AND LC.SMP_PROG_CD = ? {call ZL_LIANT_DCS01.SAVE_SMP_VALUE(?,?,?,?,?,?,?)}