APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_FUNC_RATES_TEMP

Line 406: FROM FII_AP_FUNC_RATES_TEMP RATES

402: To_Currency,
403: decode(conversion_rate,-3, to_date('01/01/1999','MM/DD/RRRR'),
404: least(TRX_DATE,sysdate)) Trx_Date,
405: Conversion_Type
406: FROM FII_AP_FUNC_RATES_TEMP RATES
407: WHERE RATES.Conversion_Rate < 0 ;
408:
409: BEGIN
410: g_state := 'Checking to see which additional rates need to be defined, if any';

Line 431: FROM FII_AP_FUNC_RATES_TEMP RATES

427: WHERE RATES.Sec_Conversion_Rate < 0;
428:
429: SELECT COUNT(*)
430: INTO l_miss_rates_func
431: FROM FII_AP_FUNC_RATES_TEMP RATES
432: WHERE RATES.Conversion_Rate < 0;
433:
434: --------------------------------------------------------
435: -- Print out translated messages to let user know there

Line 582: INSERT INTO FII_AP_FUNC_RATES_TEMP

578: fii_util.put_line('');
579: end if;
580:
581:
582: INSERT INTO FII_AP_FUNC_RATES_TEMP
583: (From_Currency,
584: To_Currency,
585: Trx_Date,
586: Conversion_Type,

Line 617: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_FUNC_RATES_TEMP');

613: end if;
614:
615: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PS_RATES_TEMP');
616:
617: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_FUNC_RATES_TEMP');
618:
619:
620: EXCEPTION
621: WHEN OTHERS THEN

Line 1421: FII_AP_Func_Rates_Temp FRATES

1417: AP_Invoice_Distributions_All AID,
1418: AP_System_Parameters_All ASP,
1419: FND_Currencies FC,
1420: FII_AP_PS_Rates_Temp RATES,
1421: FII_AP_Func_Rates_Temp FRATES
1422: WHERE ID.Invoice_ID = AI.Invoice_ID
1423: AND AI.Invoice_ID = AID.Invoice_ID (+)
1424: AND AI.Org_ID = ASP.Org_ID
1425: AND AI.Payment_Currency_Code = FC.Currency_Code

Line 4348: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');

4344:
4345:
4346: g_state := 'Truncating temp tables used to populate base tables';
4347: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');
4348: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');
4349: -- TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
4350: -- TRUNCATE_TABLE('FII_AP_PAY_SCHED_ID');
4351: -- TRUNCATE_TABLE('FII_AP_WH_TAX_T');
4352: -- TRUNCATE_TABLE('FII_AP_PREPAY_T');