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.AMW_ORG_PROC_CERT_DATED_SUMM dependencies on AMW_OPINIONS_LOG_V

Line 23: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

19: CURSOR get_unmitigated_risks
20: IS
21: SELECT count(1)
22: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
23: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
24: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
25: AND ara.pk1 = p_certification_id
26: AND ara.pk2 = p_org_id
27: AND ara.risk_rev_id = arb.risk_rev_id

Line 72: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

68: CURSOR get_eval_risks
69: IS
70: SELECT count(1)
71: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
72: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
73: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
74: AND ara.pk1 = p_certification_id
75: AND ara.pk2 = p_org_id
76: AND ara.risk_rev_id = arb.risk_rev_id

Line 155: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

151: CURSOR get_unmitigated_risks
152: IS
153: SELECT count(1)
154: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
155: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
156: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
157: AND ara.pk1 = p_certification_id
158: AND ara.pk2 = p_org_id
159: AND ara.risk_rev_id = arb.risk_rev_id

Line 214: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

210: CURSOR get_eval_controls
211: IS
212: SELECT count(1)
213: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
214: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
215: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
216: AND acb.control_rev_id = aca.control_rev_id
217: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
218: AND aca.pk1 = p_certification_id

Line 283: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

279: CURSOR get_ineff_controls
280: IS
281: SELECT count(1)
282: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
283: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
284: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
285: AND acb.control_rev_id = aca.control_rev_id
286: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
287: AND aca.pk1 = p_certification_id

Line 324: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

320: CURSOR get_ineff_controls
321: IS
322: SELECT count(1)
323: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
324: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
325: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
326: AND acb.control_rev_id = aca.control_rev_id
327: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
328: AND aca.pk1 = p_certification_id

Line 417: FROM amw_execution_scope aes, amw_opinions_log_v opinion, amw_process_organization apo

413: IS
414: CURSOR get_certified_processes
415: IS
416: SELECT count(DISTINCT aes.process_id)
417: FROM amw_execution_scope aes, amw_opinions_log_v opinion, amw_process_organization apo
418: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
419: AND aes.organization_id = p_org_id
420: AND aes.entity_id = p_certification_id
421: AND aes.level_id > 4

Line 460: FROM amw_execution_scope aes, amw_opinions_log_v opinion, amw_process_organization apo

456: IS
457: CURSOR get_proc_cert_issues
458: IS
459: SELECT count(DISTINCT aes.process_id)
460: FROM amw_execution_scope aes, amw_opinions_log_v opinion, amw_process_organization apo
461: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
462: AND aes.organization_id = p_org_id
463: AND aes.entity_id = p_certification_id
464: AND aes.level_id > 4

Line 510: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

506: CURSOR get_ineff_controls
507: IS
508: SELECT count(1)
509: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
510: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
511: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
512: AND acb.control_rev_id = aca.control_rev_id
513: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
514: AND aca.pk1 = p_certification_id

Line 565: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

561: CURSOR get_eval_controls
562: IS
563: SELECT count(1)
564: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
565: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
566: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
567: AND acb.control_rev_id = aca.control_rev_id
568: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
569: AND aca.pk1 = p_certification_id

Line 656: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb

652: CURSOR get_ineff_controls
653: IS
654: SELECT count(1)
655: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.control_id
656: FROM amw_control_associations aca,amw_opinions_log_v aov, amw_controls_b acb
657: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
658: AND acb.control_rev_id = aca.control_rev_id
659: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
660: AND aca.pk1 = p_certification_id

Line 766: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

762: CURSOR get_unmitigated_risks
763: IS
764: SELECT count(1)
765: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
766: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
767: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
768: AND ara.pk1 = p_certification_id
769: AND ara.pk2 = p_org_id
770: AND ara.risk_rev_id = arb.risk_rev_id

Line 878: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

874: CURSOR get_eval_risks
875: IS
876: SELECT count(1)
877: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
878: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
879: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
880: AND ara.pk1 = p_certification_id
881: AND ara.pk2 = p_org_id
882: AND ara.risk_rev_id = arb.risk_rev_id

Line 935: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

931: CURSOR get_unmitigated_risks
932: IS
933: SELECT count(1)
934: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
935: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
936: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
937: AND ara.pk1 = p_certification_id
938: AND ara.pk2 = p_org_id
939: AND ara.risk_rev_id = arb.risk_rev_id

Line 1062: FROM amw_opinions_log_v opinion

1058: IS
1059: CURSOR get_org_proc_cert_issues
1060: IS
1061: SELECT count(distinct pk3_value)
1062: FROM amw_opinions_log_v opinion
1063: WHERE opinion.pk2_value = p_certification_id
1064: AND opinion.pk1_value = p_process_id
1065: AND opinion.opinion_type_code = 'CERTIFICATION'
1066: AND opinion.object_name = 'AMW_ORG_PROCESS'

Line 1097: FROM amw_opinions_log_v opinion,

1093: CURSOR get_var_org_proc_cert_issues
1094: IS
1095: SELECT count(1)
1096: FROM (SELECT distinct opinion.pk1_value, opinion.pk3_value
1097: FROM amw_opinions_log_v opinion,
1098: amw_execution_scope scp,
1099: amw_process_organization procorg
1100: WHERE opinion.pk2_value = p_certification_id
1101: AND opinion.pk1_value = scp.process_id

Line 1163: FROM amw_opinions_log_v opinion

1159: IS
1160: CURSOR get_org_proc_certified
1161: IS
1162: SELECT count(distinct pk3_value)
1163: FROM amw_opinions_log_v opinion
1164: WHERE opinion.pk2_value = p_certification_id
1165: AND opinion.pk1_value = p_process_id
1166: AND opinion.opinion_type_code = 'CERTIFICATION'
1167: AND opinion.object_name = 'AMW_ORG_PROCESS'

Line 1197: FROM amw_opinions_log_v opinion,

1193: CURSOR get_var_org_proc_certified
1194: IS
1195: SELECT count(1)
1196: FROM (SELECT distinct opinion.pk1_value, opinion.pk3_value
1197: FROM amw_opinions_log_v opinion,
1198: amw_execution_scope scp,
1199: amw_process_organization procorg
1200: WHERE opinion.pk2_value = p_certification_id
1201: AND opinion.pk1_value = scp.process_id