Tuesday, March 22, 2016

Query to Check PO Quantities received for an item in a given date range



Query to Check PO Quantities received for an item in a given date range
select pha. creation_date, pha. po_header_id, sum(pla. quantity_committed), sum(rsl. quantity_received) from apps. po_headers_all pha,
po_lines_all pla,
rcv_shipment_lines rsl
where pha. po_header_id = pla. po_header_id
and trunc(pha. creation_date) between '01-APR-14' and '08-APR-14'
and pha. org_id = 82
and pla. item_id = 4389
and rsl. po_line_id = pla. po_line_id
and rsl. to_organization_id = 95
group by pha. creation_date, pha. po_header_id
order by pha. creation_date



No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...