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_PROCESS_CERT_SUMMARY dependencies on AMW_PROCESS_ORGANIZATION

Line 322: amw_process_organization procorg

318: IS
319: SELECT count(1)
320: FROM (SELECT distinct procorg.organization_id, procorg.process_id
321: FROM amw_execution_scope scp,
322: amw_process_organization procorg
323: WHERE scp.process_org_rev_id = procorg.process_org_rev_id
324: AND procorg.standard_variation IN
325: (select process_rev_id
326: from amw_process

Line 374: amw_process_organization procorg

370: SELECT count(1)
371: FROM (SELECT distinct opinion.pk1_value, opinion.pk3_value
372: FROM amw_opinions_v opinion,
373: amw_execution_scope scp,
374: amw_process_organization procorg
375: WHERE opinion.pk2_value = p_certification_id
376: AND opinion.pk1_value = scp.process_id
377: AND opinion.pk3_value = scp.organization_id
378: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'

Line 495: amw_process_organization procorg

491: SELECT count(1)
492: FROM (SELECT distinct opinion.pk1_value, opinion.pk3_value
493: FROM amw_opinions_v opinion,
494: amw_execution_scope scp,
495: amw_process_organization procorg
496: WHERE opinion.pk2_value = p_certification_id
497: AND opinion.pk1_value = scp.process_id
498: AND opinion.pk3_value = scp.organization_id
499: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'