Sunday, March 20, 2016

Query to get the delivery Order ,order_status ,ordered quantity and shipped quantity details

SELECT
OOH.ORDER_NUMBER
,WDD.RELEASED_STATUS
,WDD.ITEM_DESCRIPTION
,OOL.ORDERED_QUANTITY
,wdd.shipped_quantity
from
OE_ORDER_LINES_ALL OOL,
oe_order_headers_all ooh,
WSH_DELIVERY_DETAILS WDD
WHERE 1=1
AND wdd.source_header_id = ool.header_id
and WDD.SOURCE_LINE_ID = OOL.LINE_ID
and OOH.HEADER_ID=OOL.HEADER_ID

and ORDER_NUMBER='5345';

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect