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

Line 1559: -- This procedure inserts records in FII_AR_RECEIPTS_F

1555:
1556: ------------------------------------------------------------------
1557: -- Procedure POPULATE_RECEIPTS
1558: -- Purpose
1559: -- This procedure inserts records in FII_AR_RECEIPTS_F
1560: ------------------------------------------------------------------
1561: PROCEDURE POPULATE_RECEIPTS IS
1562:
1563: l_max_rec_application_id NUMBER(15);

Line 1567: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';

1563: l_max_rec_application_id NUMBER(15);
1564:
1565: BEGIN
1566:
1567: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
1568: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
1569: g_state := 'Truncating table FII_AR_RECEIPTS_F';
1570: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
1571:

Line 1568: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');

1564:
1565: BEGIN
1566:
1567: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
1568: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
1569: g_state := 'Truncating table FII_AR_RECEIPTS_F';
1570: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
1571:
1572: g_state := 'Populating FII_AR_RECEIPTS_F';

Line 1569: g_state := 'Truncating table FII_AR_RECEIPTS_F';

1565: BEGIN
1566:
1567: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
1568: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
1569: g_state := 'Truncating table FII_AR_RECEIPTS_F';
1570: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
1571:
1572: g_state := 'Populating FII_AR_RECEIPTS_F';
1573: if g_debug_flag = 'Y' then

Line 1570: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');

1566:
1567: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
1568: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
1569: g_state := 'Truncating table FII_AR_RECEIPTS_F';
1570: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
1571:
1572: g_state := 'Populating FII_AR_RECEIPTS_F';
1573: if g_debug_flag = 'Y' then
1574: FII_UTIL.put_line(g_state);

Line 1572: g_state := 'Populating FII_AR_RECEIPTS_F';

1568: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
1569: g_state := 'Truncating table FII_AR_RECEIPTS_F';
1570: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
1571:
1572: g_state := 'Populating FII_AR_RECEIPTS_F';
1573: if g_debug_flag = 'Y' then
1574: FII_UTIL.put_line(g_state);
1575: FII_UTIL.start_timer;
1576: FII_UTIL.put_line('');

Line 1579: INSERT /+ append parallel(F) / INTO FII_AR_RECEIPTS_F F

1575: FII_UTIL.start_timer;
1576: FII_UTIL.put_line('');
1577: end if;
1578:
1579: INSERT /*+ append parallel(F) */ INTO FII_AR_RECEIPTS_F F
1580: (receivable_application_id,
1581: time_id,
1582: cash_receipt_id,
1583: application_status,

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

1857: then 1
1858: else trxsch.payment_schedule_id end) is not null;
1859:
1860: if g_debug_flag = 'Y' then
1861: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_RECEIPTS_F');
1862: FII_UTIL.stop_timer;
1863: FII_UTIL.print_timer('Duration');
1864: FII_UTIL.put_line('');
1865: end if;

Line 1867: g_state := 'Analyzing FII_AR_RECEIPTS_F table';

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

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 1873: from 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
1873: from fii_ar_receipts_f;
1874:
1875: INSERT INTO fii_change_log
1876: (log_item, item_value, CREATION_DATE, CREATED_BY,
1877: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

Line 3105: from fii_ar_receipts_f rct,

3101: then 'Y'
3102: else 'N' end unapplied_deposit_flag,
3103: 'Application' action,
3104: sch.actual_date_closed
3105: from fii_ar_receipts_f rct,
3106: fii_ar_pmt_schedules_f sch
3107: where rct.application_status = 'APP'
3108: and sch.class <> 'PMT'
3109: and rct.applied_payment_schedule_id = sch.payment_schedule_id

Line 3569: from fii_ar_receipts_f rct

3565: rct.receivable_application_id,
3566: rct.amount_applied_rct_func bucket_amount_func,
3567: rct.amount_applied_rct_prim bucket_amount_prim,
3568: rct.amount_applied_rct_sec bucket_amount_sec
3569: from fii_ar_receipts_f rct
3570: where rct.application_status in ('UNAPP','UNID')
3571: and rct.header_status not in ('REV', 'NSF', 'STOP')
3572: --and nvl(rct.applied_payment_schedule_id,-999) <> -1 --exclude on-account receipts
3573: --and nvl(rct.applied_payment_schedule_id,-999) <> -4 --exclude claims

Line 4631: from fii_ar_receipts_f

4627: payment_schedule_id,
4628: CASH_RECEIPT_ID
4629: )
4630: select RECEIVABLE_APPLICATION_ID, PAYMENT_SCHEDULE_ID, CASH_RECEIPT_ID
4631: from fii_ar_receipts_f
4632: where CASH_RECEIPT_ID in (
4633: select CASH_RECEIPT_ID from FII_AR_RECEIPTS_DELETE_T
4634: where CREATION_DATE <= g_sysdate_time
4635: )

