NVL(B.ORG_ORD_NO, 'XX') AND B.ORD_SEQ <> NVL(B.ORG_ORD_SEQ, 'XX') GROUP BY B.ORD_NO, B.ORD_SEQ UNION ALL SELECT B.ORD_NO, B.ORD_SEQ, SUM(B.SLAB_WGT) REP_WGT FROM TBG02_SLAB_COMM B, TBG02_SLAB_COMM C WHERE B.ORD_FL = '1' AND B.SLAB_NO = C.SLAB_NO AND B.ORD_FL = C.ORD_FL AND B.ORD_NO <> NVL(B.ORG_ORD_NO, 'XX') AND B.ORD_SEQ <> NVL(B.ORG_ORD_SEQ, 'XX') GROUP BY B.ORD_NO, B.ORD_SEQ) GROUP BY (ORD_NO, ORD_SEQ)) M, (SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND FROM TBB01_ORD_INGR WHERE DSN_KIND = '1') K WHERE X.ORD_NO = Y.ORD_NO(+) AND X.ORD_SEQ = Y.ORD_SEQ(+) AND X.ORD_NO = Z.ORD_NO(+) AND X.ORD_SEQ = Z.ORD_SEQ(+) AND X.ORD_NO = W.ORD_NO(+) AND X.ORD_SEQ = W.ORD_SEQ(+) AND X.ORD_NO = M.ORD_NO(+) AND X.ORD_SEQ = M.ORD_SEQ(+) AND X.ORD_NO = K.ORD_NO(+) AND X.ORD_SEQ = K.ORD_SEQ(+) AND X.ORD_NO LIKE ? || '%' AND X.ORD_SEQ LIKE ? || '%' AND (? IS NULL OR X.ORD_PROG_CD IN (SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(?) AS TABSTR_T)))) -- 参数：订单进度代码 AND X.CUST_CD LIKE ? || '%' AND X.SPEC_STL_GRD LIKE ? || '%' AND X.ORD_THK BETWEEN ? AND ? AND X.ORD_WTH BETWEEN ? AND ? AND X.DEL_TO_DATE BETWEEN ? AND ? AND RCVORD_CLF LIKE ? || '%' ORDER BY X.ORD_NO, X.ORD_SEQ ]]>