Query to join delivery details and MTL Material Table

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 apps. wsh_delivery_details WDD,
Apps. mtl_material_transactions MTL,
Apps. 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 ';

 

Also below is query to join order line with mtl_material_transactions

Select MTL. transaction_id, L. flow_status_code, L. open_flag, L. cancelled_flag, L. shipped_quantity

From mtl_material_transactions MTL, oe_order_lines_all L where MTL. trx_source_line_id = L. line_id