如下语句:
select *
from (select rownum r, t.*
from (select s.c_id,
f.c_id fileid,
f.c_title title,
l.c_id lid,
l.c_strshortname,
l.C_STRCORPNAME,
l.c_strshortname || p.c_packname corppack,
p.c_id pid,
p.c_packname,
p.c_packcode,
nvl(a.c_qty, 0) c_qty,
o.c_stockorder,
c.c_bzname,
c.c_strprodname,
c.c_nocodeid,
c.C_MEASUNIT,
c.C_PRICEDW,
a.c_iftax,
a.c_price,
(select c_explain
from t_supplierenter
where c_project = p.c_project
and c_supplierid = s.c_supplier) explain,
decode(s.c_resultstatus, '1', '已签收', '未签收') c_rs
from t_bidpacksupp s
left join t_bidpackorder o
on o.c_bidpack = s.c_bidpack
left join t_stockaffirmpart a
on s.c_supplier = a.c_supplier
and a.c_bidpack = s.c_bidpack
and a.c_stockorder = o.c_stockorder
left join t_bidpack p
on s.c_bidpack = p.c_id
left join t_stockorder c
on c.c_id = o.c_stockorder
left join t_supplier l
on l.c_id = s.c_supplier
left join t_bidattachment f
on f.c_project = p.c_project
and f.c_supplier = s.c_supplier
and f.c_type = 14
where p.c_project = 7741848774
and p.c_process <> 7741075449
order by l.c_id, p.c_id, o.c_stockorder) t
where rownum <= 50)
where r > 0
报无效数字,可能是字段匹配时类型不一样,修改如下即可:
select *
from (select rownum r, t.*
from (select s.c_id,
f.c_id fileid,
f.c_title title,
l.c_id lid,
l.c_strshortname,
l.C_STRCORPNAME,
l.c_strshortname || p.c_packname corppack,
p.c_id pid,
p.c_packname,
p.c_packcode,
nvl(a.c_qty, 0) c_qty,
o.c_stockorder,
c.c_bzname,
c.c_strprodname,
c.c_nocodeid,
c.C_MEASUNIT,
c.C_PRICEDW,
a.c_iftax,
a.c_price,
(select c_explain
from t_supplierenter
where c_project = p.c_project
and c_supplierid = s.c_supplier) explain,
decode(s.c_resultstatus, '1', '已签收', '未签收') c_rs
from t_bidpacksupp s
left join t_bidpackorder o
on o.c_bidpack = s.c_bidpack
left join t_stockaffirmpart a
on s.c_supplier = a.c_supplier
and a.c_bidpack = s.c_bidpack
and a.c_stockorder = o.c_stockorder
left join t_bidpack p
on s.c_bidpack = p.c_id
left join t_stockorder c
on c.c_id = o.c_stockorder
left join t_supplier l
on l.c_id = s.c_supplier
left join t_bidattachment f
on f.c_project = to_char(p.c_project) --修改此处
and f.c_supplier = to_char(s.c_supplier) --修改此处
and f.c_type = 14
where p.c_project = 7741848774
and p.c_process <> 7741075449
order by l.c_id, p.c_id, o.c_stockorder) t
where rownum <= 50)
where r > 0