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_FINSTMT_CERT_BES_PKG dependencies on AMW_OPINIONS_LOG

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 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 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 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 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 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 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 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''