Invoice_detail_history.txt
1 |
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 |
---|---|
2 |
inner join txn_invoice_history_header b on a.invoice_id= b.invoice_id |
3 |
inner join txn_sales_order_header c on a.sales_order_id= c.ord_hdr_id |
4 |
inner join product_item p on a.item_id= p.Item_id |
5 |
--c91275df-2668-4233-ae59-8c3d3b9f0b59 |
6 |
WHERE a.INVOICE_ID= 'd0e9262d-0803-4132-ac9f-2ed7be9cead5' and |
7 |
c.ord_hdr_id= 'c91275df-2668-4233-ae59-8c3d3b9f0b59' |