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_CURR_RATES_T

Line 515: g_state := 'Loading data into rates table FII_AR_CURR_RATES_T';

511: PROCEDURE Insert_Rates IS
512:
513: BEGIN
514:
515: g_state := 'Loading data into rates table FII_AR_CURR_RATES_T';
516:
517: if g_debug_flag = 'Y' then
518: fii_util.put_line(' ');
519: fii_util.put_line(g_state);

Line 524: INSERT /+ append / INTO FII_AR_CURR_RATES_T

520: fii_util.start_timer;
521: fii_util.put_line('');
522: end if;
523:
524: INSERT /*+ append */ INTO FII_AR_CURR_RATES_T
525: (SELECT sob.currency_code fc_code,
526: Decode(NVL(cur.minimum_accountable_unit,
527: power( 10, (-1 * cur.precision))),
528: null, 0.01,

Line 597: update FII_AR_CURR_RATES_T

593: /*
594: --------------------
595: --Temporarily added to avoid: missing currency conversion rates error
596: ---------------------
597: update FII_AR_CURR_RATES_T
598: set prim_conversion_rate=1
599: where prim_conversion_rate<=0;
600:
601: update FII_AR_CURR_RATES_T

Line 601: update FII_AR_CURR_RATES_T

597: update FII_AR_CURR_RATES_T
598: set prim_conversion_rate=1
599: where prim_conversion_rate<=0;
600:
601: update FII_AR_CURR_RATES_T
602: set sec_conversion_rate=1
603: where sec_conversion_rate<=0;
604: commit;
605: ------------------------

Line 608: g_state := 'Analyzing FII_AR_CURR_RATES_T table';

604: commit;
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

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 639: FROM FII_AR_CURR_RATES_T RATES

635: CURSOR prim_MissingRate IS
636: SELECT DISTINCT fc_code From_Currency,
637: decode(prim_conversion_rate,-3, to_date('01/01/1999','MM/DD/YYYY'),
638: conversion_date) Trx_Date
639: FROM FII_AR_CURR_RATES_T RATES
640: WHERE RATES.Prim_Conversion_Rate < 0 ;
641:
642: CURSOR sec_MissingRate IS
643: SELECT DISTINCT fc_code From_Currency,

Line 646: FROM FII_AR_CURR_RATES_T RATES

642: CURSOR sec_MissingRate IS
643: SELECT DISTINCT fc_code From_Currency,
644: decode(sec_conversion_rate,-3, to_date('01/01/1999','MM/DD/YYYY'),
645: conversion_date) Trx_Date
646: FROM FII_AR_CURR_RATES_T RATES
647: WHERE RATES.Sec_Conversion_Rate < 0 ;
648:
649:
650: BEGIN

Line 662: FROM FII_AR_CURR_RATES_T RATES

658: end if;
659:
660: SELECT COUNT(*)
661: INTO l_miss_rates_prim
662: FROM FII_AR_CURR_RATES_T RATES
663: WHERE RATES.Prim_Conversion_Rate < 0;
664:
665: SELECT COUNT(*)
666: INTO l_miss_rates_sec

Line 667: FROM FII_AR_CURR_RATES_T RATES

663: WHERE RATES.Prim_Conversion_Rate < 0;
664:
665: SELECT COUNT(*)
666: INTO l_miss_rates_sec
667: FROM FII_AR_CURR_RATES_T RATES
668: WHERE RATES.Sec_Conversion_Rate < 0;
669:
670:
671: --------------------------------------------------------

Line 918: FII_AR_CURR_RATES_T rt,

914: g_fii_user_id, --LAST_UPDATED_BY,
915: g_fii_login_id --LAST_UPDATE_LOGIN
916: FROM AR_PAYMENT_SCHEDULES_ALL sch,
917: RA_CUSTOMER_TRX_ALL trx,
918: FII_AR_CURR_RATES_T rt,
919: AR_SYSTEM_PARAMETERS_ALL par,
920: GL_SETS_OF_BOOKS sob,
921: AR_TRANSACTION_HISTORY_ALL h,
922: RA_CUST_TRX_TYPES_ALL tp

Line 1062: FII_AR_CURR_RATES_T rt,

1058: g_fii_login_id --LAST_UPDATE_LOGIN
1059: FROM AR_PAYMENT_SCHEDULES_ALL sch,
1060: AR_RECEIVABLE_APPLICATIONS_ALL app,
1061: AR_PAYMENT_SCHEDULES_ALL trxsch,
1062: FII_AR_CURR_RATES_T rt,
1063: AR_SYSTEM_PARAMETERS_ALL par,
1064: GL_SETS_OF_BOOKS sob
1065: WHERE sch.class = 'PMT'
1066: AND sch.payment_schedule_id = app.payment_schedule_id

Line 1204: FII_AR_CURR_RATES_T rt,

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
1207: WHERE dis.payment_schedule_id = sch.payment_schedule_id
1208: AND sch.class <> 'PMT'

Line 1513: FII_AR_CURR_RATES_T rt,

1509: FROM AR_ADJUSTMENTS_ALL adj,
1510: FII_AR_TRANSACTIONS_F trx,
1511: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
1512: RA_CUSTOMER_TRX_LINES_ALL line,
1513: FII_AR_CURR_RATES_T rt,
1514: AR_SYSTEM_PARAMETERS_ALL par,
1515: GL_SETS_OF_BOOKS sob
1516: WHERE adj.status = 'A'
1517: AND adj.customer_trx_id = trx.customer_trx_id

Line 1794: FII_AR_CURR_RATES_T rctrt,

1790: --NVL(rct.customer_site_use_id,
1791: -- -1) bill_to_site_use_id, --(-1 for UNAPP, UNID)
1792: --rct.customer_site_use_id
1793: from AR_CASH_RECEIPTS_ALL rct,
1794: FII_AR_CURR_RATES_T rctrt,
1795: AR_SYSTEM_PARAMETERS_ALL par,
1796: GL_SETS_OF_BOOKS sob
1797: where --rct.receipt_date >= g_global_start_date
1798: rct.org_id = par.org_id

Line 1815: FII_AR_CURR_RATES_T trxrt,

1811: trxsch.due_date, --due_date
1812: trxsch.bill_to_customer_id,
1813: trxsch.bill_to_site_use_id
1814: from FII_AR_PMT_SCHEDULES_F trxsch,
1815: FII_AR_CURR_RATES_T trxrt,
1816: AR_SYSTEM_PARAMETERS_ALL par,
1817: GL_SETS_OF_BOOKS sob
1818: where trxsch.org_id = par.org_id
1819: AND par.set_of_books_id = sob.set_of_books_id

Line 4139: g_state := 'Truncating table FII_AR_CURR_RATES_T';

4135:
4136: GET_BUCKET_RANGES;
4137:
4138:
4139: g_state := 'Truncating table FII_AR_CURR_RATES_T';
4140: TRUNCATE_TABLE('FII_AR_CURR_RATES_T');
4141: if g_debug_flag = 'Y' then
4142: FII_UTIL.put_line('-------------------------------------------------');
4143: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');

Line 4140: TRUNCATE_TABLE('FII_AR_CURR_RATES_T');

4136: GET_BUCKET_RANGES;
4137:
4138:
4139: g_state := 'Truncating table FII_AR_CURR_RATES_T';
4140: TRUNCATE_TABLE('FII_AR_CURR_RATES_T');
4141: if g_debug_flag = 'Y' then
4142: FII_UTIL.put_line('-------------------------------------------------');
4143: FII_UTIL.put_line('Calling the Insert_Rates procedure to insert the missing rate info');
4144: FII_UTIL.put_line('-------------------------------------------------');

Line 4794: g_state := 'Loading data into rates table FII_AR_CURR_RATES_T';

4790: PROCEDURE Inc_RATES IS
4791:
4792: BEGIN
4793:
4794: g_state := 'Loading data into rates table FII_AR_CURR_RATES_T';
4795:
4796: if g_debug_flag = 'Y' then
4797: fii_util.put_line(' ');
4798: fii_util.put_line(g_state);

Line 4803: INSERT /+ append / INTO FII_AR_CURR_RATES_T

4799: fii_util.start_timer;
4800: fii_util.put_line('');
4801: end if;
4802:
4803: INSERT /*+ append */ INTO FII_AR_CURR_RATES_T
4804: (SELECT sob.currency_code fc_code,
4805: Decode(NVL(cur.minimum_accountable_unit,
4806: power( 10, (-1 * cur.precision))),
4807: null, 0.01,

Line 4853: update FII_AR_CURR_RATES_T

4849: /*
4850: --------------------
4851: --Temporarily added to avoid: missing currency conversion rates error
4852: ---------------------
4853: update FII_AR_CURR_RATES_T
4854: set prim_conversion_rate=1
4855: where prim_conversion_rate<=0;
4856:
4857: update FII_AR_CURR_RATES_T

Line 4857: update FII_AR_CURR_RATES_T

4853: update FII_AR_CURR_RATES_T
4854: set prim_conversion_rate=1
4855: where prim_conversion_rate<=0;
4856:
4857: update FII_AR_CURR_RATES_T
4858: set sec_conversion_rate=1
4859: where sec_conversion_rate<=0;
4860: commit;
4861: ------------------------

Line 4864: g_state := 'Analyzing FII_AR_CURR_RATES_T table';

4860: commit;
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

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 5045: FII_AR_CURR_RATES_T rt,

5041: g_fii_user_id LAST_UPDATED_BY,
5042: g_fii_login_id LAST_UPDATE_LOGIN
5043: FROM FII_AR_PAYSCH_MERGE_GT sch,
5044: RA_CUSTOMER_TRX_ALL trx,
5045: FII_AR_CURR_RATES_T rt,
5046: AR_SYSTEM_PARAMETERS_ALL par,
5047: GL_SETS_OF_BOOKS sob
5048: WHERE sch.class IN ('INV','DM','CB','CM','DEP','BR', 'PMT')
5049: /*AND decode(g_collection_criteria,

Line 5372: FII_AR_CURR_RATES_T rt,

5368: payment_schedule_id,
5369: trx_date
5370: from FII_AR_PAYSCH_MERGE_GT sch
5371: ) sch,
5372: FII_AR_CURR_RATES_T rt,
5373: AR_SYSTEM_PARAMETERS_ALL par,
5374: GL_SETS_OF_BOOKS sob
5375: WHERE dis.payment_schedule_id = sch.payment_schedule_id
5376: AND sch.class <> 'PMT'

Line 5614: FII_AR_CURR_RATES_T rt,

5610: class,
5611: customer_trx_id,
5612: gl_date
5613: from FII_AR_PAYSCH_MERGE_GT sch,
5614: FII_AR_CURR_RATES_T rt,
5615: AR_SYSTEM_PARAMETERS_ALL par,
5616: GL_SETS_OF_BOOKS sob
5617: WHERE sch.org_id = par.org_id
5618: AND par.set_of_books_id = sob.set_of_books_id

Line 5937: FII_AR_CURR_RATES_T rt,

5933: FII_AR_ADJ_UPDATE_GT adj,
5934: FII_AR_TRANSACTIONS_F trx,
5935: FII_AR_TRANSACTIONS_F trx2, --makes sure the CM adj does not result from a GUAR
5936: RA_CUSTOMER_TRX_LINES_ALL line,
5937: FII_AR_CURR_RATES_T rt,
5938: AR_SYSTEM_PARAMETERS_ALL par,
5939: GL_SETS_OF_BOOKS sob
5940: WHERE adj.status = 'A'
5941: AND adj.customer_trx_id = trx.customer_trx_id

Line 6306: FII_AR_CURR_RATES_T rctrt,

6302: --NVL(rct.customer_site_use_id,
6303: -- -1) bill_to_site_use_id, --(-1 for UNAPP, UNID)
6304: --rct.customer_site_use_id
6305: from AR_CASH_RECEIPTS_ALL rct,
6306: FII_AR_CURR_RATES_T rctrt,
6307: AR_SYSTEM_PARAMETERS_ALL par,
6308: GL_SETS_OF_BOOKS sob
6309: where --rct.receipt_date >= g_global_start_date
6310: rct.org_id = par.org_id

Line 6338: FII_AR_CURR_RATES_T trxrt,

6334: org_id,
6335: nvl(sch.exchange_date, sch.trx_date) exchange_date
6336: from FII_AR_PAYSCH_MERGE_GT sch
6337: ) trxsch,
6338: FII_AR_CURR_RATES_T trxrt,
6339: AR_SYSTEM_PARAMETERS_ALL par,
6340: GL_SETS_OF_BOOKS sob
6341: where trxsch.org_id = par.org_id
6342: AND par.set_of_books_id = sob.set_of_books_id

Line 9306: g_state := 'Truncating table FII_AR_CURR_RATES_T';

9302:
9303: GET_BUCKET_RANGES;
9304:
9305:
9306: g_state := 'Truncating table FII_AR_CURR_RATES_T';
9307: TRUNCATE_TABLE('FII_AR_CURR_RATES_T');
9308:
9309: if g_debug_flag = 'Y' then
9310: FII_UTIL.put_line('-------------------------------------------------');

Line 9307: TRUNCATE_TABLE('FII_AR_CURR_RATES_T');

9303: GET_BUCKET_RANGES;
9304:
9305:
9306: g_state := 'Truncating table FII_AR_CURR_RATES_T';
9307: TRUNCATE_TABLE('FII_AR_CURR_RATES_T');
9308:
9309: if g_debug_flag = 'Y' then
9310: FII_UTIL.put_line('-------------------------------------------------');
9311: FII_UTIL.put_line('Calling the Inc_RATES procedure to insert the missing rate info');