SELECT shipment_detail.id_shipment,shipment_detail.part_number,shipment_detail.pallet_id,shipment_detail.quantity,shipment_detail.item_net_weight,shipment_detail.uom,shipment_detail.oa_number,items.part_description_eng,items.product_hierarchy, order_acknowledgement.order_date
FROM shipment_detail
LEFT JOIN shipment ON shipment.id_shipment = shipment_detail.id_shipment
LEFT JOIN items ON items.part_number =. shipment_detail.part_number
LEFT JOIN order_acknowledgement ON order_acknowledgement.order_no = shipment_detail.oa_number
JOIN price_list_detail ON price_list_detail.part_number = shipment_detail.part_number
JOIN price_list ON price_list.id_price = price_list_detail.id_price
WHERE shipment_detail.customer = "0000004103" AND shipment.awb_number = "77381471";