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_FIN_ITEM_ACC_RISK

Line 698: amw_fin_item_acc_risk fin,

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''
702: and risks.risk_id = fin.risk_id

Line 773: amw_fin_item_acc_risk fin

769: l_stmt := 'select count(1)
770: from (
771: select distinct risk_id, organization_id, process_id
772: FROM
773: amw_fin_item_acc_risk fin
774: WHERE fin.object_type = ''' || P_OBJECT_TYPE || '''' || '
775: AND fin.FIN_CERTIFICATION_ID= :1 ';
776:
777: IF P_OBJECT_TYPE = 'FINANCIAL ITEM' THEN

Line 830: amw_fin_item_acc_risk fin,

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''
834: and risks.risk_id = fin.risk_id

Line 1452: AMW_FIN_ITEM_ACC_RISK fin

1448: /*** remove due to ratio number mismatch
1449: SELECT count(1) INTO x_unmitigated_risks
1450: from (select distinct fin.organization_id, fin.process_id, fin.risk_id
1451: FROM AMW_OPINION_MV aov,
1452: AMW_FIN_ITEM_ACC_RISK fin
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)

Line 2383: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_RISK

2379:
2380: -- Initialize API return status to SUCCESS
2381: x_return_status := FND_API.G_RET_STS_SUCCESS;
2382:
2383: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_RISK
2384: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
2385:
2386: IF (L_COUNT = 0 OR L_COUNT IS NULL) THEN
2387:

Line 2388: insert into amw_fin_item_acc_risk(

2384: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
2385:
2386: IF (L_COUNT = 0 OR L_COUNT IS NULL) THEN
2387:
2388: insert into amw_fin_item_acc_risk(
2389: OBJECT_TYPE,
2390: FIN_CERTIFICATION_ID,
2391: STATEMENT_GROUP_ID,
2392: FINANCIAL_STATEMENT_ID,

Line 3421: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_fin_item_acc_risks table:p_certification_id = ' || p_certification_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

3417: (p_certification_id => p_certification_id,
3418: x_return_status => l_return_status,
3419: x_msg_count => l_msg_count,
3420: x_msg_data => l_msg_data);
3421: fnd_file.put_line(fnd_file.LOG, 'finish populating amw_fin_item_acc_risks table:p_certification_id = ' || p_certification_id || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
3422:
3423: INSERT_FIN_CTRL
3424: (p_certification_id => p_certification_id,
3425: x_return_status => l_return_status,

Line 7450: FROM AMW_FIN_ITEM_ACC_RISK ITEM,

7446:
7447: ---CURSOR TO GET ALL OF FINANCIAL ITEMS WHICH RELATE TO THIS RISK
7448: CURSOR Get_all_items(l_risk_id number, l_org_id number, l_process_id number)IS
7449: SELECT DISTINCT item.FIN_CERTIFICATION_ID, item.STATEMENT_GROUP_ID, item.FINANCIAL_STATEMENT_ID, item.FINANCIAL_ITEM_ID
7450: FROM AMW_FIN_ITEM_ACC_RISK ITEM,
7451: AMW_CERTIFICATION_B cert
7452: WHERE ITEM.RISK_ID = l_risk_id
7453: AND ITEM.ORGANIZATION_ID = l_org_id
7454: AND ITEM.PROCESS_ID = l_process_id

Line 7462: FROM AMW_FIN_ITEM_ACC_RISK finitemAcc,

7458:
7459: --CURSOR TO GET ALL OF ACCOUNTS WHICH RELATE TO THIS RISK
7460: CURSOR Get_all_accts (l_risk_id number, l_org_id number, l_process_id number)IS
7461: SELECT DISTINCT finitemAcc.fin_certification_id, finitemAcc.account_group_id, finitemAcc.natural_account_id
7462: FROM AMW_FIN_ITEM_ACC_RISK finitemAcc,
7463: AMW_CERTIFICATION_B cert
7464: WHERE finitemAcc.RISK_ID = l_risk_id
7465: AND finitemAcc.ORGANIZATION_ID = l_org_id
7466: AND finitemAcc.PROCESS_ID = l_process_id

Line 7676: UPDATE AMW_FIN_ITEM_ACC_RISK

7672: --END IF;
7673:
7674: END IF;
7675:
7676: UPDATE AMW_FIN_ITEM_ACC_RISK
7677: SET
7678: LAST_UPDATE_DATE = sysdate,
7679: last_updated_by = fnd_global.user_id,
7680: last_update_login = fnd_global.conc_login_id,

Line 7778: UPDATE AMW_FIN_ITEM_ACC_RISK

7774: AND OBJECT_TYPE = 'ACCOUNT';
7775: --END IF;
7776: END IF;
7777:
7778: UPDATE AMW_FIN_ITEM_ACC_RISK
7779: SET
7780: LAST_UPDATE_DATE = sysdate,
7781: last_updated_by = fnd_global.user_id,
7782: last_update_login = fnd_global.conc_login_id,

Line 10777: amw_fin_item_acc_risk fin

10773: l_stmt := 'select count(1) from (
10774: select distinct fin.risk_id ,fin.organization_id, fin.Process_ID
10775: FROM
10776: AMW_OPINION_M_V aov,
10777: amw_fin_item_acc_risk fin
10778: WHERE
10779: aov.OPINION_TYPE_CODE = ''EVALUATION''
10780: and aov.object_name = ''AMW_ORG_PROCESS_RISK''
10781: and aov.opinion_component_code = ''OVERALL''

Line 10796: amw_fin_item_acc_risk fin

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''
10800: and aov.opinion_component_code = ''OVERALL''