+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle E-Business Suite (EBS) (http://www.oraerp.com/forum-1.html)
+---- Forum: Purchasing, Inventory & Order Management (http://www.oraerp.com/forum-3.html)
+---- Thread: How to get PO Quantity in order management (/thread-71230.html)
How to get PO Quantity in order management - Ali Rizwan - 11-18-2014
Hello,
I want to know what is the way to collect PO quantity in order management?
i will be thankfull for ans
RE: How to get PO Quantity in order management - Balin Chakra - 01-14-2015
are u requried Sql query? am i right....
RE: How to get PO Quantity in order management - ajkhan80 - 01-14-2015
Hi,
Collect Po quentity in OM? please explain little bit more what you require exactly? Thanks
RE: How to get PO Quantity in order management - Ali Rizwan - 01-15-2015
Yes. am required Sql query for PO quantity....?
RE: How to get PO Quantity in order management - Emily Sarah - 01-15-2015
Can anybody help him abount Sql query.
RE: How to get PO Quantity in order management - Divya Omkar - 01-19-2015
You can use this query by changing according to your:
SELECT po.segment1 po_blanket_num
FROM po_requisition_headers_all prh,
po_requisition_lines_all prl,
po_line_locations_all poll,
po_headers_all poh,
oe_drop_ship_sources oed,
hr_all_organization_units hr
WHERE prh.requisition_header_id = prl.REQUISITION_HEADER_ID
AND hr.organization_id = poh.org_id
AND prl.line_location_id = poll.line_location_id
AND poh.po_header_id = poll.po_header_id
AND oed.line_location_id = poll.line_location_id