SELECT T1.PRDNM_CD ,T1.SPEC_ABBSYM ,T1.SPEC_STL_GRD ,T1.ORD_USE_TP ORD_USE_TP_HIDEN ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , T1.ORD_USE_TP ) ORD_USE_TP ,T1.THK_MIN ,T1.THK_MAX ,T1.WTH_MIN ,T1.WTH_MAX ,T2.PIC1 ,T2.PIC2 ,T2.PIC3 ,T2.TMPL_NO ,T2.REG_ID ,T2.REG_DTIME ,T2.MOD_ID ,T2.MOD_DTIME ,T2.LICENSE_NO ,DECODE(T2.PRDNM_CD , NULL , 'N' , 'Y') EXIT_YN FROM TBB01_KEY_PROD T1 , TBB02_MS_SET1 T2 WHERE T1.PRDNM_CD = T2.PRDNM_CD(+) AND T1.SPEC_ABBSYM = T2.SPEC_ABBSYM(+) AND T1.SPEC_STL_GRD = T2.SPEC_STL_GRD(+) AND T1.ORD_USE_TP = T2.ORD_USE_TP(+) AND T1.THK_MIN = T2.THK_MIN(+) AND T1.THK_MAX = T2.THK_MAX(+) AND T1.WTH_MIN = T2.WTH_MIN(+) AND T1.WTH_MAX = T2.WTH_MAX(+) SELECT T1.ORD_NO ,T1.ORD_SEQ ,T1.PRDNM_CD ,T1.SPEC_ABBSYM ,T1.SPEC_STL_GRD ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , T1.ORD_USE_TP ) ORD_USE_TP ,T1.CRET_NO_RMK ,T1.TMPL_NO FROM TBB01_ORD_HEAD T1 WHERE T1.ORD_NO LIKE ?||'%' AND T1.SPEC_STL_GRD LIKE ?||'%' AND SUBSTR(T1.DSN_CMT_DATE ,1,4 ) = ? SELECT T.* , T.MS_SEQ MS_SEQ_1 FROM TBB02_MS_SET2 T ORDER BY T.DIS_SEQ UPDATE TBB02_MS_QLTYCD T SET T.DISPLAY_SEQ = ? ,T.MS_QLTY_DIR = ? ,T.MS_QLTY_SIZ = ? ,T.MS_QLTY_TEM = ? ,T.MS_BIG_CFNM = ? ,T.MS_BIG_EFNM = ? ,T.MS_SMALL_CFNM = ? ,T.MS_SMALL_EFNM = ? ,T.MS_EXT_CODE = ? ,T.MOD_ID = ? ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.QLTY_CD = ? UPDATE TBB02_MS_SET1 T SET T.PIC1 = ? ,T.PIC2 = ? ,T.PIC3 = ? ,T.TMPL_NO = ? ,T.LICENSE_NO = ? WHERE T.PRDNM_CD = ? AND T.SPEC_ABBSYM = ? AND T.SPEC_STL_GRD = ? AND T.ORD_USE_TP = ? UPDATE TBB02_MS_SET2 T SET T.MS_SEQ = ? ,T.MS_DESC = ? ,T.DIS_SEQ = ? ,T.FIXED_PRO = ? ,T.MOD_ID = ? ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.MS_SEQ = ? INSERT INTO TBB02_MS_SET1 (PRDNM_CD ,SPEC_ABBSYM ,SPEC_STL_GRD ,ORD_USE_TP ,THK_MIN ,THK_MAX ,WTH_MIN ,WTH_MAX ,PIC1 ,PIC2 ,PIC3 ,TMPL_NO ,LICENSE_NO ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) INSERT INTO TBB02_MS_SET2 ( MS_SEQ ,MS_DESC ,DIS_SEQ ,FIXED_PRO ,REG_ID ,REG_DTIME ) VALUES(?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) DELETE FROM TBB02_MS_SET2 T WHERE T.MS_SEQ = ? {call ZL_SUAN_DCS01.SAVE_TMPL_NO_RMK(?,?,?,?,?,?,?)} {call ZL_SUAN_DCS01.SAVE_TMPL_NO(?,?,?,?,?,?,?,?,?,?)}