0 -- 参数：产品类型 AND (? IS NULL OR A.ORD_PROG_CD IN ( -- 参数：订单进度代码 SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(?) AS TABSTR_T)))) AND A.DEL_TO_DATE BETWEEN nvl(?,'00000000') AND nvl(?,'99999999') AND A.ORD_REM_WGT BETWEEN NVL(?, -99999999) AND NVL(?, 99999999) AND A.ORD_PRC_WGT BETWEEN NVL(?, -99999999) AND NVL(?, 99999999) AND A.PROD_END_WGT BETWEEN NVL(?, -99999999) AND NVL(?, 99999999) AND ((? IS NULL AND ? IS NULL AND NVL(A.ORD_MOD_DTIME,'00000000000000') BETWEEN nvl(?,'00000000000000') AND nvl(?,'99999999999999')) OR ((? IS NOT NULL OR ? IS NOT NULL) AND A.ORD_MOD_DTIME BETWEEN nvl(?,'00000000000000') AND nvl(?,'99999999999999'))) AND A.ORD_MOD_ID = B.USER_CD(+) --王黎添加 8月12日 ]]> 投入确定 ORD_PROG_CD)), ORD_MOD_ID = ?, ORD_MOD_DTIME = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') WHERE ORD_NO = ? -- 合同号 AND ORD_SEQ = ? -- 订单号 ]]> 投入确定 ORD_PROG_CD)), ORD_MOD_ID = ?, ORD_MOD_DTIME = TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') WHERE ORD_NO = ? -- 合同号 AND ORD_SEQ = ? -- 订单号 ]]>