Query to connect Oracle Sales Order Header (OE_ORDER_HEADERS_ALL) and MTL Sales Order(MTL_SALES_ORDER) Table
SELECT s.sales_order_id,s.segment1, s.segment2,s.segment3,h.order_number,h.flow_status_code,
h.sold_to_org_id,h.open_flag
FROM mtl_sales_orders s,
oe_order_headers_all h
WHERE s.segment1 = TO_CHAR(h.order_number)
AND s.segment2 = &order_type_name --Enter Transaction Type
AND s.segment3 = &source_code -- Enter Order Source
Thank U - Saravanan S!!!
ReplyDelete