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_OPINIONS_V

Line 1289: FROM amw_opinions_v opinion

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
1292: AND opinion.pk2_value = p_certification_id
1293: AND opinion.opinion_type_code = 'CERTIFICATION'

Line 1326: FROM amw_opinions_v opinion

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
1329: AND opinion.pk2_value = p_certification_id
1330: AND opinion.opinion_type_code = 'CERTIFICATION'