APPS.RCI_OPEN_ISSUE_SUMM_PKG dependencies on RCI_OPEN_ISSUES_F

Line 78: select * from rci_open_issues_f;

74: l_age_distribution3_qtr number;
75: l_age_distribution4_qtr number;
76:
77: cursor cur_f is
78: select * from rci_open_issues_f;
79:
80: cur_rec cur_f%rowtype;
81: begin
82:

Line 83: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_open_issues_f');

79:
80: cur_rec cur_f%rowtype;
81: begin
82:
83: EXECUTE IMMEDIATE ('TRUNCATE TABLE amw.rci_open_issues_f');
84:
85: -- is the change_order open?
86: -- status_code, status_type can be confusing. For simplicity, for my purpose,
87: -- if the status_code is not in (0, 11), I'll consider this open

Line 90: insert into rci_open_issues_f(

86: -- status_code, status_type can be confusing. For simplicity, for my purpose,
87: -- if the status_code is not in (0, 11), I'll consider this open
88:
89:
90: insert into rci_open_issues_f(
91: change_id,
92: change_name,
93: description,
94: status_type,

Line 308: update rci_open_issues_f

304: null;
305: end;***/
306:
307: /**dbms_output.put_line( '***2 --> l_FIN_CERT_ID: '||l_FIN_CERT_ID||', l_FIN_CERT_TYPE: '||l_FIN_CERT_TYPE||', l_FIN_CERT_STATUS: '||l_FIN_CERT_STATUS );**/
308: update rci_open_issues_f
309: set /*certification_id = l_cert_id,*/
310: organization_id = l_org_id,
311: process_id = l_proc_id,
312: past_due = l_past_due,

Line 484: update rci_open_issues_f

480: l_age_distribution4_per := 0;
481:
482: end if;
483:
484: update rci_open_issues_f
485: set open_per = l_open_per,
486: past_due_per = l_past_due_per,
487: age_per = l_age_per,
488: age_distribution1_per = l_age_distribution1_per,

Line 590: l_query22 := ' from rci_open_issues_f roif

586: ,roif.change_id
587: ,eec.change_name
588: ,eec.initiation_date ';
589:
590: l_query22 := ' from rci_open_issues_f roif
591: ,eng_engineering_changes eec
592: ,amw_audit_units_v aauv
593: ,amw_certification_vl acv
594: where roif.change_id=eec.change_id

Line 627: l_query22 := ' from rci_open_issues_f roif

623: ,roif.change_id
624: ,eec.change_name
625: ,eec.initiation_date ';
626:
627: l_query22 := ' from rci_open_issues_f roif
628: ,eng_engineering_changes eec
629: ,amw_certification_vl acv
630: ,amw_latest_revisions_v alrv
631: where roif.change_id=eec.change_id

Line 665: l_query22 := ' from rci_open_issues_f roif

661: ,roif.change_id
662: ,eec.change_name
663: ,eec.initiation_date ';
664:
665: l_query22 := ' from rci_open_issues_f roif
666: ,eng_engineering_changes eec
667: ,amw_certification_vl acv
668: where roif.change_id=eec.change_id
669: and roif.fin_cert_id=acv.certification_id ';

Line 701: l_query22 := ' from rci_open_issues_f roif

697: ,roif.change_id
698: ,eec.change_name
699: ,eec.initiation_date ';
700:
701: l_query22 := ' from rci_open_issues_f roif
702: ,eng_engineering_changes eec
703: ,amw_certification_vl acv
704: ,rci_issue_phase_v ripv
705: where roif.change_id=eec.change_id

Line 739: l_query22 := ' from rci_open_issues_f roif

735: ,roif.change_id
736: ,eec.change_name
737: ,eec.initiation_date ';
738:
739: l_query22 := ' from rci_open_issues_f roif
740: ,eng_engineering_changes eec
741: ,amw_certification_vl acv
742: ,RCI_ISSUE_PRIORITY_V ripv
743: where roif.change_id=eec.change_id

Line 777: l_query22 := ' from rci_open_issues_f roif

773: ,roif.change_id
774: ,eec.change_name
775: ,eec.initiation_date ';
776:
777: l_query22 := ' from rci_open_issues_f roif
778: ,eng_engineering_changes eec
779: ,amw_certification_vl acv
780: ,RCI_ISSUE_REASON_V rirv
781: where roif.change_id=eec.change_id