SELECT ooha.order_number,
       moqd.primary_transaction_quantity onhand_qty
FROM   oe_order_headers_all ooha,
       oe_order_lines_all oola,
       mtl_onhand_quantities_detail moqd
WHERE  1 = 1
       AND ooha.header_id = oola.header_id
       AND oola.ship_from_org_id = moqd.organization_id
       AND oola.inventory_item_id = moqd.inventory_item_id; 

SELECT ooha.order_number,
       moqd.primary_transaction_quantity onhand_qty
FROM   oe_order_headers_all ooha,
       mtl_onhand_quantities_detail moqd
WHERE  ooha.header_id IN (SELECT oola.header_id
                          FROM oe_order_lines_all oola
                          WHERE oola.ship_from_org_id = moqd.organization_id
                          AND oola.inventory_item_id = moqd.inventory_item_id);