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_CERT_EVAL_SUM_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 223: FROM amw_control_associations aca,amw_opinions_v aov

219: ---instead of having a distinct on
220: ---certificationId, organizationId, processId, riskId, controlId
221: ---FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id, aca.control_id
222: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
223: FROM amw_control_associations aca,amw_opinions_v aov
224: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
225: AND aca.pk1 = p_certification_id
226: AND aca.pk2 = p_org_id
227: AND aov.object_name = 'AMW_ORG_CONTROL'

Line 249: FROM amw_control_associations aca,amw_opinions_v aov

245: ---instead of having a distinct on
246: ---certificationId, organizationId, processId, riskId, controlId
247: ---FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.pk3 process_id, aca.pk4 risk_id, aca.control_id
248: FROM (SELECT DISTINCT aca.pk1 certification_id, aca.pk2 organization_id, aca.control_id
249: FROM amw_control_associations aca,amw_opinions_v aov
250: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
251: AND aca.pk1 = p_certification_id
252: AND aca.pk2 = p_org_id
253: AND aov.object_name = 'AMW_ORG_CONTROL'

Line 263: FROM amw_control_associations aca

259:
260: CURSOR get_total_controls
261: IS
262: SELECT count(DISTINCT aca.control_id)
263: FROM amw_control_associations aca
264: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
265: AND aca.pk1 = p_certification_id
266: AND aca.pk2 = p_org_id;
267: