How can I join the DOO_HEADERS_ALL table with PO tables like PO_LINES_ALL in Oracle Fusion ?

Question

I’m working on a BI report for order and item details like order number and item number and description in Oracle Fusion, and I need to join the DOO_HEADERS_ALL table with other PO tables like PO_LINES_ALL. However, there’s no direct common column between them. How can I effectively link these tables to retrieve relevant information for my report?

John Hung-Oracle · Answer

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