288: , COUNT(DISTINCT (shd.chr_id )) contract_count
289: FROM /*11510 change removed oki_expired_lines oel */
290: oki_cov_prd_lines cpl
291: , oki_sales_k_hdrs shd
292: , oki_k_salesreps slr
293: WHERE shd.chr_id = /*oel*/cpl.chr_id
294: /*11510 changes start */
295: AND cpl.is_exp_not_renewed_yn = 'Y'
296: /*11510 changes end */
505: , COUNT(DISTINCT (shd.chr_id )) contract_count
506: FROM /*11510 change removed oki_expired_lines oel added oki_cov_prd_lines */
507: oki_cov_prd_lines cpl
508: , oki_sales_k_hdrs shd
509: , oki_k_salesreps slr
510: WHERE shd.chr_id = cpl.chr_id
511: /*11510 change start*/
512: AND cpl.is_exp_not_renewed_yn = 'Y'
513: /*11510 change end*/