join between mtl_material_transactions and oe_order_lines_all

Join between mtl_material_transactions and oe_order_lines_all

 

In this post, We will get the join between the mtl_material_transactions and oe_order_lines_all. If you want to see the material tranactions involved for each shipment of sale order , you will refer this complete information in this sql query. We do join between mtl_material_transactions and oe_order_lines_all using the wsh_delivery_details table. This table Delviery detail id joins between the mtl_material_transactions and oe_order_lines_all

 

Table Involved to join between mtl_material_transactions and oe_order_lines_all

 

wsh_delivery_details

mtl_material_transactions

oe_order_lines_all

SELECT   wdd.source_header_number,

         wdd.source_line_id,

         wdd.delivery_detail_id,

         wdd.released_status,

         oe_interfaced_flag,

         inv_interfaced_flag,

         wdd.creation_date,

         mtl.transaction_id,

         l.flow_status_code,

         l.open_flag,

         l.cancelled_flag

  FROM   wsh_delivery_details wdd,

         mtl_material_transactions mtl,

         oe_order_lines_all l

 WHERE       l.line_id = wdd.source_line_id

         AND wdd.delivery_Detail_id = mtl.picking_line_id

         AND wdd.source_code = 'OE'

         AND wdd.oe_interfaced_flag = 'Y'

         AND wdd.released_status = 'Y'

 

oe_order_lines_all