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_EXECUTION_SCOPE

Line 390: FROM amw_execution_scope

386: IS
387: CURSOR get_all_processes
388: IS
389: SELECT count(distinct process_id)
390: FROM amw_execution_scope
391: WHERE organization_id = p_org_id
392: AND entity_id = p_certification_id
393: AND level_id > 4;
394: l_total_proc NUMBER;

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 517: FROM amw_execution_scope

513: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
514: AND aca.pk1 = p_certification_id
515: AND aca.pk2 = p_org_id
516: AND aca.pk3 IN (SELECT DISTINCT process_id
517: FROM amw_execution_scope
518: START WITH process_id = p_process_id
519: AND entity_type = aca.object_type
520: AND organization_id = p_org_id
521: AND entity_id = p_certification_id

Line 572: FROM amw_execution_scope

568: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
569: AND aca.pk1 = p_certification_id
570: AND aca.pk2 = p_org_id
571: AND aca.pk3 IN (SELECT DISTINCT process_id
572: FROM amw_execution_scope
573: START WITH process_id = p_process_id
574: AND entity_type = aca.object_type
575: AND organization_id = p_org_id
576: AND entity_id = p_certification_id

Line 623: FROM amw_execution_scope

619: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
620: AND aca.pk1 = p_certification_id
621: AND aca.pk2 = p_org_id
622: AND aca.pk3 IN (SELECT DISTINCT process_id
623: FROM amw_execution_scope
624: START WITH process_id = p_process_id
625: AND entity_type = aca.object_type
626: AND organization_id = p_org_id
627: AND entity_id = p_certification_id

Line 663: FROM amw_execution_scope

659: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
660: AND aca.pk1 = p_certification_id
661: AND aca.pk2 = p_org_id
662: AND aca.pk3 IN (SELECT DISTINCT process_id
663: FROM amw_execution_scope
664: START WITH process_id = p_process_id
665: AND entity_type = aca.object_type
666: AND organization_id = p_org_id
667: AND entity_id = p_certification_id

Line 697: FROM amw_execution_scope

693: AND nvl(acb.key_mitigating, 'N') = nvl(p_key_ctrls_flag, nvl(acb.key_mitigating, 'N'))
694: AND aca.pk1 = p_certification_id
695: AND aca.pk2 = p_org_id
696: AND aca.pk3 IN (SELECT DISTINCT process_id
697: FROM amw_execution_scope
698: START WITH process_id = p_process_id
699: AND entity_type = aca.object_type
700: AND organization_id = p_org_id
701: AND entity_id = p_certification_id

Line 752: FROM amw_execution_scope

748: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
749: AND ara.pk1 = p_certification_id
750: AND ara.pk2 = p_org_id
751: AND ara.pk3 IN (SELECT DISTINCT process_id
752: FROM amw_execution_scope
753: START WITH process_id = p_process_id
754: AND entity_type = ara.object_type
755: AND organization_id = p_org_id
756: AND entity_id = p_certification_id

Line 773: FROM amw_execution_scope

769: AND ara.pk2 = p_org_id
770: AND ara.risk_rev_id = arb.risk_rev_id
771: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
772: AND ara.pk3 IN (SELECT DISTINCT process_id
773: FROM amw_execution_scope
774: START WITH process_id = p_process_id
775: AND entity_type = ara.object_type
776: AND organization_id = p_org_id
777: AND entity_id = p_certification_id

Line 842: FROM amw_execution_scope

838: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
839: AND ara.pk1 = p_certification_id
840: AND ara.pk2 = p_org_id
841: AND ara.pk3 IN (SELECT DISTINCT process_id
842: FROM amw_execution_scope
843: START WITH process_id = p_process_id
844: AND entity_type = ara.object_type
845: AND organization_id = p_org_id
846: AND entity_id = p_certification_id

Line 885: FROM amw_execution_scope

881: AND ara.pk2 = p_org_id
882: AND ara.risk_rev_id = arb.risk_rev_id
883: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
884: AND ara.pk3 IN (SELECT DISTINCT process_id
885: FROM amw_execution_scope
886: START WITH process_id = p_process_id
887: AND entity_type = ara.object_type
888: AND organization_id = p_org_id
889: AND entity_id = p_certification_id

Line 942: FROM amw_execution_scope

938: AND ara.pk2 = p_org_id
939: AND ara.risk_rev_id = arb.risk_rev_id
940: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
941: AND ara.pk3 IN (SELECT DISTINCT process_id
942: FROM amw_execution_scope
943: START WITH process_id = p_process_id
944: AND entity_type = ara.object_type
945: AND organization_id = p_org_id
946: AND entity_id = p_certification_id

Line 988: FROM amw_execution_scope processorg

984: IS
985: CURSOR get_total_org
986: IS
987: SELECT count(distinct processorg.organization_id)
988: FROM amw_execution_scope processorg
989: WHERE processorg.process_id = p_process_id
990: AND processorg.organization_id IN
991: (SELECT object_id
992: FROM amw_entity_hierarchies

Line 1008: FROM amw_execution_scope scp,

1004: CURSOR get_var_total_org
1005: IS
1006: SELECT count(1)
1007: FROM (SELECT distinct procorg.organization_id, procorg.process_id
1008: FROM amw_execution_scope scp,
1009: amw_process_organization procorg
1010: WHERE scp.process_org_rev_id = procorg.process_org_rev_id
1011: AND procorg.standard_variation IN
1012: (select process_rev_id

Line 1087: AND exists (select 'Y' from amw_execution_scope scope

1083: CONNECT BY parent_object_id = PRIOR object_id
1084: AND parent_object_type = PRIOR object_type
1085: AND entity_id = PRIOR entity_id
1086: AND entity_type = PRIOR entity_type)
1087: AND exists (select 'Y' from amw_execution_scope scope
1088: where scope.entity_type='BUSIPROC_CERTIFICATION'
1089: and scope.entity_id=p_certification_id
1090: and scope.organization_id=opinion.pk3_value
1091: and scope.process_id=opinion.pk1_value);

Line 1098: amw_execution_scope scp,

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
1102: AND opinion.pk3_value = scp.organization_id

Line 1187: AND exists (select 'Y' from amw_execution_scope scope

1183: CONNECT BY parent_object_id = PRIOR object_id
1184: AND parent_object_type = PRIOR object_type
1185: AND entity_id = PRIOR entity_id
1186: AND entity_type = PRIOR entity_type)
1187: AND exists (select 'Y' from amw_execution_scope scope
1188: where scope.entity_type='BUSIPROC_CERTIFICATION'
1189: and scope.entity_id=p_certification_id
1190: and scope.organization_id=opinion.pk3_value
1191: and scope.process_id=opinion.pk1_value);

Line 1198: amw_execution_scope scp,

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
1202: AND opinion.pk3_value = scp.organization_id

Line 1258: FROM amw_execution_scope

1254: IS
1255: CURSOR get_all_sub_processes
1256: IS
1257: SELECT count(distinct process_id)
1258: FROM amw_execution_scope
1259: START WITH parent_process_id = p_process_id
1260: AND organization_id = p_org_id
1261: AND entity_id = p_certification_id
1262: AND entity_type = 'BUSIPROC_CERTIFICATION'

Line 1287: FROM amw_execution_scope amw_exec

1283: IS
1284: CURSOR get_cert_sub_process
1285: IS
1286: SELECT count(distinct process_id)
1287: FROM amw_execution_scope amw_exec
1288: WHERE EXISTS (SELECT opinion.opinion_id
1289: FROM amw_opinions_v opinion
1290: WHERE opinion.pk1_value = amw_exec.process_id
1291: AND opinion.pk3_value = p_org_id

Line 1324: FROM amw_execution_scope amw_exec

1320: IS
1321: CURSOR get_sub_process_cert_issues
1322: IS
1323: SELECT count(distinct process_id)
1324: FROM amw_execution_scope amw_exec
1325: WHERE EXISTS (SELECT opinion.opinion_id
1326: FROM amw_opinions_v opinion
1327: WHERE opinion.pk1_value = amw_exec.process_id
1328: AND opinion.pk3_value = p_org_id