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_RBS_PVT dependencies on OKI_SALES_K_HDRS

Line 284: FROM oki_sales_k_hdrs shd

280: CURSOR l_org_id_csr IS
281: SELECT DISTINCT shd.authoring_org_id authoring_org_id
282: , /*11510 change*/ NULL authoring_org_name
283: , shd.scs_code scs_code
284: FROM oki_sales_k_hdrs shd
285: ;
286:
287: -- Cursor to count the number of contracts with expired lines
288: -- for a particular organization and subclass

Line 298: , oki_sales_k_hdrs shd

294: ) IS
295: SELECT COUNT(DISTINCT(shd.chr_id)) contract_count
296: FROM /*11510 change removed oki_Expired_lines and added oki_cov_prd_lines */
297: oki_cov_prd_lines cpl
298: , oki_sales_k_hdrs shd
299: WHERE cpl.end_date BETWEEN p_start_date AND p_end_date
300: /*11510 change start*/
301: AND cpl.is_exp_not_renewed_yn='Y'
302: /*11510 change end*/

Line 320: , oki_sales_k_hdrs shd

316: ) IS
317: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
318: /*11510 change removed oki_Expired_lines and added oki_cov_prd_lines */
319: FROM oki_cov_prd_lines cpl
320: , oki_sales_k_hdrs shd
321: WHERE cpl.end_date BETWEEN p_start_date AND p_end_date
322: /*11510 change start*/
323: AND cpl.is_exp_not_renewed_yn='Y'
324: /*11510 change end*/

Line 341: FROM oki_sales_k_hdrs shd

337: , p_scs_code IN vARCHAR2
338: ) IS
339: SELECT COUNT(*) contract_count
340: , NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
341: FROM oki_sales_k_hdrs shd
342: WHERE shd.ste_code = 'ENTERED'
343: AND NVL(shd.close_date, shd.start_date)
344: BETWEEN p_start_date AND p_end_date
345: AND shd.is_new_yn IS NULL

Line 361: FROM oki_sales_k_hdrs shd

357: , p_scs_code IN VARCHAR2
358: ) IS
359: SELECT COUNT(*) contract_count
360: , NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
361: FROM oki_sales_k_hdrs shd
362: WHERE shd.ste_code IN ('ACTIVE','SIGNED')
363: AND LEAST(NVL(shd.date_signed, shd.start_date), shd.start_date)
364: BETWEEN p_start_date AND p_end_date
365: AND shd.is_new_yn IS NULL

Line 381: FROM oki_sales_k_hdrs shd

377: , p_scs_code IN VARCHAR2
378: ) IS
379: SELECT COUNT(*) contract_count
380: , NVL(SUM(base_forecast_amount), 0) base_contract_amount
381: FROM oki_sales_k_hdrs shd
382: WHERE shd.close_date BETWEEN p_start_date AND p_end_date
383: AND shd.win_percent IS NOT NULL
384: AND shd.close_date IS NOT NULL
385: AND shd.is_new_yn IS NULL

Line 743: FROM oki_sales_k_hdrs shd

739:
740: -- Cursor to get all the organizations
741: CURSOR l_scs_csr IS
742: SELECT DISTINCT shd.scs_code
743: FROM oki_sales_k_hdrs shd
744: ;
745:
746: -- Cursor to count the number of contracts with expired lines
747: -- for each organization

Line 756: , oki_sales_k_hdrs shd

752: ) IS
753: SELECT COUNT(DISTINCT(shd.chr_id)) contract_count
754: /*11510 change removed oki_Expired_lines and added oki_cov_prd_lines */
755: FROM oki_cov_prd_lines cpl
756: , oki_sales_k_hdrs shd
757: WHERE cpl.end_date BETWEEN p_start_date AND p_end_date
758: /*11510 change start*/
759: AND cpl.is_exp_not_renewed_yn='Y'
760: /*11510 change end*/

Line 777: , oki_sales_k_hdrs shd

