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.

[Home] [Help]

APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_RISKS_ALL_VL

Line 780: amw_risks_all_vl arav,

776: count(nvl(riskevalopin.audit_result_code,1)) cnt
777: FROM
778: (SELECT object_type,risk_id,pk1,pk2,pk3,pk4,pk5,risk_rev_id
779: FROM amw_risk_associations WHERE object_type='BUSIPROC_CERTIFICATION') ara,
780: amw_risks_all_vl arav,
781: amw_opinions_log_v riskevalopin
782: WHERE
783: ara.pk1(+)=p_cert_id
784: AND ara.pk2(+)=p_org_id

Line 948: amw_risks_all_vl arav,

944: count(nvl(riskevalopin.audit_result_code,1)) cnt
945: FROM
946: (SELECT object_type,risk_id,pk1,pk2,pk3,pk4,pk5,risk_rev_id
947: FROM amw_risk_associations WHERE object_type='BUSIPROC_CERTIFICATION') ara,
948: amw_risks_all_vl arav,
949: amw_opinions_log_v riskevalopin
950: WHERE
951: ara.pk1(+)=cert_rec.cert_id
952: AND ara.pk2(+)=p_org_id