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.

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

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!

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