SELECT ooha.order_number
, okhb.contract_number
, okhb.contract_number_modifier
FROM oe_order_headers_all ooha
, okc_k_rel_objs rel
, okc_k_headers_all_b okhb
WHERE rel.chr_id = okhb.ID
AND rel.jtot_object1_code =
'OKX_ORDERHEAD'
AND rel.object1_id1 =
ooha.header_id
AND ooha.org_id = okhb.org_id
AND ooha.order_number =
'111111111'--Order_Number
