Query to find out Move order line details :

SELECT   wnd.delivery_id,
         wnd.name delivery_name,
         wnd.initial_pickup_location_id,
         mtrh.request_number mo_number,
         mtrl.line_number mo_line_number,
         mtrl.line_id mo_line_id,
         mtrl.from_subinventory_code,
         mtrl.to_subinventory_code,
         mtrl.lot_number,
         mtrl.serial_number_start,
         mtrl.serial_number_end,
         mtrl.uom_code,
         mtrl.quantity,
         mtrl.quantity_delivered,
         mtrl.quantity_detailed,
         wdd.source_header_number so_order_number,
         oola.line_number so_line_number,
         wdd.source_header_id so_header_id,
         wdd.source_line_id so_line_id,
         wdd.shipping_instructions,
         wdd.inventory_item_id,
         wdd.requested_quantity_uom,
         msi.description item_description,
         msi.revision_qty_control_code,
         wdd.ship_method_code carrier,
         wdd.shipment_priority_code priority,
         wdd.organization_id,
         wdd.released_status,
         wdd.source_code
  FROM   mtl_system_items_vl msi,
         oe_order_lines_all oola,
         mtl_txn_request_lines mtrl,
         mtl_txn_request_headers mtrh,
         wsh_delivery_details wdd,
         wsh_delivery_assignments wda,
         wsh_new_deliveries wnd
 WHERE       wnd.delivery_id = 18910
         AND wda.delivery_id = wnd.delivery_id(+)
         AND wdd.delivery_detail_id = wda.delivery_detail_id
         AND wdd.move_order_line_id = mtrl.line_id
         AND mtrl.header_id = mtrh.header_id
         AND wdd.inventory_item_id = msi.inventory_item_id(+)
         AND wdd.organization_id = msi.organization_id(+)
         AND wdd.source_line_id = oola.line_id
         AND wdd.source_header_id = oola.header_id
/