eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_LOAD_ENR_PVT dependencies on OKI_COV_PRD_LINES

Line 16: -- the join condition to join with Oki_cov_prd_lines

12: -- 19-Dec-2002 brrao UTF-8 Changes to Org Name
13: --
14: -- 29-Oct-2003 axraghav Modified l_exp_not_rnw_csr in calc_enr_dtl1 to
15: -- populate null values form salesrep name,modified
16: -- the join condition to join with Oki_cov_prd_lines
17: -- Modified calc_enr_dtl1 to populate null values
18: -- for customer and organization names
19: -- Modified l_cust_id_csr in calc_enr_dtl2 to populate
20: -- null values for customer and organization names

Line 23: -- the join condition to join with Oki_cov_prd_lines

19: -- Modified l_cust_id_csr in calc_enr_dtl2 to populate
20: -- null values for customer and organization names
21: -- Modified l_exp_not_rnw_csr in calc_enr_dtl2 to
22: -- populate null values form salesrep name,modified
23: -- the join condition to join with Oki_cov_prd_lines
24: -- Modified calc_enr_sum to populate
25: -- null values for customer and organization names
26: --------------------------------------------------------------------------------
27:

Line 290: oki_cov_prd_lines cpl

286: , NVL(SUM(cpl/*11510 change ocl*/.base_price_negotiated), 0) base_price_negotiated_amount
287: -- display number in correct number format
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 */

Line 506: FROM /11510 change removed oki_expired_lines oel added oki_cov_prd_lines /

502: -- display consolidate amount in correct currency format
503: , NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated_amount
504: -- display number in correct number format
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

Line 507: oki_cov_prd_lines cpl

503: , NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated_amount
504: -- display number in correct number format
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*/

Line 714: oki_cov_prd_lines cpl

710: NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated_amount
711: -- display number in correct number format
712: , COUNT(DISTINCT (shd.chr_id )) contract_count
713: FROM /*11510 change removed oki_expired_lines oel*/
714: oki_cov_prd_lines cpl
715: , oki_sales_k_hdrs shd
716: WHERE shd.chr_id = cpl.chr_id
717: /*11510 change start*/
718: AND cpl.is_exp_not_renewed_yn = 'Y'