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 AR_DISPUTE_HISTORY

Line 1136: -- This procedure inserts records in FII_AR_DISPUTE_HISTORY_F

1132:
1133: ------------------------------------------------------------------
1134: -- Procedure POPULATE_DISPUTES
1135: -- Purpose
1136: -- This procedure inserts records in FII_AR_DISPUTE_HISTORY_F
1137: ------------------------------------------------------------------
1138: PROCEDURE POPULATE_DISPUTES IS
1139: BEGIN
1140:

Line 1141: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';

1137: ------------------------------------------------------------------
1138: PROCEDURE POPULATE_DISPUTES IS
1139: BEGIN
1140:
1141: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';
1142: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');
1143:
1144: g_state := 'Populating FII_AR_DISPUTE_HISTORY_F';
1145: if g_debug_flag = 'Y' then

Line 1142: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');

1138: PROCEDURE POPULATE_DISPUTES IS
1139: BEGIN
1140:
1141: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';
1142: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');
1143:
1144: g_state := 'Populating FII_AR_DISPUTE_HISTORY_F';
1145: if g_debug_flag = 'Y' then
1146: FII_UTIL.put_line(g_state);

Line 1144: g_state := 'Populating FII_AR_DISPUTE_HISTORY_F';

1140:
1141: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';
1142: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');
1143:
1144: g_state := 'Populating FII_AR_DISPUTE_HISTORY_F';
1145: if g_debug_flag = 'Y' then
1146: FII_UTIL.put_line(g_state);
1147: FII_UTIL.start_timer;
1148: FII_UTIL.put_line('');

Line 1151: INSERT INTO FII_AR_DISPUTE_HISTORY_F

