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.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_OPINIONS

Line 382: from AMW_OPINIONS aov2

378: AMW_OPINION_MV aov,
379: amw_fin_cert_scope fin
380: WHERE
381: aov.AUTHORED_DATE in (select max(aov2.authored_date)
382: from AMW_OPINIONS aov2
383: where aov2.object_opinion_type_id = aov.object_opinion_type_id
384: and aov2.pk1_value = aov.pk1_value )
385: and aov.OPINION_TYPE_CODE = ''EVALUATION''
386: and aov.object_name = ''AMW_ORGANIZATION''

Line 564: from AMW_OPINIONS aov2

560: AMW_OPINION_MV aov,
561: AMW_FIN_CERT_SCOPE fin
562: WHERE
563: aov.AUTHORED_DATE in (select max(aov2.authored_date)
564: from AMW_OPINIONS aov2
565: where aov2.object_opinion_type_id = aov.object_opinion_type_id
566: and aov2.pk1_value = aov.pk1_value )
567: and aov.OPINION_TYPE_CODE = ''CERTIFICATION''
568: and aov.object_name = ''AMW_ORGANIZATION''

Line 630: from AMW_OPINIONS aov2

626: AMW_OPINION_MV aov,
627: amw_fin_cert_scope fin
628: WHERE
629: aov.AUTHORED_DATE in (select max(aov2.authored_date)
630: from AMW_OPINIONS aov2
631: where aov2.object_opinion_type_id = aov.object_opinion_type_id
632: and aov2.pk1_value = aov.pk1_value
633: and aov2.pk3_value = aov.pk3_value)
634: and aov.OPINION_TYPE_CODE = ''EVALUATION''

Line 711: from AMW_OPINIONS aov2

707: and aov.object_name = ''AMW_ORG_PROCESS_RISK''
708: and aov.opinion_component_code = ''OVERALL''
709: and aov.OPINION_VALUE_CODE <> ''EFFECTIVE''
710: and aov.AUTHORED_DATE in (select max(aov2.authored_date)
711: from AMW_OPINIONS aov2
712: where aov2.object_opinion_type_id = aov.object_opinion_type_id
713: and aov2.pk1_value = aov.pk1_value
714: and aov2.pk3_value = aov.pk3_value
715: and aov2.pk4_value = aov.pk4_value

Line 905: from AMW_OPINIONS aov2

901: AMW_OPINION_MV aov,
902: amw_fin_item_acc_ctrl fin
903: WHERE
904: aov.AUTHORED_DATE in (select max(aov2.authored_date)
905: from AMW_OPINIONS aov2
906: where aov2.object_opinion_type_id = aov.object_opinion_type_id
907: and aov2.pk1_value = aov.pk1_value
908: and aov2.pk3_value = aov.pk3_value)
909: AND aov.OPINION_TYPE_CODE = ''EVALUATION''

Line 941: from AMW_OPINIONS aov2

937: and aov.object_name = ''AMW_ORG_CONTROL''
938: and aov.OPINION_VALUE_CODE <> ''EFFECTIVE''
939: and aov.opinion_component_code = ''OVERALL''
940: and aov.AUTHORED_DATE in (select max(aov2.authored_date)
941: from AMW_OPINIONS aov2
942: where aov2.object_opinion_type_id = aov.object_opinion_type_id
943: and aov2.pk1_value = aov.pk1_value
944: and aov2.pk3_value = aov.pk3_value)
945: and fin.object_type = ''' || P_OBJECT_TYPE || '''' || '

Line 1144: from AMW_OPINIONS aov2

1140: AND aov.opinion_type_code = 'EVALUATION'
1141: AND aov.pk1_value = P_FINANCIAL_ITEM_ID
1142: AND aov.pk2_value = P_CERTIFICATION_ID
1143: AND aov.authored_date = (select max(aov2.authored_date)
1144: from AMW_OPINIONS aov2
1145: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1146: and aov2.pk2_value = aov.pk2_value
1147: and aov2.pk1_value = aov.pk1_value);
1148:

Line 1157: from AMW_OPINIONS aov2

1153: AND aov.opinion_type_code = 'EVALUATION'
1154: AND aov.pk1_value = P_ACCOUNT_ID
1155: AND aov.pk2_value = P_CERTIFICATION_ID
1156: AND aov.authored_date = (select max(aov2.authored_date)
1157: from AMW_OPINIONS aov2
1158: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1159: and aov2.pk2_value = aov.pk2_value
1160: and aov2.pk1_value = aov.pk1_value);
1161: END IF;

Line 1219: from AMW_OPINIONS aov2

1215: and aov.object_name = ''AMW_ORG_PROCESS''
1216: and aov.OPINION_VALUE_CODE <> ''EFFECTIVE''
1217: and aov.opinion_component_code = ''OVERALL''
1218: and aov.authored_date = (select max(aov2.authored_date)
1219: from AMW_OPINIONS aov2
1220: where aov2.object_opinion_type_id
1221: = aov.object_opinion_type_id
1222: and aov2.pk3_value = aov.pk3_value
1223: AND aov2.pk2_value in

Line 1347: from AMW_OPINIONS aov2

1343: AND rel.end_date is null
1344: AND aov.pk1_value = proc.process_id
1345: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE'
1346: AND aov.authored_date = (select max(aov2.authored_date)
1347: from AMW_OPINIONS aov2
1348: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1349: and aov2.pk3_value = aov.pk3_value
1350: and aov2.pk1_value = aov.pk1_value));
1351: END Get_global_proc_with_issue;

Line 1377: from AMW_OPINIONS aov2

1373: AND rel.end_date is null
1374: AND aov.pk1_value = proc.process_id
1375: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE'
1376: AND aov.authored_date = (select max(aov2.authored_date)
1377: from AMW_OPINIONS aov2
1378: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1379: and aov2.pk3_value = aov.pk3_value
1380: and aov2.pk1_value = aov.pk1_value));
1381: END Get_local_proc_with_issue;

