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_WBC_PVT dependencies on OKI_COV_PRD_LINES

Line 341: /11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines/

337: , p_customer_party_id IN NUMBER
338: , p_scs_code IN VARCHAR
339: ) IS
340: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
341: /*11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines*/
342: FROM oki_cov_prd_lines cpl
343: , oki_sales_k_hdrs shd
344: WHERE shd.chr_id = cpl.chr_id
345: /*11510 change start*/

Line 342: FROM oki_cov_prd_lines cpl

338: , p_scs_code IN VARCHAR
339: ) IS
340: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
341: /*11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines*/
342: FROM oki_cov_prd_lines cpl
343: , oki_sales_k_hdrs shd
344: WHERE shd.chr_id = cpl.chr_id
345: /*11510 change start*/
346: AND cpl.is_exp_not_renewed_yn='Y'

Line 608: /11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines/

604: , p_customer_party_id IN NUMBER
605: , p_scs_code IN VARCHAR2
606: ) IS
607: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
608: /*11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines*/
609: FROM oki_cov_prd_lines cpl
610: , oki_sales_k_hdrs shd
611: -- expiration date is in the period
612: WHERE shd.chr_id = cpl.chr_id

Line 609: FROM oki_cov_prd_lines cpl

605: , p_scs_code IN VARCHAR2
606: ) IS
607: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
608: /*11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines*/
609: FROM oki_cov_prd_lines cpl
610: , oki_sales_k_hdrs shd
611: -- expiration date is in the period
612: WHERE shd.chr_id = cpl.chr_id
613: /*11510 change start*/

Line 861: /11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines/

857: , p_glpr_end_date IN DATE
858: , p_customer_party_id IN NUMBER
859: ) IS
860: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
861: /*11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines*/
862: FROM oki_cov_prd_lines cpl
863: , oki_sales_k_hdrs shd
864: -- expiration date is in the period
865: WHERE shd.chr_id = cpl.chr_id

Line 862: FROM oki_cov_prd_lines cpl

858: , p_customer_party_id IN NUMBER
859: ) IS
860: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
861: /*11510 change removed oki_Expired_lines and joined to oki_cov_prd_lines*/
862: FROM oki_cov_prd_lines cpl
863: , oki_sales_k_hdrs shd
864: -- expiration date is in the period
865: WHERE shd.chr_id = cpl.chr_id
866: /*11510 change start*/