773: ) IS
774: SELECT NVL(SUM(cpl.base_price_negotiated), 0) base_price_negotiated
775: /*11510 change removed oki_Expired_lines and added oki_cov_prd_lines */
776: FROM oki_cov_prd_lines cpl
777: , oki_sales_k_hdrs shd
778: WHERE cpl.end_date BETWEEN p_start_date AND p_end_date
779: /*11510 change start*/
780: AND cpl.is_exp_not_renewed_yn='Y'
781: /*11510 change end*/

Line 796: FROM oki_sales_k_hdrs shd

792: , p_scs_code IN VARCHAR2
793: ) IS
794: SELECT COUNT(*) contract_count
795: , NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
796: FROM oki_sales_k_hdrs shd
797: WHERE shd.ste_code = 'ENTERED'
798: AND NVL(shd.close_date, shd.start_date) BETWEEN p_start_date AND p_end_date
799: AND shd.is_new_yn IS NULL
800: AND shd.scs_code = p_scs_code

Line 813: FROM oki_sales_k_hdrs shd

809: , p_scs_code IN VARCHAR2
810: ) IS
811: SELECT COUNT(*) contract_count
812: , NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
813: FROM oki_sales_k_hdrs shd
814: WHERE shd.ste_code IN ('ACTIVE','SIGNED')
815: AND LEAST(NVL(shd.date_signed, shd.start_date), shd.start_date)
816: BETWEEN p_start_date AND p_end_date
817: AND shd.is_new_yn IS NULL

Line 831: FROM oki_sales_k_hdrs shd

827: , p_scs_code IN VARCHAR2
828: ) IS
829: SELECT COUNT(*) contract_count
830: , NVL(SUM(base_forecast_amount), 0) base_contract_amount
831: FROM oki_sales_k_hdrs shd
832: WHERE shd.close_date BETWEEN p_start_date AND p_end_date
833: AND shd.win_percent IS NOT NULL
834: AND shd.close_date IS NOT NULL
835: AND shd.is_new_yn IS NULL

Line 1210: , oki_sales_k_hdrs shd

1206: , p_end_date IN DATE) IS
1207: SELECT COUNT(DISTINCT(shd.chr_id)) contract_count
1208: /*11510 change removed oki_Expired_lines and added oki_cov_prd_lines */
1209: FROM oki_cov_prd_lines cpl
1210: , oki_sales_k_hdrs shd
1211: WHERE cpl.end_date BETWEEN p_start_date and p_end_date
1212: /*11510 change*/
1213: AND cpl.is_exp_not_renewed_yn='Y'
1214: AND cpl.chr_id = shd.chr_id ;

Line 1225: FROM oki_sales_k_hdrs shd

1221: , p_end_date IN DATE
1222: ) IS
1223: SELECT COUNT(*) contract_count
1224: , NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
1225: FROM oki_sales_k_hdrs shd
1226: WHERE shd.ste_code = 'ENTERED'
1227: AND NVL(shd.close_date, shd.start_date)
1228: BETWEEN p_start_date AND p_end_date
1229: AND shd.is_new_yn IS NULL

Line 1240: FROM oki_sales_k_hdrs shd

1236: , p_end_date IN DATE
1237: ) IS
1238: SELECT count(*) contract_count
1239: , NVL(SUM(shd.base_contract_amount), 0) base_contract_amount
1240: FROM oki_sales_k_hdrs shd
1241: WHERE shd.ste_code IN ('ACTIVE','SIGNED')
1242: AND LEAST(NVL(shd.date_signed, shd.start_date), shd.start_date)
1243: BETWEEN p_start_date AND p_end_date
1244: AND shd.is_new_yn IS NULL

Line 1254: FROM oki_sales_k_hdrs shd

1250: ( p_start_date IN DATE
1251: , p_end_date IN DATE) IS
1252: SELECT count(*) contract_count
1253: , NVL(SUM(base_forecast_amount), 0) base_contract_amount
1254: FROM oki_sales_k_hdrs shd
1255: WHERE shd.close_date BETWEEN p_start_date AND p_end_date
1256: AND shd.win_percent IS NOT NULL
1257: AND shd.close_date IS NOT NULL
1258: AND shd.is_new_yn IS NULL