Query to find OKS Number linked to OM

SELECT od.order_line_id1 OKS_OM_LINK,           

       od.chr_id OKS_ID,
       cb.contract_number,
       cb.contract_number_modifier,
       cb.start_date OKS_START_DATE,
       cb.end_date OKS_END_DATE
  FROM apps.oks_k_order_details od,
       apps.okc_k_headers_all_b cb
 WHERE 1 = 1
   AND od.chr_id = cb.id