SELECT ooh.order_number ,
                hp_bill.party_name ,
                hl_ship.address1 ship_to_address ,
                hl_bill.address1 bill_to_address ,
                ooh.transactional_curr_code currency_code ,
                mp.organization_code , 
                ooh.fob_point_code ,
                ooh.freight_terms_code ,
                ooh.cust_po_number
FROM oe_order_headers_all ooh ,
             hz_cust_site_uses_all hcs_ship ,
             hz_cust_acct_sites_all hca_ship ,
             hz_party_sites hps_ship ,
             hz_parties hp_ship ,
             hz_locations hl_ship ,
             hz_cust_site_uses_all hcs_bill ,
             hz_cust_acct_sites_all hca_bill ,
             hz_party_sites hps_bill ,
             hz_parties hp_bill , 
             hz_locations hl_bill ,
             mtl_parameters mp
WHERE header_id = Your Header Id
AND ooh.ship_to_org_id = hcs_ship.site_use_id
AND hcs_ship.cust_acct_site_id = hca_ship.cust_acct_site_id
AND hca_ship.party_site_id = hps_ship.party_site_id
AND hps_ship.party_id = hp_ship.party_id
AND hps_ship.location_id = hl_ship.location_id
AND ooh.invoice_to_org_id = hcs_bill.site_use_id
AND hcs_bill.cust_acct_site_id = hca_bill.cust_acct_site_id
AND hca_bill.party_site_id = hps_bill.party_site_id
AND hps_bill.party_id = hp_bill.party_id
AND hps_bill.location_id = hl_bill.location_id
AND mp.organization_id(+) = ooh.ship_from_org_id

Reference: https://oracleerp.groupsite.com/discussion/topic/show/214461?lpx=1