Query to find Contract Number from Order Number

 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