153: ftd.ENT_YEAR_ID, /**as entYearId,**/
154: ftd.ENT_QTR_ID, /**as entQuarterId,**/
155: ftd.ENT_PERIOD_ID, /**as entPeriodId,**/
156: to_number(to_char(agpv.end_date,'J')) /**as reportDateJulian**/
157: from eng_engineering_changes eec,
158: eng_change_subjects ecs,
159: AMW_FIN_PROC_CERT_RELAN afpcr,
160: amw_certification_b proc_cert,
161: amw_certification_b fin_cert,
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
595: and roif.organization_id=aauv.organization_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
632: and roif.process_id=alrv.process_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 ';
670:
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
706: and roif.status_code=ripv.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
744: and roif.priority_code=ripv.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
782: and roif.reason_code=rirv.id