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 FII_AR_DISP_UPDATE_GT

Line 4389: g_state := 'Populating FII_AR_DISP_UPDATE_GT';

4385: FII_UTIL.print_timer('Duration');
4386: FII_UTIL.put_line('');
4387: end if;
4388:
4389: g_state := 'Populating FII_AR_DISP_UPDATE_GT';
4390: if g_debug_flag = 'Y' then
4391: FII_UTIL.put_line(g_state);
4392: FII_UTIL.start_timer;
4393: FII_UTIL.put_line('');

Line 4397: insert into FII_AR_DISP_UPDATE_GT

4393: FII_UTIL.put_line('');
4394: end if;
4395:
4396: -- PaySch Update 1
4397: insert into FII_AR_DISP_UPDATE_GT
4398: (
4399: payment_schedule_id,
4400: dispute_history_id,
4401: dispute_amount,

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

4420: )
4421: ;
4422:
4423: if g_debug_flag = 'Y' then
4424: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_DISP_UPDATE_GT');
4425: FII_UTIL.stop_timer;
4426: FII_UTIL.print_timer('Duration');
4427: FII_UTIL.put_line('');
4428: end if;

Line 4713: from FII_AR_DISP_UPDATE_GT

4709: from FII_AR_PAYSCH_INSERT_GT
4710: union all
4711: -- PaySch Update 1
4712: select PAYMENT_SCHEDULE_ID
4713: from FII_AR_DISP_UPDATE_GT
4714: union all
4715: -- PaySch Update 2
4716: select PAYMENT_SCHEDULE_ID
4717: from FII_AR_ADJ_UPDATE_GT

Line 5351: select * from FII_AR_DISP_UPDATE_GT

5347: sysdate LAST_UPDATE_DATE,
5348: g_fii_user_id LAST_UPDATED_BY,
5349: g_fii_login_id LAST_UPDATE_LOGIN
5350: FROM /* (
5351: select * from FII_AR_DISP_UPDATE_GT
5352: -- where start_date >= g_global_start_date
5353: -- and last_update_date <= g_sysdate_time
5354: ) */
5355: FII_AR_DISP_UPDATE_GT dis,

Line 5355: FII_AR_DISP_UPDATE_GT dis,

5351: select * from FII_AR_DISP_UPDATE_GT
5352: -- where start_date >= g_global_start_date
5353: -- and last_update_date <= g_sysdate_time
5354: ) */
5355: FII_AR_DISP_UPDATE_GT dis,
5356: -- FII_AR_PMT_SCHEDULES_F sch, --> FII_AR_PAYSCH_MERGE_GT
5357: ( select
5358: actual_date_closed,
5359: sch.customer_id bill_to_customer_id,

Line 8577: from fii_ar_disp_update_gt dis_gt,

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
8580: where dis.customer_trx_id = gt.customer_trx_id
8581: group by dis.time_id,

Line 8621: from fii_ar_disp_update_gt dis_gt,

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
8624: where dis.customer_trx_id = gt.customer_trx_id
8625: group by dis.bill_to_customer_id,

Line 8916: from fii_ar_disp_update_gt gt,

8912: union all
8913:
8914: --Case 4
8915: select null payment_schedule_id, ag.customer_trx_id, gt.end_date min_date
8916: from fii_ar_disp_update_gt gt,
8917: fii_ar_aging_disputes ag
8918: where ag.payment_schedule_id = gt.payment_schedule_id
8919: and ag.event_date >= gt.end_date
8920: );

Line 9195: g_state := 'Populating FII_AR_DISP_UPDATE_GT from fii_ar_aging_disputes';

9191: PROCEDURE POPULATE_INCREMENTAL_DISP_IDS IS
9192:
9193: BEGIN
9194:
9195: g_state := 'Populating FII_AR_DISP_UPDATE_GT from fii_ar_aging_disputes';
9196: if g_debug_flag = 'Y' then
9197: FII_UTIL.put_line(g_state);
9198: end if;
9199:

Line 9200: --FII_AR_DISP_UPDATE_GT already contains:

9196: if g_debug_flag = 'Y' then
9197: FII_UTIL.put_line(g_state);
9198: end if;
9199:
9200: --FII_AR_DISP_UPDATE_GT already contains:
9201: --sch_ids of new and updated disputes
9202:
9203: --Insert sch ids that are already in aging table but not yet aged completely
9204: INSERT INTO FII_AR_DISP_UPDATE_GT

Line 9204: INSERT INTO FII_AR_DISP_UPDATE_GT

9200: --FII_AR_DISP_UPDATE_GT already contains:
9201: --sch_ids of new and updated disputes
9202:
9203: --Insert sch ids that are already in aging table but not yet aged completely
9204: INSERT INTO FII_AR_DISP_UPDATE_GT
9205: (payment_schedule_id)
9206: (select distinct ag.payment_schedule_id
9207: from fii_ar_aging_disputes ag
9208: where ag.next_aging_date > G_LAST_UPDATE_DATE --'15-APR-2005'

Line 9212: from FII_AR_DISP_UPDATE_GT t

9208: where ag.next_aging_date > G_LAST_UPDATE_DATE --'15-APR-2005'
9209: and ag.next_aging_date <= g_sysdate --'20-MAY-2005'
9210: and not exists
9211: (select 1
9212: from FII_AR_DISP_UPDATE_GT t
9213: where t.payment_schedule_id = ag.payment_schedule_id));
9214:
9215: if g_debug_flag = 'Y' then
9216: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' additional records into FII_AR_DISP_UPDATE_GT.');

Line 9216: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' additional records into FII_AR_DISP_UPDATE_GT.');

9212: from FII_AR_DISP_UPDATE_GT t
9213: where t.payment_schedule_id = ag.payment_schedule_id));
9214:
9215: if g_debug_flag = 'Y' then
9216: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' additional records into FII_AR_DISP_UPDATE_GT.');
9217: FII_UTIL.stop_timer;
9218: FII_UTIL.print_timer('Duration');
9219: FII_UTIL.put_line('');
9220: end if;