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.RCI_OPEN_REMED_SUMM_PKG dependencies on RCI_OPEN_REMEDIATIONS_F

Line 124: RCI_OPEN_REMEDIATIONS_F r

120: SELECT
121: 0 f_open
122: ,sum(r.open) r_open
123: FROM
124: RCI_OPEN_REMEDIATIONS_F r
125: WHERE r.open=1 AND r.age_in_days >= 0
126: and r.organization_id is not null
127: '|| r_where_clause || '
128: ) ';

Line 383: RCI_OPEN_REMEDIATIONS_F r

379: ,sum(r.AGE_BUCKET_2) r_AGE_BUCKET_2
380: ,sum(r.AGE_BUCKET_3) r_AGE_BUCKET_3
381: ,sum(r.AGE_BUCKET_4) r_AGE_BUCKET_4
382: FROM
383: RCI_OPEN_REMEDIATIONS_F r
384: WHERE r.open=1 AND r.age_in_days >= 0
385: '|| r_where_clause || '
386: group by r.'|| group_by_col || '
387: ) group by '||group_by_col_name||'

Line 732: rci_open_remediations_f r

728: and (ecv.STATUS_CODE not in (0,11) or (ecv.status_code=11 and round(ecv.last_update_date-last_day(to_date('''||v_yyyymm||''',''YYYYMM''))) > 0 ))
729: and ecv.change_id in ( SELECT
730: remediation_id
731: FROM
732: rci_open_remediations_f r
733: WHERE 1=1 ' || where_clause ||
734: ')'
735: ;
736:

Line 764: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.RCI_OPEN_REMEDIATIONS_F');

760: ,retcode IN OUT NOCOPY NUMBER)
761: IS
762: BEGIN
763: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.RCI_OPEN_FINDINGS_F');
764: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.RCI_OPEN_REMEDIATIONS_F');
765: insert_findings_increment_load(
766: errbuf => errbuf
767: ,retcode => retcode);
768:

Line 840: 'RCI_OPEN_REMEDIATIONS_F'

836: ,program_id
837: ,program_login_id
838: ,program_application_id
839: ,request_id ) VALUES (
840: 'RCI_OPEN_REMEDIATIONS_F'
841: ,l_run_date
842: ,l_user_id
843: ,sysdate
844: ,sysdate

Line 1112: rci_open_remediations_f;

1108: CURSOR c_remed_age IS
1109: SELECT
1110: DISTINCT finding_id, age_in_days
1111: FROM
1112: rci_open_remediations_f;
1113:
1114: CURSOR c_remed IS
1115: SELECT
1116: DISTINCT finding_id, age_in_days

Line 1118: rci_open_remediations_f rof, eng_change_subjects ecs

1114: CURSOR c_remed IS
1115: SELECT
1116: DISTINCT finding_id, age_in_days
1117: FROM
1118: rci_open_remediations_f rof, eng_change_subjects ecs
1119: WHERE
1120: rof.finding_id = ecs.change_id AND
1121: (ecs.entity_name = 'PROJ_ORG' OR ecs.entity_name = 'PROJ_ORG_PROC');
1122:

Line 1129: v_finding_id rci_open_remediations_f.finding_id%TYPE;

1125: entity_name, pk1_value
1126: FROM
1127: eng_change_subjects ecs
1128: WHERE change_id = p_change_id;
1129: v_finding_id rci_open_remediations_f.finding_id%TYPE;
1130: v_age rci_open_remediations_f.age_in_days%TYPE;
1131: v_bucket_1 Number;
1132: v_bucket_2 Number;
1133: v_bucket_3 Number;

Line 1130: v_age rci_open_remediations_f.age_in_days%TYPE;

1126: FROM
1127: eng_change_subjects ecs
1128: WHERE change_id = p_change_id;
1129: v_finding_id rci_open_remediations_f.finding_id%TYPE;
1130: v_age rci_open_remediations_f.age_in_days%TYPE;
1131: v_bucket_1 Number;
1132: v_bucket_2 Number;
1133: v_bucket_3 Number;
1134: v_bucket_4 Number;

Line 1170: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_REMEDIATIONS_F';

1166: x_global_start_date => g_global_start_date
1167: ,x_rci_schema => g_rci_schema);
1168:
1169: l_stmnt_id := 10;
1170: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_REMEDIATIONS_F';
1171:
1172: ----dbms_output.put_line( '2 **************' );
1173:
1174: l_stmnt_id := 20;