Line 1405: from AMW_OPINIONS aov2

1401: AND aov.object_name = 'AMW_ORG_PROCESS'
1402: AND aov.opinion_type_code = 'EVALUATION'
1403: AND aov.opinion_component_code = 'OVERALL'
1404: AND aov.authored_date = (select max(aov2.authored_date)
1405: from AMW_OPINIONS aov2
1406: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1407: and aov2.pk3_value = aov.pk3_value
1408: and aov2.pk1_value = aov.pk1_value)
1409: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE');

Line 1434: from AMW_OPINIONS aov2

1430: AND aov.object_name = 'AMW_ORG_PROCESS'
1431: AND aov.opinion_type_code = 'EVALUATION'
1432: AND aov.opinion_component_code = 'OVERALL'
1433: AND aov.authored_date = (select max(aov2.authored_date)
1434: from AMW_OPINIONS aov2
1435: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1436: and aov2.pk3_value = aov.pk3_value
1437: and aov2.pk1_value = aov.pk1_value)
1438: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE');

Line 1457: from AMW_OPINIONS aov2

1453: WHERE
1454: fin.object_type = 'FINANCIAL STATEMENT'
1455: AND fin.FIN_CERTIFICATION_ID = p_certification_id
1456: AND aov.AUTHORED_DATE in (select max(aov2.authored_date)
1457: from AMW_OPINIONS aov2
1458: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1459: and aov2.pk1_value = aov.pk1_value
1460: and aov2.pk3_value = aov.pk3_value
1461: and aov2.pk4_value = aov.pk4_value)

Line 1507: from AMW_OPINIONS aov2

1503: AND aov.OPINION_TYPE_CODE = 'EVALUATION'
1504: AND aov.object_name = 'AMW_ORG_CONTROL'
1505: AND aov.opinion_component_code = 'OVERALL'
1506: AND aov.AUTHORED_DATE in (select max(aov2.authored_date)
1507: from AMW_OPINIONS aov2
1508: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1509: and aov2.pk1_value = aov.pk1_value
1510: and aov2.pk3_value = aov.pk3_value)
1511: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE');

