How to find the source order of a copied order?

[Balasubramanian]

Hi,
How to find the source order of a copied order?
In the oe_order_headers_all table, the order_source_id and source_document_type_id fields does not give the order header id of the parent order from which the copy has been made.

Where exactly we can find the parent and child order details for a copied sales orders.

[prabhakar]

In Oe_order_headers_all
there is a column called ORIG_SYS_DOCUMENT_REF
which will give u the source if the order_source_id and source_document_type_id doesnt have any values in it.

regardss
Prabhakaran.R

[Balasubramanian]

Got it now.Source_document_id gives the source order for a copied order.

Thanks.