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.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_BATCH_RESULTS2_T

Line 421: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';

417:
418: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
419:
420: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';
421: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
422: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';
423:
424: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
425: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;

Line 425: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;

421: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
422: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';
423:
424: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
425: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
426:
427: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
428:
429:

Line 446: FROM CSC_PROF_BATCH_RESULTS2_T;

442: check_results_id, check_id, party_id, cust_account_id,
443: value, currency_code, grade, created_by, creation_date,
444: last_updated_by, last_update_date, last_update_login,
445: results_threshold_flag, rating_code, color_code
446: FROM CSC_PROF_BATCH_RESULTS2_T;
447:
448: COMMIT;
449:
450: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';

Line 455: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

451: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
452: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
453:
454: END IF;
455: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
456:
457: IF g_dashboard_for_contact IS NULL THEN
458: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT',g_dashboard_for_contact);
459: END IF;

Line 653: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

649: '''' || v_count || '''' || ')' ;
650:
651:
652: IF v_check_level = 'ACCOUNT' THEN
653: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
654: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
655: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
656: ' results_threshold_flag, rating_code, color_code)' ||
657: ' SELECT csc_prof_check_results_s.nextval, '

Line 668: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

664: || c_rating || ', '
665: || c_color
666: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';
667: ELSE
668: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
669: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
670: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
671: ' results_threshold_flag, rating_code, color_code)' ||
672: ' SELECT csc_prof_check_results_s.nextval, '

Line 694: INSERT /+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) /

690: END IF ; /* batch_sql_stmnt IS NOT NULL */
691: END LOOP;
692: CLOSE checks_csr;
693:
694: INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
695: INTO CSC_PROF_BATCH_RESULTS2_T
696: (check_results_id, check_id, party_id, cust_account_id,
697: value, currency_code, grade, created_by, creation_date,
698: last_updated_by, last_update_date, last_update_login,

Line 695: INTO CSC_PROF_BATCH_RESULTS2_T

691: END LOOP;
692: CLOSE checks_csr;
693:
694: INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
695: INTO CSC_PROF_BATCH_RESULTS2_T
696: (check_results_id, check_id, party_id, cust_account_id,
697: value, currency_code, grade, created_by, creation_date,
698: last_updated_by, last_update_date, last_update_login,
699: results_threshold_flag, rating_code, color_code

Line 732: FROM CSC_PROF_BATCH_RESULTS2_T;

728: check_results_id, check_id, party_id, cust_account_id,
729: value, currency_code, grade, created_by, creation_date,
730: last_updated_by, last_update_date, last_update_login,
731: results_threshold_flag, rating_code, color_code
732: FROM CSC_PROF_BATCH_RESULTS2_T;
733:
734: COMMIT;
735:
736:

Line 741: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

737: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
738: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
739: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
740:
741: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
742:
743: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
744: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
745:

Line 2601: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';

2597:
2598: v_get_appl := FND_INSTALLATION.GET_APP_INFO('CSC', v_schema_status, v_industry, v_schema_name);
2599:
2600: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS NOLOGGING';
2601: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
2602: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';
2603:
2604: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
2605: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;

Line 2605: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;

2601: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS2_T NOLOGGING';
2602: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_BATCH_RESULTS1_T NOLOGGING';
2603:
2604: SELECT count(*) INTO v_chk_count FROM csc_prof_check_results;
2605: SELECT count(*) INTO v_batch_count FROM CSC_PROF_BATCH_RESULTS2_T;
2606:
2607: IF v_chk_count = 0 AND v_batch_count <> 0 THEN
2608:
2609:

Line 2626: FROM CSC_PROF_BATCH_RESULTS2_T;

2622: check_results_id, check_id, party_id, cust_account_id,
2623: value, currency_code, grade, created_by, creation_date,
2624: last_updated_by, last_update_date, last_update_login,
2625: results_threshold_flag, rating_code, color_code
2626: FROM CSC_PROF_BATCH_RESULTS2_T;
2627:
2628: COMMIT;
2629:
2630:

Line 2636: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

2632: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2633: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2634:
2635: END IF;
2636: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2637:
2638: IF g_dashboard_for_contact IS NULL THEN
2639: FND_PROFILE.GET('CSC_DASHBOARD_VIEW_FOR_CONTACT', g_dashboard_for_contact);
2640: END IF;

Line 2835: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

2831: '''' || 'COLOR' || '''' ||', ' ||
2832: '''' || v_count || '''' || ')' ;
2833:
2834: IF v_check_level = 'ACCOUNT' THEN
2835: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
2836: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
2837: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
2838: ' results_threshold_flag, rating_code, color_code)' ||
2839: ' SELECT csc_prof_check_results_s.nextval, '

Line 2850: insert_stmnt_final := 'INSERT /+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) / INTO CSC_PROF_BATCH_RESULTS2_T ' ||

2846: || c_rating || ', '
2847: || c_color
2848: ||' FROM CSC_PROF_BATCH_RESULTS1_T where nvl(account_id, -999999) <> -999999';
2849: ELSE
2850: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
2851: '(check_results_id, check_id, party_id, cust_account_id, value, currency_code, grade, '||
2852: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
2853: ' results_threshold_flag, rating_code, color_code)' ||
2854: ' SELECT csc_prof_check_results_s.nextval, '

Line 2875: INSERT /+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) /

2871: END IF ; /* batch_sql_stmnt IS NOT NULL */
2872: END LOOP;
2873: CLOSE checks_csr;
2874:
2875: INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
2876: INTO CSC_PROF_BATCH_RESULTS2_T
2877: (check_results_id, check_id, party_id, cust_account_id,
2878: value, currency_code, grade, created_by, creation_date,
2879: last_updated_by, last_update_date, last_update_login,

Line 2876: INTO CSC_PROF_BATCH_RESULTS2_T

2872: END LOOP;
2873: CLOSE checks_csr;
2874:
2875: INSERT /*+ PARALLEL (CSC_PROF_BATCH_RESULTS2_T, 12) */
2876: INTO CSC_PROF_BATCH_RESULTS2_T
2877: (check_results_id, check_id, party_id, cust_account_id,
2878: value, currency_code, grade, created_by, creation_date,
2879: last_updated_by, last_update_date, last_update_login,
2880: results_threshold_flag, rating_code, color_code

Line 2916: FROM CSC_PROF_BATCH_RESULTS2_T;

2912: check_results_id, check_id, party_id, cust_account_id,
2913: value, currency_code, grade, created_by, creation_date,
2914: last_updated_by, last_update_date, last_update_login,
2915: results_threshold_flag, rating_code, color_code
2916: FROM CSC_PROF_BATCH_RESULTS2_T;
2917:
2918: COMMIT;
2919:
2920:

Line 2925: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;

2921: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N2 REBUILD NOLOGGING';
2922: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N3 REBUILD NOLOGGING';
2923: EXECUTE IMMEDIATE 'ALTER INDEX '|| v_schema_name ||'.CSC_PROF_CHECK_RESULTS_N4 REBUILD NOLOGGING';
2924:
2925: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS2_T' ;
2926: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || v_schema_name ||'.CSC_PROF_BATCH_RESULTS1_T' ;
2927:
2928: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
2929: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';