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_RISKS_B

Line 23: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

19: CURSOR get_unmitigated_risks
20: IS
21: SELECT count(1)
22: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
23: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
24: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
25: AND ara.pk1 = p_certification_id
26: AND ara.pk2 = p_org_id
27: AND ara.risk_rev_id = arb.risk_rev_id

Line 72: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

68: CURSOR get_eval_risks
69: IS
70: SELECT count(1)
71: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
72: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
73: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
74: AND ara.pk1 = p_certification_id
75: AND ara.pk2 = p_org_id
76: AND ara.risk_rev_id = arb.risk_rev_id

Line 115: FROM amw_risk_associations ara, amw_risks_b arb

111: CURSOR get_total_risks
112: IS
113: SELECT count(1)
114: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
115: FROM amw_risk_associations ara, amw_risks_b arb
116: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
117: AND ara.risk_rev_id = arb.risk_rev_id
118: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
119: AND ara.pk1 = p_certification_id

Line 144: FROM amw_risk_associations ara, amw_risks_b arb

140: CURSOR get_total_risks
141: IS
142: SELECT count(1)
143: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
144: FROM amw_risk_associations ara, amw_risks_b arb
145: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
146: AND ara.risk_rev_id = arb.risk_rev_id
147: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
148: AND ara.pk1 = p_certification_id

Line 155: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

151: CURSOR get_unmitigated_risks
152: IS
153: SELECT count(1)
154: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
155: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
156: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
157: AND ara.pk1 = p_certification_id
158: AND ara.pk2 = p_org_id
159: AND ara.risk_rev_id = arb.risk_rev_id

Line 745: FROM amw_risk_associations ara, amw_risks_b arb

741: CURSOR get_total_risks
742: IS
743: SELECT count(1)
744: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
745: FROM amw_risk_associations ara, amw_risks_b arb
746: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
747: AND ara.risk_rev_id = arb.risk_rev_id
748: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
749: AND ara.pk1 = p_certification_id

Line 766: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

762: CURSOR get_unmitigated_risks
763: IS
764: SELECT count(1)
765: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
766: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
767: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
768: AND ara.pk1 = p_certification_id
769: AND ara.pk2 = p_org_id
770: AND ara.risk_rev_id = arb.risk_rev_id

Line 835: FROM amw_risk_associations ara, amw_risks_b arb

831: CURSOR get_total_risks
832: IS
833: SELECT count(1)
834: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
835: FROM amw_risk_associations ara, amw_risks_b arb
836: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
837: AND ara.risk_rev_id = arb.risk_rev_id
838: AND nvl(p_material_risks_flag, nvl(arb.material, 'N')) = nvl(arb.material, 'N')
839: AND ara.pk1 = p_certification_id

Line 878: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

874: CURSOR get_eval_risks
875: IS
876: SELECT count(1)
877: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
878: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
879: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
880: AND ara.pk1 = p_certification_id
881: AND ara.pk2 = p_org_id
882: AND ara.risk_rev_id = arb.risk_rev_id

Line 935: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb

931: CURSOR get_unmitigated_risks
932: IS
933: SELECT count(1)
934: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
935: FROM amw_risk_associations ara, amw_opinions_log_v aov, amw_risks_b arb
936: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
937: AND ara.pk1 = p_certification_id
938: AND ara.pk2 = p_org_id
939: AND ara.risk_rev_id = arb.risk_rev_id