Line 1524: from AMW_OPINIONS aov2

1520: AND aov.OPINION_TYPE_CODE = 'EVALUATION'
1521: AND aov.object_name = 'AMW_ORG_CONTROL'
1522: AND aov.opinion_component_code = 'OVERALL'
1523: AND aov.AUTHORED_DATE in (select max(aov2.authored_date)
1524: from AMW_OPINIONS aov2
1525: where aov2.object_opinion_type_id = aov.object_opinion_type_id
1526: and aov2.pk1_value = aov.pk1_value
1527: and aov2.pk3_value = aov.pk3_value)
1528: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE');

Line 2885: AMW_OPINIONS_LOG oplog

2881: SELECT obj.obj_name , oplog.pk1_value, oplog.pk2_value, oplog.pk3_value,
2882: oplog.pk4_value, oplog.pk5_value, oplog.opinion_id
2883: FROM FND_OBJECTS obj,
2884: AMW_OBJECT_OPINION_TYPES oot,
2885: AMW_OPINIONS_LOG oplog
2886: WHERE oplog.opinion_log_id = p_opinion_log_id
2887: AND oplog.object_opinion_type_id = oot.object_opinion_type_id
2888: AND oot.object_id = obj.object_id;
2889:

Line 3034: AMW_OPINIONS_LOG oplog

3030: SELECT obj.obj_name , oplog.pk1_value, oplog.pk2_value, oplog.pk3_value,
3031: oplog.pk4_value, oplog.pk5_value, oplog.opinion_id
3032: FROM FND_OBJECTS obj,
3033: AMW_OBJECT_OPINION_TYPES oot,
3034: AMW_OPINIONS_LOG oplog
3035: WHERE oplog.opinion_log_id = p_opinion_log_id
3036: AND oplog.object_opinion_type_id = oot.object_opinion_type_id
3037: AND oot.object_id = obj.object_id;
3038:

Line 4053: from AMW_OPINIONS aov2

4049: where fin_stmt_cert_id = p_certification_id
4050: and end_date is null)
4051: AND aov.pk1_value = p_process_id
4052: AND aov.authored_date = (select max(aov2.authored_date)
4053: from AMW_OPINIONS aov2
4054: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4055: and aov2.pk3_value = aov.pk3_value
4056: and aov2.pk1_value = aov.pk1_value
4057: and aov2.pk2_value in

Line 4066: FROM AMW_OPINIONS_LOG

4062:
4063:
4064: CURSOR certification_result_history(p_opinion_id number) IS
4065: SELECT max(opinion_log_id)
4066: FROM AMW_OPINIONS_LOG
4067: WHERE opinion_id = p_opinion_id;
4068:
4069:
4070: CURSOR last_evaluation IS

Line 4081: from AMW_OPINIONS aov2

4077: AND aov.pk1_value = p_process_id
4078: --fix bug 5724066
4079: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4080: AND aov.authored_date = (select max(aov2.authored_date)
4081: from AMW_OPINIONS aov2
4082: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4083: and aov2.pk3_value = aov.pk3_value
4084: and aov2.pk1_value = aov.pk1_value);
4085:

Line 4088: from amw_opinions_log

4084: and aov2.pk1_value = aov.pk1_value);
4085:
4086: CURSOR last_evaluation_history(p_opinion_id number) IS
4087: select max(opinion_log_id)
4088: from amw_opinions_log
4089: where opinion_id = p_opinion_id;
4090:
4091:
4092: CURSOR unmitigated_risks IS

Line 4115: from AMW_OPINIONS aov2

4111: AND aov.pk1_value = ara.risk_id
4112: --fix bug 5724066
4113: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4114: AND aov.authored_date = (select max(aov2.authored_date)
4115: from AMW_OPINIONS aov2
4116: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4117: and aov2.pk4_value = aov.pk4_value
4118: and aov2.pk3_value = aov.pk3_value
4119: and aov2.pk1_value = aov.pk1_value)

