PO_HEADERS_ALL
----------------------------
This table stores the information of purchase order, supplier, operating unit id, po status , etc details.
SELECT *
FROM PO_HEADERS_ALL
WHERE SEGMENT1 = :PURCHASE_ORDER_NUMBER.
One PO can have multiple PO lines in PO_LINES_ALL table. Join condition between PO_HEADERS_ALL and PO_LINES_ALL is using PO_HEADER_ID in both the tables.
PO_LINES_ALL
----------------------
This table stores the information of line level data. This table helps to identify the item, unit price, quantity for the goods being purchased. A single PO line can have multiple shipments.
SELECT *
FROM PO_LINES_ALL
WHERE PO_HEADER_ID = :P_HEADER_ID (PO_HEADER_ID from PO_HEADERS_ALL table)
PO_LINE_LOCATIONS_ALL
---------------------------------------
This table stores the information of line location level data. This information helps to identify ship to location of the goods being purchased. This table can be joined to the PO_HEADERS_ALL, PO_LINES_ALL with help of PO_HEADER_ID and PO_LINE_ID from above tables.
PO_DISTRIBUTIONS_ALL
------------------------------------
This table stores the information of distribution level data. This information helps to identify the PO distribution account for which being charged for the goods or items being purchased over the PO.