Line 6066: -- This procedure manipulates records in FII_AR_RECEIPTS_F

6062:
6063: ------------------------------------------------------------------
6064: -- Procedure Inc_RECEIPTS
6065: -- Purpose
6066: -- This procedure manipulates records in FII_AR_RECEIPTS_F
6067: ------------------------------------------------------------------
6068: PROCEDURE Inc_RECEIPTS IS
6069:
6070: l_max_rec_application_id NUMBER(15);

Line 6075: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';

6071:
6072: BEGIN
6073:
6074: /*
6075: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
6076: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
6077: g_state := 'Truncating table FII_AR_RECEIPTS_F';
6078: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
6079: */

Line 6076: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');

6072: BEGIN
6073:
6074: /*
6075: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
6076: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
6077: g_state := 'Truncating table FII_AR_RECEIPTS_F';
6078: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
6079: */
6080:

Line 6077: g_state := 'Truncating table FII_AR_RECEIPTS_F';

6073:
6074: /*
6075: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
6076: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
6077: g_state := 'Truncating table FII_AR_RECEIPTS_F';
6078: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
6079: */
6080:
6081: g_state := 'Populating FII_AR_RECAPP_MERGE_GT';

Line 6078: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');

6074: /*
6075: g_state := 'Truncating table MLOG$_FII_AR_RECEIPTS_F';
6076: TRUNCATE_TABLE('MLOG$_FII_AR_RECEIPTS_F');
6077: g_state := 'Truncating table FII_AR_RECEIPTS_F';
6078: TRUNCATE_TABLE('FII_AR_RECEIPTS_F');
6079: */
6080:
6081: g_state := 'Populating FII_AR_RECAPP_MERGE_GT';
6082: if g_debug_flag = 'Y' then

Line 6388: g_state := 'Deleting FII_AR_RECEIPTS_F';

6384: FII_UTIL.print_timer('Duration');
6385: FII_UTIL.put_line('');
6386: end if;
6387:
6388: g_state := 'Deleting FII_AR_RECEIPTS_F';
6389: if g_debug_flag = 'Y' then
6390: FII_UTIL.put_line(g_state);
6391: FII_UTIL.start_timer;
6392: FII_UTIL.put_line('');

Line 6395: delete from fii_ar_receipts_f

