16 lines
362 B
SQL
16 lines
362 B
SQL
--any actual splits should be entered
|
|
--by prepending P2- or similar into the PO
|
|
--also need to update the SL_ECOMM table
|
|
--most important is not to duplicate the
|
|
--invoice elements
|
|
select
|
|
CUSORDREF_0,
|
|
count(CUSORDREF_0)
|
|
from PROD.SORDER SOH
|
|
where
|
|
SOH.SOHTYP_0 = 'WEB'
|
|
and SOH.STOFCY_0 in ('SSB','SMB')
|
|
group by
|
|
CUSORDREF_0
|
|
having
|
|
count(CUSORDREF_0) > 1 |