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.

[Home] [Help]

APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_OPINIONS

Line 488: from AMW_CONTROL_ASSOCIATIONS aca,amw_opinions_log_v aolv

484: where rocsf.report_date_julian = ftd.report_date_julian and rocsf.certification_result_code IS NULL and '||where_clause||' ) group by process_id) rf3
485: /*,fii_time_day ftd*/
486: ,amw_latest_revisions_v alrv
487: ,(select aca.pk3 as process_id, count(distinct aca.pk4) as risk_id
488: from AMW_CONTROL_ASSOCIATIONS aca,amw_opinions_log_v aolv
489: where object_type=''RISK_FINCERT'' and aca.pk5=aolv.opinion_log_id
490: and aolv.audit_result_code <> ''EFFECTIVE'' and '||l_ineffctrls_frm|| '
491: group by pk3) risk_ineff_ctrls
492: ,(select process_id, count(distinct risk_id) as risk_id from (select distinct organization_id,process_id,risk_id,project_id,audit_result_code

Line 669: amw_certification_b acb, amw_gl_periods_v agpv, amw_opinions_log_v aolv

665: agpv.period_year ent_year_id,
666: to_number(to_char(agpv.end_date,'J')) report_date_julian,
667: G_USER_ID, sysdate, G_USER_ID, sysdate, G_LOGIN_ID
668: FROM
669: amw_certification_b acb, amw_gl_periods_v agpv, amw_opinions_log_v aolv
670: WHERE
671: acb.object_type = 'PROCESS'
672: AND aolv.opinion_type_code = 'CERTIFICATION'
673: AND aolv.object_name = 'AMW_ORG_PROCESS'

Line 746: FROM amw_control_associations aca,amw_opinions_v aov

742: CURSOR c_get_risks_with_ineff_ctrls
743: IS
744: SELECT count(1)
745: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id
746: FROM amw_control_associations aca,amw_opinions_v aov
747: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
748: AND aca.pk1 = p_cert_id
749: AND aca.pk2 = p_org_id
750: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 767: FROM amw_opinions aov2

763: AND aov.pk3_value = p_org_id
764: AND aov.pk1_value = aca.control_id
765: AND aov.audit_result_code <> 'EFFECTIVE'
766: AND aov.authored_date = (SELECT MAX(aov2.authored_date)
767: FROM amw_opinions aov2
768: WHERE aov2.object_opinion_type_id = aov.object_opinion_type_id
769: AND aov2.pk3_value = aov.pk3_value
770: AND aov2.pk1_value = aov.pk1_value)
771: );

Line 781: amw_opinions_log_v riskevalopin

777: FROM
778: (SELECT object_type,risk_id,pk1,pk2,pk3,pk4,pk5,risk_rev_id
779: FROM amw_risk_associations WHERE object_type='BUSIPROC_CERTIFICATION') ara,
780: amw_risks_all_vl arav,
781: amw_opinions_log_v riskevalopin
782: WHERE
783: ara.pk1(+)=p_cert_id
784: AND ara.pk2(+)=p_org_id
785: AND ara.pk3(+)=p_process_id

Line 800: amw_opinions_log_v ctrlevalopin

796: FROM
797: (SELECT object_type,control_id,pk1,pk2,pk3,pk4,pk5,control_rev_id
798: FROM amw_control_associations WHERE object_type='BUSIPROC_CERTIFICATION') aca,
799: amw_controls_all_vl acav,
800: amw_opinions_log_v ctrlevalopin
801: WHERE
802: aca.pk1(+)=p_cert_id
803: AND aca.pk2(+)=p_org_id
804: AND aca.pk3(+)=p_process_id

Line 904: FROM amw_opinions_v opinion

900:
901: CURSOR c_get_certification_opinion
902: IS
903: SELECT opinion.opinion_id,opinion.audit_result_code
904: FROM amw_opinions_v opinion
905: WHERE opinion.pk3_value = p_org_id
906: AND opinion.pk2_value = cert_rec.cert_id
907: AND opinion.pk1_value = p_process_id
908: AND opinion.opinion_type_code = 'CERTIFICATION'

Line 914: FROM amw_control_associations aca,amw_opinions_v aov

910: CURSOR c_get_risks_with_ineff_ctrls
911: IS
912: SELECT count(1)
913: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id
914: FROM amw_control_associations aca,amw_opinions_v aov
915: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
916: AND aca.pk1 = cert_rec.cert_id
917: AND aca.pk2 = p_org_id
918: AND aca.pk3 IN (SELECT DISTINCT process_id

Line 935: FROM amw_opinions aov2

931: AND aov.pk3_value = p_org_id
932: AND aov.pk1_value = aca.control_id
933: AND aov.audit_result_code <> 'EFFECTIVE'
934: AND aov.authored_date = (SELECT MAX(aov2.authored_date)
935: FROM amw_opinions aov2
936: WHERE aov2.object_opinion_type_id = aov.object_opinion_type_id
937: AND aov2.pk3_value = aov.pk3_value
938: AND aov2.pk1_value = aov.pk1_value)
939: );

Line 949: amw_opinions_log_v riskevalopin

945: FROM
946: (SELECT object_type,risk_id,pk1,pk2,pk3,pk4,pk5,risk_rev_id
947: FROM amw_risk_associations WHERE object_type='BUSIPROC_CERTIFICATION') ara,
948: amw_risks_all_vl arav,
949: amw_opinions_log_v riskevalopin
950: WHERE
951: ara.pk1(+)=cert_rec.cert_id
952: AND ara.pk2(+)=p_org_id
953: AND ara.pk3(+)=p_process_id

Line 968: amw_opinions_log_v ctrlevalopin

964: FROM
965: (SELECT object_type,control_id,pk1,pk2,pk3,pk4,pk5,control_rev_id
966: FROM amw_control_associations WHERE object_type='BUSIPROC_CERTIFICATION') aca,
967: amw_controls_all_vl acav,
968: amw_opinions_log_v ctrlevalopin
969: WHERE
970: aca.pk1(+)=cert_rec.cert_id
971: AND aca.pk2(+)=p_org_id
972: AND aca.pk3(+)=p_process_id

Line 982: v_certification_result amw_opinions_v.audit_result%type;

978: v_proc_name VARCHAR2(50);
979: r_certification_opinion c_get_certification_opinion%rowtype;
980: r_get_risk_evals c_get_risk_evals%rowtype;
981: r_get_control_evals c_get_control_evals%rowtype;
982: v_certification_result amw_opinions_v.audit_result%type;
983: v_cert_with_issues rci_proc_cert_sum_f.CERT_RESULT_CWI%type := 0;
984: v_certified rci_proc_cert_sum_f.CERT_RESULT_C%type := 0;
985: v_not_certified rci_proc_cert_sum_f.CERT_RESULT_NC%type := 0;
986: v_risks_with_ineff_ctrls NUMBER;