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_AP_INV_SUM_INIT dependencies on FII_AP_FUNC_RATES_TEMP

Line 864: FROM FII_AP_FUNC_RATES_TEMP RATES

860: To_Currency,
861: decode(conversion_rate,-3, to_date('01/01/1999','MM/DD/RRRR'),
862: LEAST(TRX_DATE,sysdate)) Trx_Date,
863: Conversion_Type
864: FROM FII_AP_FUNC_RATES_TEMP RATES
865: WHERE RATES.Conversion_Rate < 0 ;
866:
867: BEGIN
868: g_state := 'Checking to see which additional rates need to be defined, if any';

Line 891: FROM FII_AP_FUNC_RATES_TEMP RATES

887:
888: BEGIN
889: SELECT 1
890: INTO l_miss_rates_func
891: FROM FII_AP_FUNC_RATES_TEMP RATES
892: WHERE RATES.Conversion_Rate < 0
893: AND ROWNUM = 1;
894: EXCEPTION
895: WHEN NO_DATA_FOUND THEN l_miss_rates_func := 0;

Line 1024: INTO FII_AP_FUNC_RATES_TEMP T

1020: end if;
1021:
1022:
1023: INSERT /*+ append parallel(T)*/
1024: INTO FII_AP_FUNC_RATES_TEMP T
1025: (From_Currency,
1026: To_Currency,
1027: Trx_Date,
1028: Conversion_Type,

Line 1071: l_host_var := 'ALTER TABLE ' || g_fii_schema || '.FII_AP_FUNC_RATES_TEMP CACHE';

1067: COMMIT;
1068:
1069: l_host_var := 'ALTER TABLE ' || g_fii_schema || '.FII_AP_PS_RATES_TEMP CACHE';
1070: EXECUTE IMMEDIATE l_host_var;
1071: l_host_var := 'ALTER TABLE ' || g_fii_schema || '.FII_AP_FUNC_RATES_TEMP CACHE';
1072: EXECUTE IMMEDIATE l_host_var;
1073:
1074:
1075: EXCEPTION

Line 1446: FII_AP_Func_Rates_Temp FRATES

1442: SUM(AIP.Amount + NVL(AIP.Discount_Taken,0)) Fully_Paid_Amount_IP
1443: FROM AP_Invoice_Payments_All AIP
1444: GROUP BY AIP.Invoice_ID ) AIP,
1445: FII_AP_PS_Rates_Temp RATES,
1446: FII_AP_Func_Rates_Temp FRATES
1447: WHERE IB.Invoice_ID = PS.Invoice_ID
1448: AND IB.Invoice_ID = AIP.Invoice_ID (+)
1449: AND IB.Invoice_Date = RATES.Trx_Date
1450: AND IB.Base_Currency_Code = RATES.Functional_Currency

Line 1906: FII_AP_Func_Rates_Temp FRATES

1902: PS.Gross_Amount,
1903: AIP.Prepay_WH_Tax_Amount,
1904: AIP.Invoice_Payment_ID) PSUM,
1905: FII_AP_PS_Rates_Temp RATES,
1906: FII_AP_Func_Rates_Temp FRATES
1907: WHERE FRATES.To_Currency = PSUM.Base_Currency_Code
1908: AND FRATES.From_Currency = PSUM.Payment_Currency_Code
1909: AND FRATES.Trx_Date = PSUM.Exchange_Date
1910: AND DECODE(PSUM.Exchange_Rate_Type,'User', PSUM.Exchange_Rate,1) =

Line 2417: FII_AP_Func_Rates_Temp FRATES

2413: TEMP.Unique_ID
2414: FROM FII_AP_Invoice_B AI,
2415: FII_AP_Pay_Sched_Temp TEMP,
2416: FII_AP_PS_Rates_Temp RATES,
2417: FII_AP_Func_Rates_Temp FRATES
2418: WHERE TEMP.Invoice_ID = AI.Invoice_ID
2419: AND AI.Invoice_ID BETWEEN g_start_range and g_end_range
2420: AND FRATES.To_Currency = TEMP.Base_Currency_Code
2421: AND FRATES.From_Currency = AI.Payment_Currency_Code

Line 2809: FII_AP_Func_Rates_Temp FRATES,

2805: AP_Invoice_Distributions_All AID,
2806: AP_Invoice_Lines_All AIL,
2807: AP_Payment_Schedules_All PS,
2808: FII_AP_PS_Rates_Temp RATES,
2809: FII_AP_Func_Rates_Temp FRATES,
2810: FND_Currencies FC
2811: WHERE PS.Invoice_ID = AI.Invoice_ID
2812: AND AID.Invoice_ID = AI.Invoice_ID
2813: AND AID.Invoice_ID = AIL.Invoice_ID

Line 3286: FII_AP_Func_Rates_Temp FRATES,

3282: APS3.Prepay_Amount,
3283: APS3.Check_ID,
3284: APS3.WH_Tax_Pay_Amount) TEMP,
3285: FII_AP_PS_Rates_Temp RATES,
3286: FII_AP_Func_Rates_Temp FRATES,
3287: AP_Checks_All AC,
3288: -- IBY_Payment_Profiles IBYPM--IBY CHANGE
3289: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE
3290: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B,--IBY CHANGE

