Oracle Transactional Business Intelligence

Products Banner

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

Received Response
25
Views
1
Comments

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?

Answers