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_CHECK_RESULTS_S

Line 759: ' SELECT csc_prof_check_results_s.nextval, '

755: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
756: '(check_results_id, check_id, party_id, cust_account_id, party_site_id,value, currency_code, grade, '|| -- Inlcuded 'party_site_id' for ER#8473903
757: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
758: ' results_threshold_flag, rating_code, color_code)' ||
759: ' SELECT csc_prof_check_results_s.nextval, '
760: || chk_id || ', party_id, account_id,party_site_id, ' -- Inlcuded 'party_site_id' by spamujul for ER#8473903
761: || c_fmt_mask ||', '
762: || c_curr_code || ', '
763: || c_grade

Line 777: ' SELECT csc_prof_check_results_s.nextval, '

773: -- added party_site_id in the below line for ER#8473903
774: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '|| -- Inlcuded 'party_site_id' for ER#8473903
775: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
776: ' results_threshold_flag, rating_code, color_code)' ||
777: ' SELECT csc_prof_check_results_s.nextval, '
778: -- || chk_id || ', party_id, account_id, '
779: -- added party_site_id in the below line for ER#8473903
780: || chk_id || ', party_id, account_id,party_site_id, ' -- Inlcuded 'party_site_id' by spamujul for ER#8473903
781: || c_fmt_mask ||', '

Line 795: ' SELECT csc_prof_check_results_s.nextval, '

791: insert_stmnt_final := 'INSERT /*+ PARALLEL(CSC_PROF_BATCH_RESULTS2_T, 12) */ INTO CSC_PROF_BATCH_RESULTS2_T ' ||
792: '(check_results_id, check_id, party_id, cust_account_id, party_site_id,value, currency_code, grade, '|| -- Inlcuded 'party_site_id' for ER#8473903
793: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
794: ' results_threshold_flag, rating_code, color_code)' ||
795: ' SELECT csc_prof_check_results_s.nextval, '
796: || chk_id || ', party_id, account_id,party_site_id ,'
797: || c_fmt_mask ||', '
798: || c_curr_code || ', '
799: || c_grade

Line 3964: ' SELECT csc_prof_check_results_s.nextval, '

3960: -- added party_site_id in the below line for ER#8473903
3961: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '||
3962: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
3963: ' results_threshold_flag, rating_code, color_code)' ||
3964: ' SELECT csc_prof_check_results_s.nextval, '
3965: -- || chk_id || ', party_id, account_id, '
3966: -- added party_site_id in the below line for ER#8473903
3967: || chk_id || ', party_id, account_id,party_site_id, '
3968: || c_fmt_mask ||', '

Line 3984: ' SELECT csc_prof_check_results_s.nextval, '

3980: -- added party_site_id in the below line for ER#8473903
3981: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '||
3982: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
3983: ' results_threshold_flag, rating_code, color_code)' ||
3984: ' SELECT csc_prof_check_results_s.nextval, '
3985: -- || chk_id || ', party_id, account_id, '
3986: -- added party_site_id in the below line for ER#8473903
3987: || chk_id || ', party_id, account_id,party_site_id, '
3988: || c_fmt_mask ||', '

Line 4004: ' SELECT csc_prof_check_results_s.nextval, '

4000: -- added party_site_id in the below line for ER#8473903
4001: '(check_results_id, check_id, party_id, cust_account_id,party_site_id, value, currency_code, grade, '||
4002: ' created_by, creation_date, last_updated_by, last_update_date, last_update_login, '||
4003: ' results_threshold_flag, rating_code, color_code)' ||
4004: ' SELECT csc_prof_check_results_s.nextval, '
4005: -- || chk_id || ', party_id, account_id, '
4006: -- added party_site_id in the below line for ER#8473903
4007: || chk_id || ', party_id, account_id,party_site_id, '
4008: || c_fmt_mask ||', '

Line 9261: csc_prof_check_results_s.nextval ,

9257: last_update_login
9258: )
9259: VALUES
9260: (
9261: csc_prof_check_results_s.nextval ,
9262: ip_check_id(i) ,
9263: ip_party_id(i) ,
9264: ip_account_id(i) ,
9265: ip_psite_id(i), -- Added by spamujul for ER#8473903

Line 9345: csc_prof_check_results_s.nextval ,

9341: last_update_login
9342: )
9343: VALUES
9344: (
9345: csc_prof_check_results_s.nextval ,
9346: ia_check_id(i) ,
9347: ia_party_id(i) ,
9348: ia_account_id(i) ,
9349: ia_psite_id(i) , -- Added by spamujul for ER#8473903

Line 9429: csc_prof_check_results_s.nextval ,

9425: last_update_login
9426: )
9427: VALUES
9428: (
9429: csc_prof_check_results_s.nextval ,
9430: is_check_id(i) ,
9431: is_party_id(i) ,
9432: is_account_id(i) ,
9433: is_psite_id(i) ,