SELECT a.qty_invoiced,a.mprice,a.line_total,a.uom1_id,a.uom2_id,a.uom3_id, web_uom1_qty,web_uom2_qty,web_uom3_qty ,p.item_name,b.invoice_no,p.item_id, * FROM txn_invoice_history_detail a
inner join txn_invoice_history_header b on a.invoice_id= b.invoice_id 
inner join txn_sales_order_header c on  a.sales_order_id= c.ord_hdr_id
inner join product_item p on a.item_id= p.Item_id
--c91275df-2668-4233-ae59-8c3d3b9f0b59
 WHERE  a.INVOICE_ID= 'd0e9262d-0803-4132-ac9f-2ed7be9cead5' and 
 c.ord_hdr_id= 'c91275df-2668-4233-ae59-8c3d3b9f0b59'