销售退货单审核报错

销售退货单审核报错

报错SQL如下，我把WHERE清掉之后查询正常
[code]INSERT INTO T_CB_PROORDERTYPE (FENTRYID, FPROORDERENTRYID, FPROORDERTYPE, FFORMID, FNUMBER, FCREATEORGID, FUSEORGID, FDOCUMENTSTATUS, FFORBIDSTATUS, FDATE, FMATERIALID, FBOMID, FAUXPROPID, FLOT, FSEQ, FUNITID, FPRODUCTID, FWORKSHOPID, FCOSTCENTERID, FMTONO, FENTRUSTORGID, FTRUSTEEORGID) SELECT ('TSR@' || TO_CHAR(B.FENTRYID)) FENTRYID, B.FENTRYID FPROORDERENTRYID, 'TSR' FPROORDERTYPE, 'SAL_RETURNSTOCK' FFORMID, A.FBILLNO FNUMBER, A.FSALEORGID FCREATEORGID, C.FSETTLEORGID FUSEORGID, 'C' FDOCUMENTSTATUS, 'A' FFORBIDSTATUS, A.FDATE, B.FMATERIALID, B.FBOMID, B.FAUXPROPID, B.FLOT, B.FSEQ, B.FUNITID, B.FMATERIALID FPRODUC3TID, 0 FWORKSHOPID, 0 FCOSTCENTERID, B.FMTONO, 0 FENTRUSTORGID, 0 FTRUSTEEORGID FROM T_SAL_RETURNSTOCK A INNER JOIN T_SAL_RETURNSTOCKENTRY B ON A.FID = B.FID INNER JOIN T_SAL_RETURNSTOCKFIN C ON A.FID = C.FID WHERE (1 = 1 AND EXISTS (SELECT 1 FROM ( select COLUMN_VALUE as FID from table(cast(:FID_udt as udt_inttable))) tmp WHERE A.FID = tmp.FID))
[/code]