How to Join DOO_HEADERS_ALL table with PO_HEADERS_ALL or PO_LINES_ALL table?

Question

I need Order number from DOO_headers_all, then item description from PO_LINES_ALL, also I need receipt_number and invoice number.

HEADER_ID is not matching with PO_HEADER_ID or SEGMENT1.

John Hung-Oracle · Answer

To better serve you, please post this in the Reporting and Analytics for SCM forum since its specific to SCM subject areas/use cases. Thank you.