Line 1175: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_OPEN_REMEDIATIONS_F');

1171:
1172: ----dbms_output.put_line( '2 **************' );
1173:
1174: l_stmnt_id := 20;
1175: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_OPEN_REMEDIATIONS_F');
1176:
1177: ----dbms_output.put_line( '3 **************' );
1178: l_stmnt_id := 30;
1179: l_run_date := sysdate - 5/(24*60);

Line 1207: INSERT INTO rci_open_remediations_f(

1203: else
1204: v_period := to_number(to_char(y)||to_char(q)||to_char(m));
1205: end if;
1206:
1207: INSERT INTO rci_open_remediations_f(
1208: finding_id, remediation_id, priority_code, reason_code, phase_code,
1209: age_in_days,
1210: need_by_date, completion_date,
1211: open, past_due,

Line 1242: UPDATE rci_open_remediations_f

1238: FOR r_remed_age IN c_remed_age LOOP
1239: v_finding_id := r_remed_age.finding_id;
1240: v_age := r_remed_age.age_in_days;
1241: fn_get_Bucket_Id(v_age, v_bucket_1,v_bucket_2,v_bucket_3,v_bucket_4);
1242: UPDATE rci_open_remediations_f
1243: SET age_bucket_1 = v_bucket_1 , age_bucket_2 = v_bucket_2,
1244: age_bucket_3 = v_bucket_3, age_bucket_4 = v_bucket_4
1245: WHERE finding_id = v_finding_id;
1246: END LOOP;

Line 1253: update rci_open_remediations_f set organization_id = r_ch_sub.pk1_value

1249: FOR r_remed in c_remed LOOP
1250: v_finding_id := r_remed.finding_id;
1251: FOR r_ch_sub in c_ch_sub(v_finding_id) LOOP
1252: IF r_ch_sub.entity_name = 'PROJ_ORG' THEN
1253: update rci_open_remediations_f set organization_id = r_ch_sub.pk1_value
1254: WHERE finding_id = v_finding_id;
1255: ELSIF r_ch_sub.entity_name = 'PROJ_ORG_PROC' THEN
1256: update rci_open_remediations_f set process_id = r_ch_sub.pk1_value
1257: WHERE finding_id = v_finding_id;

Line 1256: update rci_open_remediations_f set process_id = r_ch_sub.pk1_value

1252: IF r_ch_sub.entity_name = 'PROJ_ORG' THEN
1253: update rci_open_remediations_f set organization_id = r_ch_sub.pk1_value
1254: WHERE finding_id = v_finding_id;
1255: ELSIF r_ch_sub.entity_name = 'PROJ_ORG_PROC' THEN
1256: update rci_open_remediations_f set process_id = r_ch_sub.pk1_value
1257: WHERE finding_id = v_finding_id;
1258: END IF;
1259: END LOOP;
1260: END LOOP;

Line 1272: WHERE fact_name = 'RCI_OPEN_REMEDIATIONS_F' ;

1268: ,program_id = l_program_id
1269: ,program_login_id = l_program_login_id
1270: ,program_application_id = l_program_application_id
1271: ,request_id = l_request_id
1272: WHERE fact_name = 'RCI_OPEN_REMEDIATIONS_F' ;
1273:
1274: IF (SQL%NOTFOUND) THEN
1275: RAISE NO_DATA_FOUND;
1276: END IF;

Line 1291: 'RCI_OPEN_REMEDIATIONS_F'

1287: ,program_id
1288: ,program_login_id
1289: ,program_application_id
1290: ,request_id ) VALUES (
1291: 'RCI_OPEN_REMEDIATIONS_F'
1292: ,l_run_date
1293: ,l_user_id
1294: ,sysdate
1295: ,sysdate