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_PROCESS

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 428: AND opinion.object_name = 'AMW_PROCESS_ORG'

424: AND opinion.pk1_value = aes.process_id
425: AND opinion.pk3_value = aes.organization_id
426: AND opinion.pk2_value = aes.entity_id
427: AND opinion.opinion_type_code = 'CERTIFICATION'
428: AND opinion.object_name = 'AMW_PROCESS_ORG'
429: AND opinion.authored_date = (SELECT MAX(aov2.authored_date)
430: FROM amw_opinions_log aov2
431: WHERE aov2.object_opinion_type_id = opinion.object_opinion_type_id
432: AND aov2.pk3_value = opinion.pk3_value

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 471: AND opinion.object_name = 'AMW_PROCESS_ORG'

467: AND opinion.pk1_value = aes.process_id
468: AND opinion.pk3_value = aes.organization_id
469: AND opinion.pk2_value = aes.entity_id
470: AND opinion.opinion_type_code = 'CERTIFICATION'
471: AND opinion.object_name = 'AMW_PROCESS_ORG'
472: AND opinion.authored_date = (SELECT MAX(aov2.authored_date)
473: FROM amw_opinions_log aov2
474: WHERE aov2.object_opinion_type_id = opinion.object_opinion_type_id
475: AND aov2.pk3_value = opinion.pk3_value

Line 1009: amw_process_organization procorg

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
1013: from amw_process

Line 1013: from amw_process

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
1013: from amw_process
1014: where process_id = p_process_id)
1015: AND scp.organization_id IN
1016: (SELECT object_id
1017: FROM amw_entity_hierarchies

Line 1099: amw_process_organization procorg

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
1103: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'

Line 1108: from amw_process

1104: AND scp.entity_id = p_certification_id
1105: AND scp.process_org_rev_id = procorg.process_org_rev_id
1106: AND procorg.standard_variation in
1107: (select process_rev_id
1108: from amw_process
1109: where process_id = p_process_id)
1110: AND scp.organization_id IN
1111: (SELECT object_id
1112: FROM amw_entity_hierarchies

Line 1199: amw_process_organization procorg

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
1203: AND opinion.authored_date = (SELECT MAX(aov2.authored_date)

Line 1216: from amw_process

1212: AND scp.entity_id = p_certification_id
1213: AND scp.process_org_rev_id = procorg.process_org_rev_id
1214: AND procorg.standard_variation in
1215: (select process_rev_id
1216: from amw_process
1217: where process_id = p_process_id)
1218: AND scp.organization_id IN
1219: (SELECT object_id
1220: FROM amw_entity_hierarchies