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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...