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_PROC_CERT_SUMM_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

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 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 798: FROM amw_control_associations WHERE object_type='BUSIPROC_CERTIFICATION') aca,

794: ctrlevalopin.audit_result_code AS ctrl_eval,
795: count(nvl(ctrlevalopin.audit_result_code,1)) cnt
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

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 966: FROM amw_control_associations WHERE object_type='BUSIPROC_CERTIFICATION') aca,

962: ctrlevalopin.audit_result_code AS ctrl_eval,
963: count(nvl(ctrlevalopin.audit_result_code,1)) cnt
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