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_ADJUSTMENTS_F

Line 1429: -- This procedure inserts records in FII_AR_ADJUSTMENTS_F

1425:
1426: ------------------------------------------------------------------
1427: -- Procedure POPULATE_ADJUSTMENTS
1428: -- Purpose
1429: -- This procedure inserts records in FII_AR_ADJUSTMENTS_F
1430: ------------------------------------------------------------------
1431: PROCEDURE POPULATE_ADJUSTMENTS IS
1432: BEGIN
1433:

Line 1434: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';

1430: ------------------------------------------------------------------
1431: PROCEDURE POPULATE_ADJUSTMENTS IS
1432: BEGIN
1433:
1434: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';
1435: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');
1436:
1437: g_state := 'Populating FII_AR_ADJUSTMENTS_F';
1438: if g_debug_flag = 'Y' then

Line 1435: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');

1431: PROCEDURE POPULATE_ADJUSTMENTS IS
1432: BEGIN
1433:
1434: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';
1435: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');
1436:
1437: g_state := 'Populating FII_AR_ADJUSTMENTS_F';
1438: if g_debug_flag = 'Y' then
1439: FII_UTIL.put_line(g_state);

Line 1437: g_state := 'Populating FII_AR_ADJUSTMENTS_F';

1433:
1434: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';
1435: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');
1436:
1437: g_state := 'Populating FII_AR_ADJUSTMENTS_F';
1438: if g_debug_flag = 'Y' then
1439: FII_UTIL.put_line(g_state);
1440: FII_UTIL.start_timer;
1441: FII_UTIL.put_line('');

Line 1444: INSERT /+ append / INTO FII_AR_ADJUSTMENTS_F

1440: FII_UTIL.start_timer;
1441: FII_UTIL.put_line('');
1442: end if;
1443:
1444: INSERT /*+ append */ INTO FII_AR_ADJUSTMENTS_F
1445: (adjustment_id,
1446: time_id ,
1447: bill_to_customer_id,
1448: bill_to_site_use_id,

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

1532: AND par.set_of_books_id = sob.set_of_books_id
1533: AND sob.currency_code = rt.fc_code
1534: AND trunc(least(nvl(trx.exchange_date,trx.trx_date),sysdate)) = rt.conversion_date;
1535: if g_debug_flag = 'Y' then
1536: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_ADJUSTMENTS_F');
1537: FII_UTIL.stop_timer;
1538: FII_UTIL.print_timer('Duration');
1539: FII_UTIL.put_line('');
1540: end if;

Line 1542: g_state := 'Analyzing FII_AR_ADJUSTMENTS_F table';

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

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 3150: from fii_ar_adjustments_f adj,

3146: null on_account_credit_flag,
3147: decode(adj.adj_class,'DEP','Y','N') unapplied_deposit_flag,
3148: 'Adjustment' action,
3149: sch.actual_date_closed
3150: from fii_ar_adjustments_f adj,
3151: fii_ar_pmt_schedules_f sch,
3152: fii_ar_dso_setup schdso,
3153: fii_ar_dso_setup adjdso
3154: where adj.payment_schedule_id = sch.payment_schedule_id

Line 5844: -- This procedure manipulates records in FII_AR_ADJUSTMENTS_F

5840:
5841: ------------------------------------------------------------------
5842: -- Procedure Inc_ADJUSTMENTS
5843: -- Purpose
5844: -- This procedure manipulates records in FII_AR_ADJUSTMENTS_F
5845: ------------------------------------------------------------------
5846: PROCEDURE Inc_ADJUSTMENTS IS
5847: BEGIN
5848:

Line 5850: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';

5846: PROCEDURE Inc_ADJUSTMENTS IS
5847: BEGIN
5848:
5849: /*
5850: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';
5851: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');
5852: */
5853:
5854: g_state := 'Merging into FII_AR_ADJUSTMENTS_F';

Line 5851: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');

5847: BEGIN
5848:
5849: /*
5850: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';
5851: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');
5852: */
5853:
5854: g_state := 'Merging into FII_AR_ADJUSTMENTS_F';
5855: if g_debug_flag = 'Y' then

Line 5854: g_state := 'Merging into FII_AR_ADJUSTMENTS_F';

5850: g_state := 'Truncating table FII_AR_ADJUSTMENTS_F';
5851: TRUNCATE_TABLE('FII_AR_ADJUSTMENTS_F');
5852: */
5853:
5854: g_state := 'Merging into FII_AR_ADJUSTMENTS_F';
5855: if g_debug_flag = 'Y' then
5856: FII_UTIL.put_line(g_state);
5857: FII_UTIL.start_timer;
5858: FII_UTIL.put_line('');

Line 5861: merge into fii_ar_adjustments_f old using (

5857: FII_UTIL.start_timer;
5858: FII_UTIL.put_line('');
5859: end if;
5860:
5861: merge into fii_ar_adjustments_f old using (
5862: /* insert into fii_ar_adjustments_f
5863: (
5864: ADJUSTMENT_ID,
5865: TIME_ID,

Line 5862: /* insert into fii_ar_adjustments_f

5858: FII_UTIL.put_line('');
5859: end if;
5860:
5861: merge into fii_ar_adjustments_f old using (
5862: /* insert into fii_ar_adjustments_f
5863: (
5864: ADJUSTMENT_ID,
5865: TIME_ID,
5866: BILL_TO_CUSTOMER_ID,

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

6039: );
6040:
6041:
6042: if g_debug_flag = 'Y' then
6043: FII_UTIL.put_line('Merged ' ||SQL%ROWCOUNT|| ' records into FII_AR_ADJUSTMENTS_F');
6044: FII_UTIL.stop_timer;
6045: FII_UTIL.print_timer('Duration');
6046: FII_UTIL.put_line('');
6047: end if;

Line 6049: g_state := 'Analyzing FII_AR_ADJUSTMENTS_F table';

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

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 7802: from fii_ar_adjustments_f adj,

7798: null on_account_credit_flag,
7799: decode(adj.adj_class,'DEP','Y','N') unapplied_deposit_flag,
7800: 'Adjustment' action,
7801: sch.actual_date_closed
7802: from fii_ar_adjustments_f adj,
7803: fii_ar_pmt_schedules_f sch,
7804: fii_ar_dso_setup schdso,
7805: fii_ar_dso_setup adjdso,
7806: FII_AR_PAYSCH_MERGE_GT gt