
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
ReplyDeleteOur knowledge is truly enhanced after reading this. It was quite useful. we are truly glad that you shared this with us. Here is a referred blog that I have found same as yours oracle fusion financials training. while browsing, i came across this one, it's useful and will be providing necessary knowledge too.
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