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.FII_AR_FACTS_AGING_PKG dependencies on FND_STATS

Line 609: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_CURR_RATES_T');

605: ------------------------
606: */
607:
608: g_state := 'Analyzing FII_AR_CURR_RATES_T table';
609: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_CURR_RATES_T');
610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: g_errbuf:=sqlerrm;

Line 1090: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');

1086: FII_UTIL.put_line('');
1087: end if;
1088:
1089: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';
1090: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');
1091:
1092: g_state := 'Logging maximum payment schedule id into fii_change_log table';
1093: select nvl(max(payment_schedule_id), -999)
1094: into l_max_pmt_schedule_id

Line 1226: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_DISPUTE_HISTORY_F');

1222: FII_UTIL.put_line('');
1223: end if;
1224:
1225: g_state := 'Analyzing FII_AR_DISPUTE_HISTORY_F table';
1226: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_DISPUTE_HISTORY_F');
1227:
1228: EXCEPTION
1229: WHEN OTHERS THEN
1230: g_errbuf:=sqlerrm;

Line 1412: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');

1408: FII_UTIL.put_line('');
1409: end if;
1410:
1411: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';
1412: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');
1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: g_errbuf:=sqlerrm;

Line 1543: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_ADJUSTMENTS_F');

1539: FII_UTIL.put_line('');
1540: end if;
1541:
1542: g_state := 'Analyzing FII_AR_ADJUSTMENTS_F table';
1543: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_ADJUSTMENTS_F');
1544:
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: g_errbuf:=sqlerrm;

Line 1868: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_RECEIPTS_F');

1864: FII_UTIL.put_line('');
1865: end if;
1866:
1867: g_state := 'Analyzing FII_AR_RECEIPTS_F table';
1868: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_RECEIPTS_F');
1869:
1870: g_state := 'Logging maximum receivable_application_id into fii_change_log table';
1871: select nvl(max(receivable_application_id), -999)
1872: into l_max_rec_application_id

Line 2022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_SCHEDULED_DISC_F');

2018: FII_UTIL.put_line('');
2019: end if;
2020:
2021: g_state := 'Analyzing FII_AR_SCHEDULED_DISC_F table';
2022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_SCHEDULED_DISC_F');
2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: g_errbuf:=sqlerrm;

Line 3275: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_AGING_RECEIVABLES');

3271: FII_UTIL.put_line('');
3272: end if;
3273:
3274: g_state := 'Analyzing FII_AR_AGING_RECEIVABLES table';
3275: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_AGING_RECEIVABLES');
3276:
3277: EXCEPTION
3278: WHEN OTHERS THEN
3279: g_errbuf:=sqlerrm;

Line 3624: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_AGING_RECEIPTS');

3620: FII_UTIL.put_line('');
3621: end if;
3622:
3623: g_state := 'Analyzing FII_AR_AGING_RECEIPTS table';
3624: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_AGING_RECEIPTS');
3625:
3626: EXCEPTION
3627: WHEN OTHERS THEN
3628: g_errbuf:=sqlerrm;

Line 3914: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_AGING_DISPUTES');

3910: FII_UTIL.put_line('');
3911: end if;
3912:
3913: g_state := 'Analyzing FII_AR_AGING_DISPUTES table';
3914: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_AGING_DISPUTES');
3915:
3916: EXCEPTION
3917: WHEN OTHERS THEN
3918: g_errbuf:=sqlerrm;

Line 4022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_MKT_CLASSES');

4018: FII_UTIL.put_line('');
4019: end if;
4020:
4021: g_state := 'Analyzing FII_AR_HELP_MKT_CLASSES table';
4022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_MKT_CLASSES');
4023: g_state := 'Analyzing FII_AR_HELP_COLLECTORS table';
4024: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_COLLECTORS');
4025:
4026: commit;

Line 4024: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_COLLECTORS');

4020:
4021: g_state := 'Analyzing FII_AR_HELP_MKT_CLASSES table';
4022: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_MKT_CLASSES');
4023: g_state := 'Analyzing FII_AR_HELP_COLLECTORS table';
4024: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_HELP_COLLECTORS');
4025:
4026: commit;
4027:
4028: EXCEPTION

Line 4865: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_CURR_RATES_T');

4861: ------------------------
4862: */
4863:
4864: g_state := 'Analyzing FII_AR_CURR_RATES_T table';
4865: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_CURR_RATES_T');
4866:
4867: EXCEPTION
4868: WHEN OTHERS THEN
4869: g_errbuf:=sqlerrm;

Line 5234: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');

5230: FII_UTIL.put_line('');
5231: end if;
5232:
5233: g_state := 'Analyzing FII_AR_PMT_SCHEDULES_F table';
5234: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_PMT_SCHEDULES_F');
5235:
5236: g_state := 'Logging maximum payment schedule id into fii_change_log table';
5237: select nvl(max(payment_schedule_id), -999)
5238: into l_max_pmt_schedule_id

Line 5462: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_DISPUTE_HISTORY_F');

5458: FII_UTIL.put_line('');
5459: end if;
5460:
5461: g_state := 'Analyzing FII_AR_DISPUTE_HISTORY_F table';
5462: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_DISPUTE_HISTORY_F');
5463:
5464: EXCEPTION
5465: WHEN OTHERS THEN
5466: g_errbuf:=sqlerrm;

Line 5827: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');

5823: FII_UTIL.put_line('');
5824: end if;
5825:
5826: g_state := 'Analyzing FII_AR_TRANSACTIONS_F table';
5827: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_TRANSACTIONS_F');
5828:
5829: EXCEPTION
5830: WHEN OTHERS THEN
5831: g_errbuf:=sqlerrm;

Line 6050: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_ADJUSTMENTS_F');

6046: FII_UTIL.put_line('');
6047: end if;
6048:
6049: g_state := 'Analyzing FII_AR_ADJUSTMENTS_F table';
6050: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_ADJUSTMENTS_F');
6051:
6052: EXCEPTION
6053: WHEN OTHERS THEN
6054: g_errbuf:=sqlerrm;

Line 6667: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_RECEIPTS_F');

6663: FII_UTIL.put_line('');
6664: end if;
6665:
6666: g_state := 'Analyzing FII_AR_RECEIPTS_F table';
6667: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'FII_AR_RECEIPTS_F');
6668:
6669: g_state := 'Logging maximum receivable_application_id into fii_change_log table';
6670: select nvl(max(receivable_application_id), -999)
6671: into l_max_rec_application_id

Line 7943: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'fii_ar_aging_receivables');

7939: FII_UTIL.put_line('');
7940: end if;
7941:
7942: g_state := 'Analyzing fii_ar_aging_receivables table';
7943: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'fii_ar_aging_receivables');
7944:
7945: EXCEPTION
7946: WHEN OTHERS THEN
7947: g_errbuf:=sqlerrm;

Line 8382: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'fii_ar_aging_receipts');

8378: FII_UTIL.put_line('');
8379: end if;
8380:
8381: g_state := 'Analyzing fii_ar_aging_receipts table';
8382: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'fii_ar_aging_receipts');
8383:
8384: EXCEPTION
8385: WHEN OTHERS THEN
8386: g_errbuf:=sqlerrm;

Line 8686: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'fii_ar_aging_disputes');

8682: FII_UTIL.put_line('');
8683: end if;
8684:
8685: g_state := 'Analyzing fii_ar_aging_disputes table';
8686: FND_STATS.GATHER_TABLE_STATS(g_fii_schema,'fii_ar_aging_disputes');
8687:
8688: EXCEPTION
8689: WHEN OTHERS THEN
8690: g_errbuf:=sqlerrm;