DBA Data[Home] [Help]

APPS.OKI_LOAD_ENR_PVT dependencies on OKI_K_SALESREPS

Line 292: , oki_k_salesreps slr

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 */

Line 509: , oki_k_salesreps slr

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*/