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_FINDINGS_F

Line 115: RCI_OPEN_FINDINGS_F f

111: SELECT
112: sum(f.open) f_open
113: ,0 r_open
114: FROM
115: RCI_OPEN_FINDINGS_F f
116: WHERE f.open=1 AND f.age_in_days >= 0
117: and f.organization_id is not null
118: '|| f_where_clause || '
119: UNION

Line 362: RCI_OPEN_FINDINGS_F f

358: ,0 r_AGE_BUCKET_2
359: ,0 r_AGE_BUCKET_3
360: ,0 r_AGE_BUCKET_4
361: FROM
362: RCI_OPEN_FINDINGS_F f
363: WHERE f.open=1 AND f.age_in_days >= 0
364: '|| f_where_clause || '
365: group by f.'|| group_by_col || '
366: UNION

Line 572: rci_open_findings_f f

568: and ecst.language = userenv(''LANG'')
569: and change_id in ( SELECT
570: finding_id
571: FROM
572: rci_open_findings_f f
573: WHERE age_in_days >= 0
574: /** 12.26.2005 npanandi: added following clause to display
575: only OPEN findings from rci_open_findings_f
576: bug 4908320 fix ***/

Line 575: only OPEN findings from rci_open_findings_f

571: FROM
572: rci_open_findings_f f
573: WHERE age_in_days >= 0
574: /** 12.26.2005 npanandi: added following clause to display
575: only OPEN findings from rci_open_findings_f
576: bug 4908320 fix ***/
577: and f.OPEN=1
578: ' || where_clause ||
579: ')'

Line 763: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.RCI_OPEN_FINDINGS_F');

759: errbuf IN OUT NOCOPY VARCHAR2
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);

Line 818: 'RCI_OPEN_FINDINGS_F'

814: ,program_id
815: ,program_login_id
816: ,program_application_id
817: ,request_id ) VALUES (
818: 'RCI_OPEN_FINDINGS_F'
819: ,l_run_date
820: ,l_user_id
821: ,sysdate
822: ,sysdate

Line 880: rci_open_findings_f rof;

876: CURSOR c_find_age IS
877: SELECT
878: DISTINCT finding_id, age_in_days
879: FROM
880: rci_open_findings_f rof;
881:
882: CURSOR c_find IS
883: SELECT
884: DISTINCT finding_id

Line 886: rci_open_findings_f rof, eng_change_subjects ecs

882: CURSOR c_find IS
883: SELECT
884: DISTINCT finding_id
885: FROM
886: rci_open_findings_f rof, eng_change_subjects ecs
887: WHERE
888: rof.finding_id = ecs.change_id AND
889: (ecs.entity_name = 'PROJ_ORG' OR ecs.entity_name = 'PROJ_ORG_PROC');
890:

Line 898: v_finding_id rci_open_findings_f.finding_id%TYPE;

894: FROM
895: eng_change_subjects ecs
896: WHERE change_id = p_change_id;
897:
898: v_finding_id rci_open_findings_f.finding_id%TYPE;
899: v_age rci_open_findings_f.age_in_days%TYPE;
900: v_bucket_1 Number;
901: v_bucket_2 Number;
902: v_bucket_3 Number;

Line 899: v_age rci_open_findings_f.age_in_days%TYPE;

895: eng_change_subjects ecs
896: WHERE change_id = p_change_id;
897:
898: v_finding_id rci_open_findings_f.finding_id%TYPE;
899: v_age rci_open_findings_f.age_in_days%TYPE;
900: v_bucket_1 Number;
901: v_bucket_2 Number;
902: v_bucket_3 Number;
903: v_bucket_4 Number;

Line 940: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_FINDINGS_F';

936: x_global_start_date => g_global_start_date
937: ,x_rci_schema => g_rci_schema);
938:
939: l_stmnt_id := 10;
940: DELETE FROM rci_dr_inc where fact_name = 'RCI_OPEN_FINDINGS_F';
941:
942: ----dbms_output.put_line( '2 **************' );
943:
944: l_stmnt_id := 20;

Line 945: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_OPEN_FINDINGS_F');

941:
942: ----dbms_output.put_line( '2 **************' );
943:
944: l_stmnt_id := 20;
945: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || g_rci_schema || '.RCI_OPEN_FINDINGS_F');
946:
947: ----dbms_output.put_line( '3 **************' );
948: l_stmnt_id := 30;
949: l_run_date := sysdate - 5/(24*60);

Line 978: INSERT INTO rci_open_findings_f (

974: else
975: v_period := to_number(to_char(y)||to_char(q)||to_char(m));
976: end if;
977:
978: INSERT INTO rci_open_findings_f (
979: finding_id, priority_code, reason_code, phase_code,
980: age_in_days,
981: need_by_date, completion_date,
982: open, past_due,

Line 1010: UPDATE rci_open_findings_f

1006: FOR r_find_age IN c_find_age LOOP
1007: v_finding_id := r_find_age.finding_id;
1008: v_age := r_find_age.age_in_days;
1009: fn_get_Bucket_Id(v_age, v_bucket_1,v_bucket_2,v_bucket_3,v_bucket_4);
1010: UPDATE rci_open_findings_f
1011: SET age_bucket_1 = v_bucket_1 , age_bucket_2 = v_bucket_2,
1012: age_bucket_3 = v_bucket_3, age_bucket_4 = v_bucket_4
1013: WHERE finding_id = v_finding_id;
1014: END LOOP;

Line 1021: UPDATE rci_open_findings_f

1017: FOR r_find IN c_find LOOP
1018: v_finding_id := r_find.finding_id;
1019: FOR r_ch_sub IN c_ch_sub(v_finding_id) LOOP
1020: IF r_ch_sub.entity_name = 'PROJ_ORG' THEN
1021: UPDATE rci_open_findings_f
1022: SET organization_id = r_ch_sub.pk1_value
1023: WHERE finding_id = v_finding_id;
1024: ELSIF r_ch_sub.entity_name = 'PROJ_ORG_PROC' THEN
1025: UPDATE rci_open_findings_f

Line 1025: UPDATE rci_open_findings_f

1021: UPDATE rci_open_findings_f
1022: SET organization_id = r_ch_sub.pk1_value
1023: WHERE finding_id = v_finding_id;
1024: ELSIF r_ch_sub.entity_name = 'PROJ_ORG_PROC' THEN
1025: UPDATE rci_open_findings_f
1026: SET process_id = r_ch_sub.pk1_value
1027: WHERE finding_id = v_finding_id;
1028: END IF;
1029: END LOOP;

Line 1042: WHERE fact_name = 'RCI_OPEN_FINDINGS_F' ;

1038: ,program_id = l_program_id
1039: ,program_login_id = l_program_login_id
1040: ,program_application_id = l_program_application_id
1041: ,request_id = l_request_id
1042: WHERE fact_name = 'RCI_OPEN_FINDINGS_F' ;
1043:
1044: IF (SQL%NOTFOUND) THEN
1045: RAISE NO_DATA_FOUND;
1046: END IF;

Line 1061: 'RCI_OPEN_FINDINGS_F'

1057: ,program_id
1058: ,program_login_id
1059: ,program_application_id
1060: ,request_id ) VALUES (
1061: 'RCI_OPEN_FINDINGS_F'
1062: ,l_run_date
1063: ,l_user_id
1064: ,sysdate
1065: ,sysdate