How is a delivery line (WSH_DELIVERY_DETAILS) linked to (OE_ORDER_HEADERS_ALL) ?
Posted: 29 November 2007 01:52 PM
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 06:56 PM   [ # 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: 05 January 2008 04:40 AM   [ # 2 ]
Newbie
Rank
Total Posts:  3
Joined  2008-01-05

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 02:06 PM   [ # 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