17,377
社区成员
发帖
与我相关
我的任务
分享
select '' id,
to_char(sum(Order_MONEY), 'FM99,999,999,990.00') as Order_MONEY,
to_char(sum(Stock_up_MONEY), 'FM99,999,999,990.00') as Stock_up_MONEY,
to_char(sum(RECEIVE_MONEY), 'FM99,999,999,990.00') as RECEIVE_MONEY
from (
select *
from (select t.id as id,
t.ABBR as plat_name,
t.name as platn,
to_char(decode(b.Order_MONEY, null, '0', b.Order_MONEY),
'FM99999999990.00') as Order_MONEY,
to_char(decode(c.Stock_up_MONEY,
null,
'0',
c.Stock_up_MONEY),
'FM99999999990.00') as Stock_up_MONEY,
to_char(decode(d.RECEIVE_MONEY,
null,
'0',
d.RECEIVE_MONEY),
'FM99999999990.00') as RECEIVE_MONEY
from b, c, d, s_supply_plat t
where t.id = c.plat_id(+)
and t.id = d.plat_id(+)
and t.id = b.plat_id(+))
where 1 = 1)
select '' id,
to_char(sum(Order_MONEY), 'FM99,999,999,990.00') as Order_MONEY,
to_char(sum(Stock_up_MONEY), 'FM99,999,999,990.00') as Stock_up_MONEY,
to_char(sum(RECEIVE_MONEY), 'FM99,999,999,990.00') as RECEIVE_MONEY
from (
select *
from (select t.id as id,
t.ABBR as plat_name,
t.name as platn,
to_char(decode(b.Order_MONEY, null, '0', b.Order_MONEY),
'FM99,999,999,990.00') as Order_MONEY,
to_char(decode(c.Stock_up_MONEY,
null,
'0',
c.Stock_up_MONEY),
'FM99,999,999,990.00') as Stock_up_MONEY,
to_char(decode(d.RECEIVE_MONEY,
null,
'0',
d.RECEIVE_MONEY),
'FM99,999,999,990.00') as RECEIVE_MONEY
from b, c, d, s_supply_plat t
where t.id = c.plat_id(+)
and t.id = d.plat_id(+)
and t.id = b.plat_id(+))
where 1 = 1)