![Query for to get PO Headers total Amount, AskHareesh Blog for Oracle Apps](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn2kfj9-T_DuHWVgVVDvsvy0VhpVBubDUvFI9NnZZ0CgG3b9KkLLd4M7xh9RydlWRJMZCaI3QGqYsUS4fCQvSuWyVASZdVRpDiOvcCgV_Q7J3UEJ_ABxNQhVEHhqUU6zpCuisKKsciqtU/s1600/Query+for+to+get+PO+Headers+total+Amount.png)
Query for to get PO Headers total Amount
select pha.segment1 po_num, sum ( (pla.unit_price * pla.quantity)) price from po_lines_all pla, po_headers_all pha where pla.po_header_id = pha.po_header_id and pha.type_lookup_code in ('STANDARD', 'BLANKET') --Add as per your requirement --and pha.segment1 = '506' --and pha.org_id = 204 --Use when you have multiple OU group by pha.segment1
nice blog
ReplyDeleteHi dear so actually i want a query for total release amount in blank purchase agreement so could you please help me out of this anyone know how to write a query to "TotalRelaseamount". Please anyone
ReplyDeleteFor service item if qty is not mentioned, it is considering as 0 and Po value is coming as 0 in the output
ReplyDelete