Line 4190: from AMW_OPINIONS aov2

4186: AND aov.pk1_value = aca.control_id
4187: --fix bug 5724066
4188: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4189: AND aov.authored_date = (select max(aov2.authored_date)
4190: from AMW_OPINIONS aov2
4191: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4192: and aov2.pk3_value = aov.pk3_value
4193: and aov2.pk1_value = aov.pk1_value)
4194: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE';

Line 4646: from AMW_OPINIONS aov2

4642: AND aov.pk1_value = l_risk_id
4643: --fix bug 5724066
4644: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4645: AND aov.authored_date = (select max(aov2.authored_date)
4646: from AMW_OPINIONS aov2
4647: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4648: and aov2.pk3_value = aov.pk3_value
4649: and aov2.pk1_value = aov.pk1_value
4650: and aov2.pk4_value = aov.pk4_value);

Line 4989: from AMW_OPINIONS aov2

4985: AND aov.pk1_value = l_control_id
4986: --fix bug 5724066
4987: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
4988: AND aov.authored_date = (select max(aov2.authored_date)
4989: from AMW_OPINIONS aov2
4990: where aov2.object_opinion_type_id = aov.object_opinion_type_id
4991: and aov2.pk3_value = aov.pk3_value
4992: and aov2.pk1_value = aov.pk1_value);
4993:

Line 5324: from AMW_OPINIONS aov2

5320: AND aov.pk1_value = l_control_id
5321: --fix bug 5724066
5322: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5323: AND aov.authored_date = (select max(aov2.authored_date)
5324: from AMW_OPINIONS aov2
5325: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5326: and aov2.pk3_value = aov.pk3_value
5327: and aov2.pk1_value = aov.pk1_value
5328: and aov2.pk4_value = aov.pk4_value);

Line 5670: from AMW_OPINIONS aov2

5666: AND aov.pk1_value = p_organization_id
5667: --fix bug 5724066
5668: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5669: AND aov.authored_date = (select max(aov2.authored_date)
5670: from AMW_OPINIONS aov2
5671: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5672: and aov2.pk1_value = aov.pk1_value);
5673:
5674: CURSOR last_evaluation_history(l_opinion_id number) IS

Line 5676: FROM AMW_OPINIONS_LOG aov

5672: and aov2.pk1_value = aov.pk1_value);
5673:
5674: CURSOR last_evaluation_history(l_opinion_id number) IS
5675: SELECT max(aov.opinion_log_id)
5676: FROM AMW_OPINIONS_LOG aov
5677: WHERE aov.opinion_id = l_opinion_id;
5678:
5679: CURSOR last_certification IS
5680: SELECT aov.opinion_id

Line 5687: from AMW_OPINIONS aov2

5683: AND aov.opinion_type_code = 'CERTIFICATION'
5684: AND aov.opinion_component_code = 'OVERALL'
5685: AND aov.pk1_value = p_organization_id
5686: AND aov.authored_date = (select max(aov2.authored_date)
5687: from AMW_OPINIONS aov2
5688: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5689: and aov2.pk1_value = aov.pk1_value)
5690: AND aov.pk2_value in (select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
5691: where fin_stmt_cert_id = p_certification_id

Line 5696: FROM AMW_OPINIONS_LOG aov

5692: and end_date is null );
5693:
5694: CURSOR last_certification_history(l_opinion_id number) IS
5695: SELECT max(opinion_log_id)
5696: FROM AMW_OPINIONS_LOG aov
5697: WHERE aov.opinion_id = l_opinion_id;
5698:
5699: CURSOR total_num_of_proc IS
5700: SELECT COUNT(DISTINCT PROCESS_ID) FROM AMW_FIN_PROCESS_EVAL_SUM

Line 5727: from AMW_OPINIONS aov2