Line 3551: FII_AP_Func_Rates_Temp FRATES,

3547: g_fii_login_id Last_Update_Login,
3548: 1 Unique_ID
3549: FROM FII_AP_Invoice_B AI,
3550: FII_AP_PS_Rates_Temp RATES,
3551: FII_AP_Func_Rates_Temp FRATES,
3552: AP_Payment_Schedules_All PS,
3553: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
3554: TEM.Payment_Num,
3555: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 3814: FII_AP_Func_Rates_Temp FRATES,

3810: g_fii_login_id Last_Update_Login,
3811: 2 Unique_ID
3812: FROM FII_AP_Invoice_B AI,
3813: FII_AP_PS_Rates_Temp RATES,
3814: FII_AP_Func_Rates_Temp FRATES,
3815: AP_Payment_Schedules_All PS,
3816: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
3817: TEM.Payment_Num,
3818: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 4078: FII_AP_Func_Rates_Temp FRATES,

4074: g_fii_login_id Last_Update_Login,
4075: 3 Unique_ID
4076: FROM FII_AP_Invoice_B AI,
4077: FII_AP_PS_Rates_Temp RATES,
4078: FII_AP_Func_Rates_Temp FRATES,
4079: AP_Payment_Schedules_All PS,
4080: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4081: TEM.Payment_Num,
4082: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 4411: FII_AP_Func_Rates_Temp FRATES,

4407: sysdate Last_Update_Date,
4408: g_fii_login_id Last_Update_Login
4409: FROM FII_AP_Invoice_B AI,
4410: FII_AP_PS_Rates_Temp RATES,
4411: FII_AP_Func_Rates_Temp FRATES,
4412: AP_Payment_Schedules_All PS,
4413: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID Invoice_ID,
4414: TEM.Payment_Num Payment_Num,
4415: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 4716: FII_AP_Func_Rates_Temp FRATES,

4712: sysdate Last_Update_Date,
4713: g_fii_login_id Last_Update_Login
4714: FROM FII_AP_Invoice_B AI,
4715: FII_AP_PS_Rates_Temp RATES,
4716: FII_AP_Func_Rates_Temp FRATES,
4717: AP_Payment_Schedules_All PS,
4718: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4719: TEM.Payment_Num,
4720: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 4991: FII_AP_Func_Rates_Temp FRATES,

4987: sysdate Last_Update_Date,
4988: g_fii_login_id Last_Update_Login
4989: FROM FII_AP_Invoice_B AI,
4990: FII_AP_PS_Rates_Temp RATES,
4991: FII_AP_Func_Rates_Temp FRATES,
4992: AP_Payment_Schedules_All PS,
4993: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
4994: TEM.Payment_Num,
4995: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 5293: FII_AP_Func_Rates_Temp FRATES,

5289: sysdate Last_Update_Date,
5290: g_fii_login_id Last_Update_Login
5291: FROM FII_AP_Invoice_B AI,
5292: FII_AP_PS_Rates_Temp RATES,
5293: FII_AP_Func_Rates_Temp FRATES,
5294: AP_Payment_Schedules_All PS,
5295: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
5296: TEM.Payment_Num,
5297: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 5566: FII_AP_Func_Rates_Temp FRATES,

5562: sysdate Last_Update_Date,
5563: g_fii_login_id Last_Update_Login
5564: FROM FII_AP_Invoice_B AI,
5565: FII_AP_PS_Rates_Temp RATES,
5566: FII_AP_Func_Rates_Temp FRATES,
5567: AP_Payment_Schedules_All PS,
5568: (SELECT /*+ index(TEM,FII_AP_WH_TAX_T_N1) */ TEM.Invoice_ID,
5569: TEM.Payment_Num,
5570: SUM(NVL(TEM.WH_Tax_Amount, 0)) WH_Tax_Amount

Line 5965: FII_AP_Func_Rates_Temp FRATES

5961: AND AI.Invoice_ID BETWEEN g_start_range and g_end_range
5962: AND AI.Invoice_Type NOT IN ('PREPAYMENT')
5963: AND AI.Cancel_Date IS NULL) PSUM,
5964: FII_AP_PS_Rates_Temp RATES,
5965: FII_AP_Func_Rates_Temp FRATES
5966: WHERE FRATES.To_Currency = PSUM.Base_Currency_Code
5967: AND FRATES.From_Currency = PSUM.Payment_Currency_Code
5968: AND FRATES.Trx_Date = PSUM.Exchange_Date
5969: AND DECODE(PSUM.Exchange_Rate_Type,'User', PSUM.Exchange_Rate,1) =

Line 7031: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');

7027: INIT;
7028:
7029: g_state := 'Truncating temp tables used to populate base tables';
7030: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');
7031: TRUNCATE_TABLE('FII_AP_FUNC_RATES_TEMP');
7032: TRUNCATE_TABLE('FII_AP_PS_WORK_JOBS');
7033: TRUNCATE_TABLE('FII_AP_PAY_SCHED_TEMP');
7034: TRUNCATE_TABLE('FII_AP_WH_TAX_T');
7035: TRUNCATE_TABLE('FII_AP_PREPAY_T');