OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS

Home » Applications » Oracle Fusion Apps & E-Business Suite » How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ? [message #284149]

Thu, 29 November 2007 00:55

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.

Report message to a moderator

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

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

Report message to a moderator

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

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

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

Report message to a moderator

Previous Topic:	Data collections
Next Topic:	oracle table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 10:49:03 CDT 2024