0 THEN '是' ELSE '否' END IS_ZLSJ, A.FAC_STL_GRP , A.COIL_THK, A.COIL_WTH, A.COIL_LEN, A.COIL_WGT , A.PROC_PATH , A.HCR_YN, A.EMGMTR_YN, A.COMB_YN , NULL AS ORD_DEVLMT_DATE ,'N' AS SCARFING_PROC_YN ,'N' AS SPM_PROC_YN ,'N' AS CHK , A.GRAVITY , A.COIL_INDIA , A.COIL_OUTDIA , A.SPEC_REQ_DESC FROM TBD01_SLABDN_RST2 A , TBD01_SLABDN_OBJ2 B, (SELECT T.ORD_NO,T.ORD_SEQ,COUNT(*) CN FROM TBB01_ORD_INGR T GROUP BY T.ORD_NO,T.ORD_SEQ) C WHERE 1 = 1 AND A.DSN_SLAB_NO = B.DSN_SLAB_NO AND B.ORD_NO = C.ORD_NO(+) AND B.ORD_SEQ = C.ORD_SEQ(+) AND A.PROC_STAT = '02' AND A.FAC_STL_GRP LIKE :1||'%' AND A.FAC_STL_GRD LIKE :2||'%' AND A.SLAB_WTH BETWEEN NVL(:3,0) AND NVL(:4,999999) AND A.COIL_THK BETWEEN NVL(:5,0) AND NVL(:6,999999) AND A.SLAB_THK = :7 AND A.ORD_NO||'&' LIKE :8||'%' AND A.ORD_SEQ||'&' LIKE :9||'%' START WITH 1 = 1 CONNECT BY PRIOR A.DSN_SLAB_NO = A.P_DSN_SLAB_NO ORDER SIBLINGS BY B.L2_SCH ,B.L2_SCH_NO, B.DSN_SLAB_NO ]]> = '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