APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_OPINIONS_LOG_V

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 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 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