Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
How to get PO Quantity in order management - Printable Version

+- 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