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_SALES_K_HDRS

Line 292: FROM oki_sales_k_hdrs shd

288: , p_customer_party_id IN NUMBER
289: , p_scs_code IN VARCHAR2
290: ) IS
291: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
292: FROM oki_sales_k_hdrs shd
293: -- Contract is a renewal contract
294: WHERE shd.is_new_yn IS NULL
295: -- Contract must have undergone forecasting
296: AND shd.close_date IS NOT NULL

Line 316: FROM oki_sales_k_hdrs shd

312: , p_customer_party_id IN NUMBER
313: , p_scs_code IN VARCHAR
314: ) IS
315: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
316: FROM oki_sales_k_hdrs shd
317: -- Contract is a renewal contract
318: WHERE shd.is_new_yn IS NULL
319: -- Contract is signed or active
320: AND shd.ste_code IN ('SIGNED', 'ACTIVE')

Line 343: , oki_sales_k_hdrs shd

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'
347: /*11510 change start*/

Line 362: FROM oki_sales_k_hdrs shd

358: , /*11510 change*/ NULL customer_name
359: , shd.authoring_org_id authoring_org_id
360: , /*11510 change*/ NULL authoring_org_name
361: , shd.scs_code scs_code
362: FROM oki_sales_k_hdrs shd
363: ;
364:
365:
366: BEGIN

Line 563: FROM oki_sales_k_hdrs shd

559: , p_customer_party_id IN NUMBER
560: , p_scs_code IN VARCHAR2
561: ) IS
562: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
563: FROM oki_sales_k_hdrs shd
564: -- Contract is a renewal contract
565: WHERE shd.is_new_yn IS NULL
566: -- Contract must have undergone forecasting
567: AND shd.close_date IS NOT NULL

Line 585: FROM oki_sales_k_hdrs shd

581: , p_customer_party_id IN NUMBER
582: , p_scs_code IN VARCHAR2
583: ) IS
584: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
585: FROM oki_sales_k_hdrs shd
586: -- Contract is a renewal contract
587: WHERE shd.is_new_yn IS NULL
588: -- Contract is signed or active
589: AND shd.ste_code IN ('SIGNED', 'ACTIVE')

Line 610: , oki_sales_k_hdrs shd

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*/
614: AND cpl.is_exp_not_renewed_yn = 'Y'

Line 627: FROM oki_sales_k_hdrs shd ;

623: CURSOR l_cust_id_csr IS
624: SELECT DISTINCT(shd.customer_party_id) customer_id
625: , /*11510 change*/NULL customer_name
626: , shd.scs_code
627: FROM oki_sales_k_hdrs shd ;
628:
629:
630: BEGIN
631:

Line 822: FROM oki_sales_k_hdrs shd

818: , p_glpr_end_date IN DATE
819: , p_customer_party_id IN NUMBER
820: ) IS
821: SELECT NVL(SUM(shd.base_forecast_amount), 0) base_forecast_amount
822: FROM oki_sales_k_hdrs shd
823: -- Contract is a renewal contract
824: WHERE shd.is_new_yn IS NULL
825: -- Contract must have undergone forecasting
826: AND shd.close_date IS NOT NULL

Line 841: FROM oki_sales_k_hdrs shd

837: , p_glpr_end_date IN DATE
838: , p_customer_party_id IN NUMBER
839: ) IS
840: SELECT NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
841: FROM oki_sales_k_hdrs shd
842: -- Contract is a renewal contract
843: WHERE shd.is_new_yn IS NULL
844: -- Contract is signed or active
845: AND shd.ste_code IN ('SIGNED', 'ACTIVE')

Line 863: , oki_sales_k_hdrs shd

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*/
867: AND cpl.is_exp_not_renewed_yn = 'Y'

Line 878: FROM oki_sales_k_hdrs shd

874: -- Cusror to get all the customers
875: CURSOR l_cust_id_csr IS
876: SELECT DISTINCT(shd.customer_party_id) customer_id,
877: /*11510 Change*/ NULL customer_name
878: FROM oki_sales_k_hdrs shd
879: ;
880:
881:
882: BEGIN