6391: FII_UTIL.start_timer;
6392: FII_UTIL.put_line('');
6393: end if;
6394:
6395: delete from fii_ar_receipts_f
6396: where RECEIVABLE_APPLICATION_ID in (
6397: select RECEIVABLE_APPLICATION_ID
6398: from FII_AR_RECAPP_MERGE_GT
6399: where (case when applied_payment_schedule_id is null

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

6410: from FII_AR_RECAPP_DELETE_GT
6411: );
6412:
6413: if g_debug_flag = 'Y' then
6414: FII_UTIL.put_line('Deleted ' ||SQL%ROWCOUNT|| ' records from FII_AR_RECEIPTS_F');
6415: FII_UTIL.stop_timer;
6416: FII_UTIL.print_timer('Duration');
6417: FII_UTIL.put_line('');
6418: end if;

Line 6422: g_state := 'Merging into FII_AR_RECEIPTS_F';

6418: end if;
6419:
6420: commit;
6421:
6422: g_state := 'Merging into FII_AR_RECEIPTS_F';
6423: if g_debug_flag = 'Y' then
6424: FII_UTIL.put_line(g_state);
6425: FII_UTIL.start_timer;
6426: FII_UTIL.put_line('');

Line 6429: merge into fii_ar_receipts_f old using (

6425: FII_UTIL.start_timer;
6426: FII_UTIL.put_line('');
6427: end if;
6428:
6429: merge into fii_ar_receipts_f old using (
6430: select
6431: RECEIVABLE_APPLICATION_ID,
6432: TIME_ID,
6433: CASH_RECEIPT_ID,

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

6656: dlt.LAST_UPDATE_LOGIN
6657: );
6658:
6659: if g_debug_flag = 'Y' then
6660: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_RECEIPTS_F');
6661: FII_UTIL.stop_timer;
6662: FII_UTIL.print_timer('Duration');
6663: FII_UTIL.put_line('');
6664: end if;

Line 6666: g_state := 'Analyzing FII_AR_RECEIPTS_F table';

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

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 6672: from 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
6672: from fii_ar_receipts_f;
6673:
6674: INSERT INTO fii_change_log
6675: (log_item, item_value, CREATION_DATE, CREATED_BY,
6676: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

Line 7756: from fii_ar_receipts_f rct,

7752: then 'Y'
7753: else 'N' end unapplied_deposit_flag,
7754: 'Application' action,
7755: sch.actual_date_closed
7756: from fii_ar_receipts_f rct,
7757: fii_ar_pmt_schedules_f sch,
7758: FII_AR_PAYSCH_MERGE_GT gt
7759: where rct.application_status = 'APP'
7760: and sch.class <> 'PMT'

Line 8823: from fii_ar_receipts_f rct,

8819: union all
8820:
8821: --Cases 2
8822: select distinct ag.cash_receipt_id, to_number(to_char(rct.rct_actual_date_closed, 'J')) actual_date_closed
8823: from fii_ar_receipts_f rct,
8824: fii_ar_aging_receipts ag
8825: where rct.cash_receipt_id = ag.cash_receipt_id
8826: and rct.receivable_application_id <= G_MAX_RECEIVABLE_APPL_ID
8827: and to_number(to_char(rct.rct_actual_date_closed, 'J')) < ag.time_id

Line 8833: from fii_ar_receipts_f rct,

8829: union all
8830:
8831: --Case 3
8832: select ag.cash_receipt_id, 1 actual_date_closed
8833: from fii_ar_receipts_f rct,
8834: fii_ar_aging_receipts ag
8835: where rct.cash_receipt_id = ag.cash_receipt_id
8836: and rct.receivable_application_id <= G_MAX_RECEIVABLE_APPL_ID
8837: and rct.header_status in ('REV','NSF','STOP') );

Line 9025: g_state := 'Populating FII_AR_INC_RCT_AGING_T from fii_ar_receipts_f';

9021: PROCEDURE POPULATE_INCREMENTAL_RCT_IDS IS
9022:
9023: BEGIN
9024:
9025: g_state := 'Populating FII_AR_INC_RCT_AGING_T from fii_ar_receipts_f';
9026: if g_debug_flag = 'Y' then
9027: FII_UTIL.put_line(g_state);
9028: end if;
9029:

Line 9145: from fii_ar_receipts_f rct,

9141: created_by,
9142: last_update_date,
9143: last_updated_by,
9144: last_update_login
9145: from fii_ar_receipts_f rct,
9146: (select distinct ag.cash_receipt_id
9147: from fii_ar_aging_receipts ag
9148: where ag.next_aging_date > G_LAST_UPDATE_DATE --'15-APR-2005'
9149: and ag.next_aging_date <= g_sysdate --'20-MAY-2005'