= '03' AND Y.DSN_SLAB_NO = X.DSN_SLAB_NO) ]]> INSERT INTO TBD01_SLABDN_RST2 (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, PROC_STAT,SPEC_REQ_DESC ) 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 , 0 AS ORD_UNIT_WGT_MIN, 0 AS 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, '02' AS PROC_STAT,SPEC_REQ_DESC FROM TBD01_MATDN_RST2 A --, TBE02_ORD_PRC B WHERE 1 = 1 -- AND A.ORD_NO = B.ORD_NO(+) -- AND A.ORD_SEQ = B.ORD_SEQ(+) AND A.MAT_TP||'' IN ('03','04') AND A.ORD_FL = '2' AND A.DSN_SLAB_NO IS NOT NULL START WITH A.MAT_SPEC_SEQ = :1 CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ SELECT X.MAT_SPEC_SEQ, X.DSN_SLAB_NO FROM (SELECT ROWNUM AS RN, A.MAT_SPEC_SEQ, A.DSN_SLAB_NO FROM TBD01_MATDN_RST2 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_RST2 WHERE MAT_SPEC_SEQ = :1 UPDATE TBD01_SLABDN_OBJ2 SET PROC_STAT = :1 WHERE DSN_SLAB_NO = :2 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_RST2) 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_RST2 SET WITHIN_SUB_SEQ = :1 WHERE MAT_SPEC_SEQ = :2