1147: FII_UTIL.start_timer;
1148: FII_UTIL.put_line('');
1149: end if;
1150:
1151: INSERT INTO FII_AR_DISPUTE_HISTORY_F
1152: (dispute_history_id,
1153: time_id,
1154: dispute_amount_trx,
1155: dispute_amount_func,

Line 1202: FROM AR_DISPUTE_HISTORY dis,

1198: g_fii_user_id, --CREATED_BY,
1199: sysdate, --LAST_UPDATE_DATE,
1200: g_fii_user_id, --LAST_UPDATED_BY,
1201: g_fii_login_id --LAST_UPDATE_LOGIN
1202: FROM AR_DISPUTE_HISTORY dis,
1203: FII_AR_PMT_SCHEDULES_F sch,
1204: FII_AR_CURR_RATES_T rt,
1205: AR_SYSTEM_PARAMETERS_ALL par,
1206: GL_SETS_OF_BOOKS sob

Line 1219: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_DISPUTE_HISTORY_F');

1215: AND sob.currency_code = rt.fc_code
1216: AND trunc(least(nvl(sch.exchange_date,sch.trx_date),sysdate)) = rt.conversion_date;
1217:
1218: if g_debug_flag = 'Y' then
1219: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_DISPUTE_HISTORY_F');
1220: FII_UTIL.stop_timer;
1221: FII_UTIL.print_timer('Duration');
1222: FII_UTIL.put_line('');
1223: end if;

Line 1225: g_state := 'Analyzing FII_AR_DISPUTE_HISTORY_F table';

1221: FII_UTIL.print_timer('Duration');
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

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 3819: from fii_ar_dispute_history_f dis

3815: dis.actual_date_closed,
3816: sum(dis.dispute_amount_func) bucket_amount_func,
3817: sum(dis.dispute_amount_prim) bucket_amount_prim,
3818: sum(dis.dispute_amount_sec) bucket_amount_sec
3819: from fii_ar_dispute_history_f dis
3820: group by dis.time_id,
3821: dis.start_date,
3822: dis.bill_to_customer_id,
3823: dis.bill_to_site_use_id,

Line 3858: from fii_ar_dispute_history_f dis

3854: dis.actual_date_closed,
3855: sum(dis.dispute_amount_func) bucket_amount_func,
3856: sum(dis.dispute_amount_prim) bucket_amount_prim,
3857: sum(dis.dispute_amount_sec) bucket_amount_sec
3858: from fii_ar_dispute_history_f dis
3859: group by dis.bill_to_customer_id,
3860: dis.bill_to_site_use_id,
3861: dis.org_id,
3862: dis.customer_trx_id,

Line 4412: from ar_dispute_history

4408: , dispute_amount
4409: , start_date
4410: , end_date
4411: , last_update_date
4412: from ar_dispute_history
4413: -- Update end_date, but not LAST_UPDATE_DATE
4414: where PAYMENT_SCHEDULE_ID in (
4415: select PAYMENT_SCHEDULE_ID
4416: from ar_dispute_history

Line 4416: from ar_dispute_history

4412: from ar_dispute_history
4413: -- Update end_date, but not LAST_UPDATE_DATE
4414: where PAYMENT_SCHEDULE_ID in (
4415: select PAYMENT_SCHEDULE_ID
4416: from ar_dispute_history
4417: where LAST_UPDATE_DATE > G_LAST_UPDATE_DATE
4418: and start_date >= g_global_start_date
4419: and LAST_UPDATE_DATE <= g_sysdate_time
4420: )

Line 5279: -- This procedure manipulates records in FII_AR_DISPUTE_HISTORY_F

5275:
5276: ------------------------------------------------------------------
5277: -- Procedure Inc_DISPUTES
5278: -- Purpose
5279: -- This procedure manipulates records in FII_AR_DISPUTE_HISTORY_F
5280: ------------------------------------------------------------------
5281: PROCEDURE Inc_DISPUTES IS
5282: BEGIN
5283:

Line 5285: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';

5281: PROCEDURE Inc_DISPUTES IS
5282: BEGIN
5283:
5284: /*
5285: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';
5286: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');
5287: */
5288:
5289: g_state := 'Deleting FII_AR_DISPUTE_HISTORY_F';

Line 5286: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');

5282: BEGIN
5283:
5284: /*
5285: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';
5286: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');
5287: */
5288:
5289: g_state := 'Deleting FII_AR_DISPUTE_HISTORY_F';
5290: if g_debug_flag = 'Y' then

Line 5289: g_state := 'Deleting FII_AR_DISPUTE_HISTORY_F';

5285: g_state := 'Truncating table FII_AR_DISPUTE_HISTORY_F';
5286: TRUNCATE_TABLE('FII_AR_DISPUTE_HISTORY_F');
5287: */
5288:
5289: g_state := 'Deleting FII_AR_DISPUTE_HISTORY_F';
5290: if g_debug_flag = 'Y' then
5291: FII_UTIL.put_line(g_state);
5292: FII_UTIL.start_timer;
5293: FII_UTIL.put_line('');

Line 5296: delete from fii_ar_dispute_history_f

5292: FII_UTIL.start_timer;
5293: FII_UTIL.put_line('');
5294: end if;
5295:
5296: delete from fii_ar_dispute_history_f
5297: where PAYMENT_SCHEDULE_ID in (
5298: -- PaySch Delete 1 2 3
5299: select PAYMENT_SCHEDULE_ID
5300: from FII_AR_PAYSCH_DELETE_GT

Line 5304: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_DISPUTE_HISTORY_F');

5300: from FII_AR_PAYSCH_DELETE_GT
5301: );
5302:
5303: if g_debug_flag = 'Y' then
5304: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_DISPUTE_HISTORY_F');
5305: FII_UTIL.stop_timer;
5306: FII_UTIL.print_timer('Duration');
5307: FII_UTIL.put_line('');
5308: end if;

Line 5312: g_state := 'Merging into FII_AR_DISPUTE_HISTORY_F';

5308: end if;
5309:
5310: commit;
5311:
5312: g_state := 'Merging into FII_AR_DISPUTE_HISTORY_F';
5313: if g_debug_flag = 'Y' then
5314: FII_UTIL.put_line(g_state);
5315: FII_UTIL.start_timer;
5316: FII_UTIL.put_line('');

Line 5319: merge into fii_ar_dispute_history_f old using (

5315: FII_UTIL.start_timer;
5316: FII_UTIL.put_line('');
5317: end if;
5318:
5319: merge into fii_ar_dispute_history_f old using (
5320: -- POPULATE_DISPUTES
5321: SELECT dis.dispute_history_id,
5322: to_number(to_char(dis.start_date, 'J')) time_id,
5323: dis.dispute_amount dispute_amount_trx,

Line 5455: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_DISPUTE_HISTORY_F');

5451: dlt.LAST_UPDATE_LOGIN
5452: );
5453:
5454: if g_debug_flag = 'Y' then
5455: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_DISPUTE_HISTORY_F');
5456: FII_UTIL.stop_timer;
5457: FII_UTIL.print_timer('Duration');
5458: FII_UTIL.put_line('');
5459: end if;

Line 5461: g_state := 'Analyzing FII_AR_DISPUTE_HISTORY_F table';

5457: FII_UTIL.print_timer('Duration');
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

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 8575: from fii_ar_dispute_history_f dis,

8571: dis.actual_date_closed,
8572: sum(dis.dispute_amount_func) bucket_amount_func,
8573: sum(dis.dispute_amount_prim) bucket_amount_prim,
8574: sum(dis.dispute_amount_sec) bucket_amount_sec
8575: from fii_ar_dispute_history_f dis,
8576: (select distinct customer_trx_id
8577: from fii_ar_disp_update_gt dis_gt,
8578: fii_ar_dispute_history_f f
8579: where dis_gt.payment_schedule_id = f.payment_schedule_id) gt

Line 8578: fii_ar_dispute_history_f f

8574: sum(dis.dispute_amount_sec) bucket_amount_sec
8575: from fii_ar_dispute_history_f dis,
8576: (select distinct customer_trx_id
8577: from fii_ar_disp_update_gt dis_gt,
8578: fii_ar_dispute_history_f f
8579: where dis_gt.payment_schedule_id = f.payment_schedule_id) gt
8580: where dis.customer_trx_id = gt.customer_trx_id
8581: group by dis.time_id,
8582: dis.start_date,

Line 8619: from fii_ar_dispute_history_f dis,

8615: dis.actual_date_closed,
8616: sum(dis.dispute_amount_func) bucket_amount_func,
8617: sum(dis.dispute_amount_prim) bucket_amount_prim,
8618: sum(dis.dispute_amount_sec) bucket_amount_sec
8619: from fii_ar_dispute_history_f dis,
8620: (select distinct customer_trx_id
8621: from fii_ar_disp_update_gt dis_gt,
8622: fii_ar_dispute_history_f f
8623: where dis_gt.payment_schedule_id = f.payment_schedule_id) gt

Line 8622: fii_ar_dispute_history_f f

8618: sum(dis.dispute_amount_sec) bucket_amount_sec
8619: from fii_ar_dispute_history_f dis,
8620: (select distinct customer_trx_id
8621: from fii_ar_disp_update_gt dis_gt,
8622: fii_ar_dispute_history_f f
8623: where dis_gt.payment_schedule_id = f.payment_schedule_id) gt
8624: where dis.customer_trx_id = gt.customer_trx_id
8625: group by dis.bill_to_customer_id,
8626: dis.bill_to_site_use_id,