= '03' AND Y.DSN_SLAB_NO = X.DSN_SLAB_NO) ]]> INSERT INTO TBD01_SLABDN_RST (DSN_SLAB_NO, P_DSN_SLAB_NO, ORD_NO, ORD_SEQ , SLAB_THK, SLAB_WTH, SLAB_LEN, SLAB_WGT , SLAB_TRMTH_TP, GRAVITY, AUTODSN_YN , COIL_PACK_WGT_MIN, COIL_PACK_WGT_MAX , FAC_STL_GRD , COIL_THK, COIL_WTH, COIL_LEN, COIL_WGT , PROC_PATH , HCR_YN, EMGMTR_YN, FAC_STL_GRP, COMB_YN , COIL_INDIA, COIL_OUTDIA,KEEPWARM_YN , PROD_LINE, C_COIL_THK, C_COIL_WTH) SELECT A.DSN_SLAB_NO, A.P_DSN_SLAB_NO, A.ORD_NO, A.ORD_SEQ -- , A.MAT_TP, A.MAT_SPEC_SEQ, A.PMAT_SPEC_SEQ , A.MAT_THK, A.MAT_WTH, A.MAT_LEN, A.MAT_WGT , A.SCARPING_PROC_YN, A.GRAVITY, A.AUTODSN_YN , B.ORD_UNIT_WGT_MIN, B.ORD_UNIT_WGT_MAX , A.FAC_STL_GRD , A.COIL_THK, A.COIL_WTH, A.COIL_LEN, A.COIL_WGT , A.PATH_PROC_CD , A.HCR_YN, A.EMGMTR_YN, A.FAC_STL_GRP, A.COMB_YN , A.COIL_INDIA, A.COIL_OUTDIA, A.KEEPWARM_YN , A.PROD_LINE, A.C_COIL_THK, A.C_COIL_WTH FROM TBD01_MATDN_RST A, TBE02_ORD_PRC B WHERE A.ORD_NO = B.ORD_NO(+) AND A.ORD_SEQ = B.ORD_SEQ(+) AND A.MAT_TP||'' IN ('03','04') AND A.ORD_FL = '1' START WITH A.MAT_SPEC_SEQ = :1 CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ SELECT X.MAT_SPEC_SEQ FROM (SELECT ROWNUM AS RN, A.MAT_SPEC_SEQ FROM TBD01_MATDN_RST A START WITH A.MAT_SPEC_SEQ = :1 CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ ORDER BY 1 DESC) X DELETE FROM TBD01_MATDN_RST WHERE MAT_SPEC_SEQ = :1 SELECT * FROM (SELECT MAT_SPEC_SEQ, PMAT_SPEC_SEQ, WITHIN_SUB_SEQ , ROW_NUMBER() OVER (PARTITION BY PMAT_SPEC_SEQ ORDER BY WITHIN_SUB_SEQ) AS RNUM FROM TBD01_MATDN_RST) A WHERE A.WITHIN_SUB_SEQ != A.RNUM START WITH A.PMAT_SPEC_SEQ = :1 CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ UPDATE TBD01_MATDN_RST SET WITHIN_SUB_SEQ = :1 WHERE MAT_SPEC_SEQ = :2