APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_PS_RATES_TEMP

Line 390: FROM FII_AP_PS_RATES_TEMP RATES

386: CURSOR prim_MissingRate IS
387: SELECT DISTINCT Functional_Currency From_Currency,
388: decode(prim_conversion_rate,-3, to_date('01/01/1999','MM/DD/RRRR'),
389: LEAST(TRX_DATE,sysdate)) Trx_Date
390: FROM FII_AP_PS_RATES_TEMP RATES
391: WHERE RATES.Prim_Conversion_Rate < 0 ;
392:
393: CURSOR sec_MissingRate IS
394: SELECT DISTINCT FUNCTIONAL_CURRENCY From_Currency,

Line 397: FROM FII_AP_PS_RATES_TEMP RATES

393: CURSOR sec_MissingRate IS
394: SELECT DISTINCT FUNCTIONAL_CURRENCY From_Currency,
395: decode(sec_conversion_rate,-3, to_date('01/01/1999','MM/DD/RRRR'),
396: least(TRX_DATE,sysdate)) Trx_Date
397: FROM FII_AP_PS_RATES_TEMP RATES
398: WHERE RATES.Sec_Conversion_Rate < 0 ;
399:
400: CURSOR func_MissingRate IS
401: SELECT DISTINCT From_Currency,

Line 421: FROM FII_AP_PS_RATES_TEMP RATES

417: end if;
418:
419: SELECT COUNT(*)
420: INTO l_miss_rates_prim
421: FROM FII_AP_PS_RATES_TEMP RATES
422: WHERE RATES.Prim_Conversion_Rate < 0;
423:
424: SELECT COUNT(*)
425: INTO l_miss_rates_sec

Line 426: FROM FII_AP_PS_RATES_TEMP RATES

422: WHERE RATES.Prim_Conversion_Rate < 0;
423:
424: SELECT COUNT(*)
425: INTO l_miss_rates_sec
426: FROM FII_AP_PS_RATES_TEMP RATES
427: WHERE RATES.Sec_Conversion_Rate < 0;
428:
429: SELECT COUNT(*)
430: INTO l_miss_rates_func

Line 549: INSERT INTO FII_AP_PS_RATES_TEMP

545: fii_util.start_timer;
546: fii_util.put_line('');
547: end if;
548:
549: INSERT INTO FII_AP_PS_RATES_TEMP
550: (Functional_Currency,
551: Trx_Date,
552: Prim_Conversion_Rate,
553: Sec_Conversion_Rate)

Line 615: FND_STATS.GATHER_TABLE_STATS(OWNNAME => 'FII', TABNAME => 'FII_AP_PS_RATES_TEMP');

611: fii_util.stop_timer;
612: fii_util.print_timer('Duration');
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:

Line 1420: FII_AP_PS_Rates_Temp RATES,

1416: AP_Invoices_All AI,
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

Line 4347: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');

4343: INIT;
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');