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.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_OPINIONS_V

Line 40: FROM amw_risk_associations ara, amw_opinions_v aov

36: ,c_organization_id in number
37: ,c_process_id in number) is
38: SELECT count(1)
39: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
40: FROM amw_risk_associations ara, amw_opinions_v aov
41: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
42: AND ara.pk1 = c_certification_id
43: AND ara.pk2 = c_organization_id
44: AND ara.pk3 IN (SELECT DISTINCT process_id

Line 80: amw_opinions_v aov

76: aca.pk3 process_id,
77: aca.pk4 risk_id,
78: aca.control_id
79: FROM amw_control_associations aca,
80: amw_opinions_v aov
81: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
82: AND aca.pk1 = c_certification_id
83: AND aca.pk2 = c_organization_id
84: AND aca.pk3 IN (SELECT DISTINCT process_id