Query to Join EBS Order Headers and Order Lines

 

SELECT * FROM OE_ORDER_HEADERS_ALL ooha INNER JOIN OE_ORDER_LINES_ALL oola ON ooha.header_id = oola.header_id;

This query will return all rows from the OE_ORDER_HEADERS_ALL table, and the corresponding rows from the OE_ORDER_LINES_ALL table, where the header_id column in both tables is equal.

The OE_ORDER_HEADERS_ALL table contains information about sales orders, such as the order number, order date, and customer name. The OE_ORDER_LINES_ALL table contains information about the individual line items on a sales order, such as the product number, quantity ordered, and unit price.

This query can be used to retrieve information about all the line items on a sales order, or to retrieve information about all the sales orders that have been placed by a particular customer.