SELECT

i.lottable02 供应商代码,

sr.company 供应商名称,

o.consigneekey 发货地,

TO_CHAR (o.requestedshipdate + 8 / 24,'yyyy-mm-dd hh24:mi:ss') 需求时间,

o.notes 需求订单,

i.sku 物料编码,

s.susr1 物料组,

s.descr 物料名称,

i.lottable08 寄存属性,

sum(i.qty) 数量

FROM

(

SELECT

*

FROM

itrn

WHERE

trantype = 'WD'

) i

JOIN sku s ON i.sku = s.sku

WHERE

EXISTS (

SELECT

*

FROM

storer AS sr

WHERE

i.lottable02 = sr.storerkey

AND type = 2

)

AND EXISTS (

SELECT

*

FROM

orders AS o

WHERE

o.orderkey = substr(i.sourcekey, 0, 10)

)

group by

    i.lottable02,

sr.company,

o.consigneekey,

TO_CHAR (o.requestedshipdate + 8 / 24,'yyyy-mm-dd hh24:mi:ss'),

o.notes,

i.sku,

s.susr1,

s.descr,

i.lottable08

代码不全，没有group by

TO_CHAR(o.requestedshipdate + 8 / 24, 'yyyy-mm-dd hh24:mi:ss') 需求时间,

这一块  +8 / 24？  是+3？  这个时间可以直接运算的？