SQL Language (MOSC)

MOSC Banner

Simple query question but it eludes me...

edited Jul 9, 2010 7:02AM in SQL Language (MOSC) 2 commentsAnswered ✓
 Hello all,
I am trying to write a query to to find out how many closed, multiple deliveries sales orders by org.

Currently it looks like this:
select count (SOURCE_HEADER_NUMBER)
from wsh_delivery_details WDD, OE_ORDER_HEADERS_ALL OEH
WHERE WDD.RELEASED_STATUS = 'C'
AND WDD.ORG_ID = '122'
AND WDD.SOURCE_HEADER_ID = OEH.HEADER_ID

I believe this is giving me all the shipments for each given SO.  Right?

So how do I segregate just the multiple deliveries?

Thanks for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center