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_PROJECT_EVENT_PVT dependencies on AMW_OPINIONS_V

Line 348: FROM amw_opinions_v

344: AND parent_object_id = PRIOR object_id;
345:
346: CURSOR get_sub_orgs_evaluated IS
347: SELECT count(pk1_value)
348: FROM amw_opinions_v
349: WHERE opinion_type_code = 'EVALUATION'
350: AND object_name = 'AMW_ORGANIZATION'
351: AND pk2_value = p_audit_project_id
352: AND pk1_value IN (

Line 366: FROM amw_opinions_v

362: AND parent_object_id = PRIOR object_id);
363:
364: CURSOR get_ineff_sub_orgs IS
365: SELECT count(pk1_value)
366: FROM amw_opinions_v
367: WHERE opinion_type_code = 'EVALUATION'
368: AND object_name = 'AMW_ORGANIZATION'
369: AND audit_result_code <> 'EFFECTIVE'
370: AND pk2_value = p_audit_project_id

Line 392: FROM amw_opinions_v opin

388: AND organization_id = p_org_id;
389:
390: CURSOR get_processes_evaluated IS
391: SELECT count(pk1_value)
392: FROM amw_opinions_v opin
393: WHERE opinion_type_code = 'EVALUATION'
394: AND object_name = 'AMW_ORG_PROCESS'
395: AND pk2_value = p_audit_project_id
396: AND pk3_value = p_org_id

Line 405: FROM amw_opinions_v opin

401: and scope.process_id=opin.pk1_value);
402:
403: CURSOR get_ineff_processes IS
404: SELECT count(pk1_value)
405: FROM amw_opinions_v opin
406: WHERE opinion_type_code = 'EVALUATION'
407: AND object_name = 'AMW_ORG_PROCESS'
408: AND audit_result_code <> 'EFFECTIVE'
409: AND pk2_value = p_audit_project_id

Line 426: FROM amw_risk_associations assoc, amw_opinions_v opin

422: AND pk2 = p_org_id;
423:
424: CURSOR get_risks_evaluated IS
425: SELECT count(opin.pk1_value)
426: FROM amw_risk_associations assoc, amw_opinions_v opin
427: WHERE assoc.object_type = 'PROJECT'
428: AND assoc.pk1 = p_audit_project_id
429: AND assoc.pk2 = p_org_id
430: AND opin.opinion_type_code = 'EVALUATION'

Line 438: FROM amw_risk_associations assoc, amw_opinions_v opin

434: AND opin.pk3_value = assoc.pk2;
435:
436: CURSOR get_unmitigated_risks IS
437: SELECT count(opin.pk1_value)
438: FROM amw_risk_associations assoc, amw_opinions_v opin
439: WHERE assoc.object_type = 'PROJECT'
440: AND assoc.pk1 = p_audit_project_id
441: AND assoc.pk2 = p_org_id
442: AND opin.opinion_type_code = 'EVALUATION'

Line 458: FROM amw_opinions_v

454: AND pk2 = p_org_id;
455:
456: CURSOR get_controls_evaluated IS
457: SELECT count(pk1_value)
458: FROM amw_opinions_v
459: WHERE opinion_type_code = 'EVALUATION'
460: AND object_name = 'AMW_ORG_CONTROL'
461: AND pk2_value = p_audit_project_id
462: AND pk3_value = p_org_id

Line 471: FROM amw_opinions_v

467: AND control_id = pk1_value);
468:
469: CURSOR get_ineff_controls IS
470: SELECT count(pk1_value)
471: FROM amw_opinions_v
472: WHERE opinion_type_code = 'EVALUATION'
473: AND object_name = 'AMW_ORG_CONTROL'
474: AND audit_result_code <> 'EFFECTIVE'
475: AND pk2_value = p_audit_project_id

Line 672: FROM amw_opinions_v

668: AND entity_type = PRIOR entity_type);
669:
670: CURSOR get_risks_evaluated IS
671: SELECT count(pk1_value)
672: FROM amw_opinions_v
673: WHERE opinion_type_code = 'EVALUATION'
674: AND object_name = 'AMW_ORG_PROCESS_RISK'
675: AND pk2_value = p_audit_project_id
676: AND pk3_value = p_org_id

Line 696: FROM amw_opinions_v

692: AND risk_id = pk1_value);
693:
694: CURSOR get_unmitigated_risks IS
695: SELECT count(pk1_value)
696: FROM amw_opinions_v
697: WHERE opinion_type_code = 'EVALUATION'
698: AND object_name = 'AMW_ORG_PROCESS_RISK'
699: AND audit_result_code <> 'EFFECTIVE'
700: AND pk2_value = p_audit_project_id

Line 738: FROM amw_control_associations assoc, amw_opinions_v opin

734: AND entity_type = PRIOR entity_type);
735:
736: CURSOR get_controls_evaluated IS
737: SELECT count(distinct opin.pk1_value)
738: FROM amw_control_associations assoc, amw_opinions_v opin
739: WHERE assoc.object_type = 'PROJECT'
740: AND assoc.pk1 = p_audit_project_id
741: AND assoc.pk2 = p_org_id
742: AND assoc.pk3 IN (SELECT process_id

Line 760: FROM amw_control_associations assoc, amw_opinions_v opin

756: AND opin.pk3_value = p_org_id;
757:
758: CURSOR get_ineff_controls IS
759: SELECT count(distinct opin.pk1_value)
760: FROM amw_control_associations assoc, amw_opinions_v opin
761: WHERE assoc.object_type = 'PROJECT'
762: AND assoc.pk1 = p_audit_project_id
763: AND assoc.pk2 = p_org_id
764: AND assoc.pk3 IN (SELECT process_id