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_PROCCERT_EVENT_PVT dependencies on AMW_EXECUTION_SCOPE

Line 292: FROM amw_execution_scope

288: WHERE certification_id = l_cert_id
289: AND organization_id = l_org_id
290: AND process_id IN (
291: SELECT process_id
292: FROM amw_execution_scope
293: START WITH process_id = l_process_id
294: AND organization_id = l_org_id
295: AND entity_id = l_cert_id
296: AND entity_type = 'BUSIPROC_CERTIFICATION'

Line 393: FROM amw_certification_b cert, amw_execution_scope scope

389: evaluation_opinion_log_id = l_opin_log_id
390: WHERE organization_id = l_pk1
391: AND certification_id IN (
392: SELECT cert.certification_id
393: FROM amw_certification_b cert, amw_execution_scope scope
394: WHERE cert.certification_status in ('ACTIVE','DRAFT')
395: AND cert.object_type = 'PROCESS'
396: AND scope.entity_type = 'BUSIPROC_CERTIFICATION'
397: AND scope.entity_id = cert.certification_id

Line 641: FROM amw_execution_scope

637: WHERE certification_id = risk_rec.certification_id
638: AND organization_id = l_pk3
639: AND process_id IN (
640: SELECT process_id
641: FROM amw_execution_scope
642: START WITH process_id = l_pk4
643: AND organization_id = l_pk3
644: AND entity_id = risk_rec.certification_id
645: AND entity_type = 'BUSIPROC_CERTIFICATION'

Line 693: FROM amw_execution_scope

689: WHERE certification_id = risk_rec.certification_id
690: AND organization_id = l_pk3
691: AND process_id IN (
692: SELECT process_id
693: FROM amw_execution_scope
694: START WITH process_id = l_pk4
695: AND organization_id = l_pk3
696: AND entity_id = risk_rec.certification_id
697: AND entity_type = 'BUSIPROC_CERTIFICATION'

Line 741: FROM amw_execution_scope

737: WHERE certification_id = risk_rec.certification_id
738: AND organization_id = l_pk3
739: AND process_id IN (
740: SELECT process_id
741: FROM amw_execution_scope
742: START WITH process_id = l_pk4
743: AND organization_id = l_pk3
744: AND entity_id = risk_rec.certification_id
745: AND entity_type = 'BUSIPROC_CERTIFICATION'

Line 797: FROM amw_execution_scope

793: WHERE certification_id = risk_rec.certification_id
794: AND organization_id = l_pk3
795: AND process_id IN (
796: SELECT process_id
797: FROM amw_execution_scope
798: START WITH process_id = l_pk4
799: AND organization_id = l_pk3
800: AND entity_id = risk_rec.certification_id
801: AND entity_type = 'BUSIPROC_CERTIFICATION'

Line 910: FROM amw_execution_scope --, amw_control_associations assoc

906: WHERE certification_id = ctrl_rec.certification_id
907: AND organization_id = l_pk3
908: AND process_id IN (
909: SELECT process_id
910: FROM amw_execution_scope --, amw_control_associations assoc
911: START WITH process_id IN (
912: SELECT pk3
913: FROM amw_control_associations
914: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 969: FROM amw_execution_scope --, amw_control_associations assoc

965: WHERE certification_id = ctrl_rec.certification_id
966: AND organization_id = l_pk3
967: AND process_id IN (
968: SELECT process_id
969: FROM amw_execution_scope --, amw_control_associations assoc
970: START WITH process_id IN (
971: SELECT pk3
972: FROM amw_control_associations
973: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 1025: FROM amw_execution_scope --, amw_control_associations assoc

1021: WHERE certification_id = ctrl_rec.certification_id
1022: AND organization_id = l_pk3
1023: AND process_id IN (
1024: SELECT process_id
1025: FROM amw_execution_scope --, amw_control_associations assoc
1026: START WITH process_id IN (
1027: SELECT pk3
1028: FROM amw_control_associations
1029: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 1089: FROM amw_execution_scope --, amw_control_associations assoc

1085: WHERE certification_id = ctrl_rec.certification_id
1086: AND organization_id = l_pk3
1087: AND process_id IN (
1088: SELECT process_id
1089: FROM amw_execution_scope --, amw_control_associations assoc
1090: START WITH process_id IN (
1091: SELECT pk3
1092: FROM amw_control_associations
1093: WHERE object_type = 'BUSIPROC_CERTIFICATION'

Line 1252: FROM AMW_EXECUTION_SCOPE aes

1248: AND v2.opinion_log_id < c_opin_log_id);
1249:
1250: CURSOR c_orgs_pending_in_scope(c_cert_id NUMBER) IS
1251: SELECT count(distinct aes.organization_id)
1252: FROM AMW_EXECUTION_SCOPE aes
1253: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1254: AND aes.entity_id = c_cert_id
1255: AND aes.level_id = 4
1256: AND not exists (SELECT 'Y'

Line 1307: FROM amw_execution_scope

1303: WHERE certification_id = l_cert_id
1304: AND organization_id = l_org_id
1305: AND process_id in (
1306: SELECT parent_process_id
1307: FROM amw_execution_scope
1308: START WITH entity_type = 'BUSIPROC_CERTIFICATION'
1309: AND entity_id = l_cert_id
1310: AND organization_id = l_org_id
1311: AND process_id = l_process_id

Line 1325: FROM amw_execution_scope scp,

1321: AND (process_id = l_process_id
1322: OR
1323: process_id IN (
1324: SELECT proc.process_id
1325: FROM amw_execution_scope scp,
1326: amw_process_organization procorg,
1327: amw_process proc
1328: WHERE scp.entity_id = l_cert_id
1329: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'