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 STANDARD

Line 1011: AND procorg.standard_variation IN

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
1014: where process_id = p_process_id)
1015: AND scp.organization_id IN

Line 1106: AND procorg.standard_variation in

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

Line 1214: AND procorg.standard_variation in

1210: AND aov2.pk1_value = opinion.pk1_value)
1211: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'
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