How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ? 
Posted: 29 November 2007 05:52 AM   [ Ignore ]
Newbie
Rank
Total Posts:  25
Joined  2007-06-08

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.

Profile
 
 
Posted: 03 December 2007 10:56 AM   [ Ignore ]   [ # 1 ]
Newbie
Avatar
Rank
Total Posts:  18
Joined  2005-07-20

Hi,

You should try the source_header_id and the source_line_id which are connected to the header_id and the line_id of the oe_order_lines_all table.

Good Luck,

Daan Bakboord

Profile
 
 
Posted: 04 January 2008 08:40 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  3
Joined  2008-01-04

select *
from
apps.oe_order_headers_all ooh
, apps.oe_order_lines_all ool
, apps.wsh_delivery_details dd
, apps.wsh_delivery_assignments da
, apps.wsh_new_deliveries nd
where
AND nd.delivery_id = da.delivery_id
AND dd.delivery_detail_id = da.delivery_detail_id
AND dd.source_line_id = ool.line_id
AND dd.source_header_id = ool.header_id
AND ool.header_id = ooh.header_id
;

good luck!

Profile
 
 
Posted: 13 November 2009 06:06 AM   [ Ignore ]   [ # 3 ]
Newbie
Rank
Total Posts:  1
Joined  2009-11-13

Any further updates on this thread?  Think the thread starter had already forgotten bout this one. This must be closed.

Regards,
chelseadock
PrĂȘt travaux

Profile