5723: where fin_stmt_cert_id = p_certification_id
5724: and end_date is null )
5725: AND aov.pk1_value = proeval.process_id
5726: AND aov.authored_date = (select max(aov2.authored_date)
5727: from AMW_OPINIONS aov2
5728: where aov2.object_opinion_type_id
5729: = aov.object_opinion_type_id
5730: and aov2.pk3_value = aov.pk3_value
5731: AND aov2.pk2_value in

Line 5753: from AMW_OPINIONS aov2

5749: where fin_stmt_cert_id = p_certification_id
5750: and end_date is null)
5751: AND aov.pk1_value = proeval.process_id
5752: AND aov.authored_date = (select max(aov2.authored_date)
5753: from AMW_OPINIONS aov2
5754: where aov2.object_opinion_type_id
5755: = aov.object_opinion_type_id
5756: and aov2.pk3_value = aov.pk3_value
5757: AND aov2.pk2_value in

Line 5779: from AMW_OPINIONS aov2

5775: --fix bug 5724066
5776: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5777: AND aov.authored_date =
5778: (select max(aov2.authored_date)
5779: from AMW_OPINIONS aov2
5780: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5781: and aov2.pk3_value = aov.pk3_value
5782: and aov2.pk1_value = aov.pk1_value)
5783: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE';

Line 5817: from AMW_OPINIONS aov2

5813: AND aov.pk1_value = ara.risk_id
5814: --fix bug 5724066
5815: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5816: AND aov.authored_date = (select max(aov2.authored_date)
5817: from AMW_OPINIONS aov2
5818: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5819: and aov2.pk4_value = aov.pk4_value
5820: and aov2.pk3_value = aov.pk3_value
5821: and aov2.pk1_value = aov.pk1_value)

Line 5863: from AMW_OPINIONS aov2

5859: AND aov.pk1_value = aca.control_id
5860: --fix bug 5724066
5861: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
5862: AND aov.authored_date = (select max(aov2.authored_date)
5863: from AMW_OPINIONS aov2
5864: where aov2.object_opinion_type_id = aov.object_opinion_type_id
5865: and aov2.pk3_value = aov.pk3_value
5866: and aov2.pk1_value = aov.pk1_value)
5867: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE';

Line 7547: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;

7543: M_proc_risks_verified number ;
7544: M_proc_risks_total number;
7545:
7546:
7547: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;
7548:
7549: M_change_flag VARCHAR2(1);
7550: M_new_flag VARCHAR2(1) := 'N';
7551:

Line 8093: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;

8089:
8090: M_dashboard_ineff_ctrls number;
8091:
8092:
8093: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;
8094:
8095: /*****************************************
8096: M_new_flag='Y', it's a new evaluation.
8097: M_change_flag='F', it's from ineffective to effective.

Line 8743: AND fin.fin_certification_id in (select rel.fin_stmt_cert_id from amw_fin_proc_cert_relan rel, amw_opinions_log opin

8739: FROM amw_fin_process_flat proc
8740: WHERE proc.fin_certification_id = fin.fin_certification_id
8741: AND proc.organization_id = l_org_id
8742: AND proc.child_process_id = l_process_id)
8743: AND fin.fin_certification_id in (select rel.fin_stmt_cert_id from amw_fin_proc_cert_relan rel, amw_opinions_log opin
8744: where rel.proc_cert_id = opin.pk2_value
8745: and opin.opinion_log_id = l_opinion_log_id
8746: and rel.end_date is null);
8747:

Line 8777: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;

8773: M_org_total_number_process number;
8774: M_org_proc_pending_cert number;
8775: M_org_proc_cert_with_issue number;
8776:
8777: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;
8778:
8779: M_change_flag VARCHAR2(1);
8780: M_new_flag VARCHAR2(1) := 'N';
8781:

Line 9704: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;

9700: M_acc_total_number_process number;
9701: M_acc_proc_cert_with_issue number;
9702: M_acc_proc_with_ineff_ctrl number;
9703:
9704: M_opinion_log_id AMW_OPINIONS_LOG.OPINION_LOG_ID%TYPE;
9705:
9706: M_change_flag VARCHAR2(1);
9707: M_new_flag VARCHAR2(1) := 'N';
9708:

Line 10063: from AMW_OPINIONS_LOG ao,

10059:
10060: --in risk association table, if type = 'PROCESS_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=opinion_log_id
10061: CURSOR last_evaluation(l_risk_id number, l_organization_id number, l_process_id number) IS
10062: select distinct ao.opinion_log_id
10063: from AMW_OPINIONS_LOG ao,
10064: AMW_OBJECT_OPINION_TYPES aoot,
10065: AMW_OPINION_TYPES_B aot,
10066: FND_OBJECTS fo
10067: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID

Line 10078: from AMW_OPINIONS aov2

10074: and ao.pk1_value = l_risk_id
10075: --fix bug 5724066
10076: AND ao.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
10077: and ao.authored_date = (select max(aov2.authored_date)
10078: from AMW_OPINIONS aov2
10079: where aov2.object_opinion_type_id = ao.object_opinion_type_id
10080: and aov2.pk3_value = ao.pk3_value
10081: and aov2.pk1_value = ao.pk1_value
10082: and aov2.pk4_value = ao.pk4_value);

Line 10276: AMW_OPINIONS_LOG ao,

10272: --in control association table, if type = 'RISK_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=risk_id, pk5=opinion_log_id
10273: CURSOR last_evaluation(l_organization_id number, l_control_id number) IS
10274: select distinct ao.opinion_log_id
10275: from
10276: AMW_OPINIONS_LOG ao,
10277: AMW_OBJECT_OPINION_TYPES aoot,
10278: AMW_OPINION_TYPES_B aot,
10279: FND_OBJECTS fo
10280: where ao.OBJECT_OPINION_TYPE_ID = aoot.OBJECT_OPINION_TYPE_ID

Line 10290: from AMW_OPINIONS aov2

10286: and ao.pk1_value = l_control_id
10287: --fix bug 5724066
10288: and ao.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
10289: and ao.authored_date = (select max(aov2.authored_date)
10290: from AMW_OPINIONS aov2
10291: where aov2.object_opinion_type_id = ao.object_opinion_type_id
10292: and aov2.pk3_value = ao.pk3_value
10293: and aov2.pk1_value = ao.pk1_value);
10294:

Line 10494: from AMW_OPINIONS aov2

10490: AND aov.pk1_value = l_control_id
10491: --fix bug 5724066
10492: AND aov.pk2_value not in (select audit_project_id from amw_audit_projects where audit_project_status = 'CANC')
10493: AND aov.authored_date = (select max(aov2.authored_date)
10494: from AMW_OPINIONS aov2
10495: where aov2.object_opinion_type_id = aov.object_opinion_type_id
10496: and aov2.pk3_value = aov.pk3_value
10497: and aov2.pk1_value = aov.pk1_value
10498: and aov2.pk4_value = aov.pk4_value);

Line 10795: amw_opinions_log aol,

10791: l_stmt := 'select count(1) from (
10792: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
10793: FROM
10794: amw_opinion_m_v aov,
10795: amw_opinions_log aol,
10796: amw_fin_item_acc_risk fin
10797: WHERE
10798: aov.OPINION_TYPE_CODE = ''EVALUATION''
10799: and aov.object_name = ''AMW_ORG_PROCESS_RISK''

Line 10878: amw_opinions_log aol,

10874: l_stmt := 'select count(1) from(
10875: select distinct fin.control_id, fin.organization_id
10876: FROM
10877: amw_opinion_m_v aov,
10878: amw_opinions_log aol,
10879: amw_fin_item_acc_ctrl fin
10880: WHERE aov.OPINION_TYPE_CODE = ''EVALUATION''
10881: and aov.object_name = ''AMW_ORG_CONTROL''
10882: and aov.opinion_component_code = ''OVERALL''