APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_OPINION_LOG_MV

Line 697: amw_opinion_log_mv aov,

693:
694: l_stmt := 'select count(1) from (
695: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
696: FROM
697: amw_opinion_log_mv aov,
698: amw_fin_item_acc_risk fin,
699: amw_risk_associations risks
700: WHERE risks.pk1 = fin.fin_certification_id
701: and risks.object_type = ''PROCESS_FINCERT''

Line 829: amw_opinion_log_mv aov,

825:
826: l_stmt := 'select count(1) from (
827: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
828: FROM
829: amw_opinion_log_mv aov,
830: amw_fin_item_acc_risk fin,
831: amw_risk_associations risks
832: WHERE risks.pk1 = fin.fin_certification_id
833: and risks.object_type = ''PROCESS_FINCERT''

Line 927: amw_opinion_log_mv aov,

923: **** so that it consists with VO query and also reduces the maintainence ***********************/
924: l_stmt := 'select count(1) from(
925: select distinct fin.control_id, fin.organization_id
926: FROM
927: amw_opinion_log_mv aov,
928: amw_fin_item_acc_ctrl fin,
929: amw_control_associations ctrls
930: WHERE
931: aov.opinion_log_id = ctrls.pk5

Line 1019: AMW_OPINION_LOG_MV aov,

1015: ******/
1016: l_stmt := 'select count(1) from(
1017: select distinct fin.control_id, fin.organization_id
1018: FROM
1019: AMW_OPINION_LOG_MV aov,
1020: amw_fin_item_acc_ctrl fin,
1021: amw_control_associations ctrls
1022: WHERE
1023: aov.opinion_log_id = ctrls.pk5

Line 1138: FROM AMW_OPINION_LOG_MV aov

1134: )IS
1135: BEGIN
1136: IF (P_OBJECT_TYPE = 'FINANCIAL ITEM') THEN
1137: SELECT max(aov.opinion_log_id) INTO X_FIN_EVALUATION
1138: FROM AMW_OPINION_LOG_MV aov
1139: WHERE aov.object_name = 'AMW_FINANCIAL_ITEM'
1140: AND aov.opinion_type_code = 'EVALUATION'
1141: AND aov.pk1_value = P_FINANCIAL_ITEM_ID
1142: AND aov.pk2_value = P_CERTIFICATION_ID

Line 1151: FROM AMW_OPINION_LOG_MV aov

1147: and aov2.pk1_value = aov.pk1_value);
1148:
1149: ELSIF (P_OBJECT_TYPE = 'ACCOUNT') THEN
1150: SELECT max(aov.opinion_log_id) INTO X_FIN_EVALUATION
1151: FROM AMW_OPINION_LOG_MV aov
1152: WHERE aov.object_name = 'AMW_KEY_ACCOUNT'
1153: AND aov.opinion_type_code = 'EVALUATION'
1154: AND aov.pk1_value = P_ACCOUNT_ID
1155: AND aov.pk2_value = P_CERTIFICATION_ID

Line 1476: AMW_OPINION_LOG_MV op

1472:
1473: ----unmitigated_risks IS
1474: SELECT count(1) INTO x_unmitigated_risks
1475: from AMW_RISK_ASSOCIATIONS risks,
1476: AMW_OPINION_LOG_MV op
1477: where risks.pk1 = p_certification_id
1478: and risks.pk4 = op.opinion_log_id (+)
1479: and op.OPINION_VALUE_CODE <> 'EFFECTIVE'
1480: and risks.object_type = 'PROCESS_FINCERT';

Line 1515: FROM AMW_OPINION_LOG_MV aov,

1511: AND aov.OPINION_VALUE_CODE <> 'EFFECTIVE');
1512: **********************/
1513: SELECT count(1) INTO x_ineffective_controls
1514: from(select distinct fin.control_id, fin.organization_id
1515: FROM AMW_OPINION_LOG_MV aov,
1516: AMW_FIN_ITEM_ACC_CTRL fin
1517: WHERE fin.fin_certification_id = p_certification_id
1518: AND fin.object_type = 'FINANCIAL STATEMENT'
1519: AND aov.opinion_log_id = fin.OPINION_LOG_ID

Line 3370: dbms_mview.refresh('AMW_OPINION_LOG_MV', '?');

3366:
3367: SAVEPOINT Master_Fin_Proc_Eval_Sum;
3368:
3369: dbms_mview.refresh('AMW_OPINION_MV', '?');
3370: dbms_mview.refresh('AMW_OPINION_LOG_MV', '?');
3371:
3372: l_start_date := p_start_date;
3373: IF(p_mode = 'NEW') THEN
3374: Populate_All_Fin_Proc_Eval_Sum

Line 4637: FROM AMW_OPINION_LOG_MV aov

4633:
4634: --in risk association table, if type = 'PROCESS_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=opinion_log_id
4635: CURSOR last_evaluation(l_risk_id number, l_organization_id number, l_process_id number) IS
4636: SELECT distinct aov.opinion_log_id
4637: FROM AMW_OPINION_LOG_MV aov
4638: WHERE aov.object_name = 'AMW_ORG_PROCESS_RISK'
4639: AND aov.opinion_type_code = 'EVALUATION'
4640: AND aov.pk3_value = l_organization_id
4641: AND aov.pk4_value = l_process_id

Line 4981: FROM AMW_OPINION_LOG_MV aov

4977:
4978: --in control association table, if type = 'RISK_FINCERT', pk1=certification_id, pk2=organization_id, pk3=process_id, pk4=risk_id, pk5=opinion_log_id
4979: CURSOR last_evaluation(l_organization_id number, l_control_id number) IS
4980: SELECT distinct aov.opinion_log_id
4981: FROM AMW_OPINION_LOG_MV aov
4982: WHERE aov.object_name = 'AMW_ORG_CONTROL'
4983: AND aov.opinion_type_code = 'EVALUATION'
4984: AND aov.pk3_value = l_organization_id
4985: AND aov.pk1_value = l_control_id