What is the link between sales order and purchase order in Oracle R12

Question

I need a query to get the sales order related PO number in R12

Answer 1

this helps you:

SELECT *
FROM oe_drop_ship_sources
WHERE header_id = (SELECT header_id
FROM oe_order_headers_all
WHERE order_number = '1005')

Comments

I can see only Po HeaderID and PO lineID but not the PO NUmber