'M' AND A.PRODNM_CD LIKE :1 || '%' -- 产品代码 AND A.CUST_CD || '&' LIKE :2 || '%' -- 客户代码 AND A.C_SPEC_STL_GRD||'&' LIKE :3 || '%' -- 钢号 AND A.ORD_NO LIKE :4 || '%' -- 合同号 AND A.ORD_SEQ LIKE :5|| '%' -- 订单号 AND A.RCVORD_CLF || '&' LIKE :6|| '%' -- 接受订单区分 AND A.DEL_TO_DATE BETWEEN :7 AND :8 -- 交货日期（到达） AND A.ORD_USEAGE_CD || '&' LIKE :9 || '%' -- 订单用途 AND A.C_SPEC_ABBSYM || '&' LIKE :10 || '%' -- 标准号 AND A.ORD_THK BETWEEN :11 AND :12 -- 订单厚度 AND A.ORD_WTH BETWEEN :13 AND :14 -- 订单宽度 AND A.ORD_UNIT_WGT BETWEEN :15 AND :16 --订单单重 AND A.OVER_ORD IS NULL ORDER BY A.DEL_TO_DATE, A.ORD_NO, A.ORD_SEQ ]]> '6') AND A.ORD_FL = '1' AND A.COIL_STAT = '2' AND A.ORD_NO = :1 -- 合同号 AND A.ORD_SEQ = :2 -- 订单号 ORDER BY A.ORD_NO, A.ORD_SEQ ]]>