Home » Applications » Oracle Fusion Apps & E-Business Suite » How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ?
How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ? [message #284149] Thu, 29 November 2007 00:55 Go to next message
vishalaksha
Messages: 16
Registered: September 2007
Junior Member
How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ?
If anyone can throw some light on it then it would be good for me.

Thanks.
Re: How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ? [message #284328 is a reply to message #284149] Thu, 29 November 2007 06:49 Go to previous messageGo to next message
tarmenel
Messages: 63
Registered: February 2007
Location: Israel
Member

SELECT wnd.delivery_id, wdd.source_header_id, wdd.source_line_id, ool.line_number
FROM   wsh_new_deliveries       wnd,
       wsh_delivery_assignments wda,
       wsh_delivery_details     wdd,
       oe_order_lines_all       ool
WHERE  wdd.source_line_id = ool.line_id
AND    wdd.delivery_detail_id = wda.delivery_detail_id
AND    wda.delivery_id = wnd.delivery_id
AND    wnd.delivery_id = 113035
Re: How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ? [message #284525 is a reply to message #284149] Fri, 30 November 2007 00:00 Go to previous messageGo to next message
vishalaksha
Messages: 16
Registered: September 2007
Junior Member
Hi tarmenel
Is delivery_id in wsh_new_deliveries used to track the order number?

[Updated on: Fri, 30 November 2007 00:02]

Report message to a moderator

Re: How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ? [message #285061 is a reply to message #284525] Mon, 03 December 2007 04:29 Go to previous message
brightraj
Messages: 8
Registered: November 2007
Junior Member
Hi,

The delivery_id is generated in wsh_delivery_assignemnts. This id can be used in shipping transactions. As you said the order number can also be tracked in the backend using the join conditions.
i.e. shipping->transactions (query using the delivery_id and ship it).

Regards,

brightraj
Previous Topic: Data collections
Next Topic: oracle table
Goto Forum:
  


Current Time: Sat Dec 10 04:43:43 CST 2016

Total time taken to generate the page: 0.14497 seconds