Search from 700 + Posts

Jan 20, 2011

Query to connect Order Sales Order Header and MTL Sales Order Table

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

1 comment: