DBA Data[Home] [Help]

APPS.FII_AP_INV_SUM_INIT dependencies on FII_AP_PS_RATES_TEMP

Line 848: FROM FII_AP_PS_RATES_TEMP RATES

844: CURSOR prim_MissingRate IS
845: SELECT DISTINCT Functional_Currency From_Currency,
846: decode(prim_conversion_rate,-3, to_date('01/01/1999','MM/DD/RRRR'),
847: LEAST(TRX_DATE,sysdate)) Trx_Date
848: FROM FII_AP_PS_RATES_TEMP RATES
849: WHERE RATES.Prim_Conversion_Rate < 0 ;
850:
851: CURSOR sec_MissingRate IS
852: SELECT DISTINCT FUNCTIONAL_CURRENCY From_Currency,

Line 855: FROM FII_AP_PS_RATES_TEMP RATES

851: CURSOR sec_MissingRate IS
852: SELECT DISTINCT FUNCTIONAL_CURRENCY From_Currency,
853: decode(sec_conversion_rate,-3, to_date('01/01/1999','MM/DD/RRRR'),
854: LEAST(TRX_DATE,sysdate)) Trx_Date
855: FROM FII_AP_PS_RATES_TEMP RATES
856: WHERE RATES.Sec_Conversion_Rate < 0 ;
857:
858: CURSOR func_MissingRate IS
859: SELECT DISTINCT From_Currency,

Line 880: FROM FII_AP_PS_RATES_TEMP RATES

876:
877: BEGIN
878: SELECT 1
879: INTO l_miss_rates_ps
880: FROM FII_AP_PS_RATES_TEMP RATES
881: WHERE (RATES.Prim_Conversion_Rate < 0
882: OR RATES.Sec_Conversion_Rate < 0)
883: AND ROWNUM = 1;
884: EXCEPTION

Line 982: INTO FII_AP_PS_RATES_TEMP T

978: fii_util.put_line('');
979: end if;
980:
981: INSERT /*+ append parallel(T) */
982: INTO FII_AP_PS_RATES_TEMP T
983: (Functional_Currency,
984: Trx_Date,
985: Prim_Conversion_Rate,
986: Sec_Conversion_Rate)

Line 1069: l_host_var := 'ALTER TABLE ' || g_fii_schema || '.FII_AP_PS_RATES_TEMP CACHE';

1065: end if;
1066:
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:

Line 1445: FII_AP_PS_Rates_Temp RATES,

1441: TRUNC(MAX(AIP.Creation_Date)) Fully_Paid_Date,
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

Line 1905: FII_AP_PS_Rates_Temp RATES,

1901: NVL(AIP.Discount_Taken,0),
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

Line 2416: FII_AP_PS_Rates_Temp RATES,

2412: TEMP.Inv_Pymt_Flag,
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

Line 2808: FII_AP_PS_Rates_Temp RATES,

2804: FROM FII_AP_Invoice_B AI,
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

Line 3285: FII_AP_PS_Rates_Temp RATES,

3281: APS3.Creation_Date,
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

Line 3550: FII_AP_PS_Rates_Temp RATES,

3546: sysdate Last_Update_Date,
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,

Line 3813: FII_AP_PS_Rates_Temp RATES,

3809: sysdate Last_Update_Date,
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,

Line 4077: FII_AP_PS_Rates_Temp RATES,

4073: sysdate Last_Update_Date,
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,

Line 4410: FII_AP_PS_Rates_Temp RATES,

4406: g_fii_user_id Last_Updated_By,
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,

Line 4715: FII_AP_PS_Rates_Temp RATES,

4711: g_fii_user_id Last_Updated_By,
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,

Line 4990: FII_AP_PS_Rates_Temp RATES,

4986: g_fii_user_id Last_Updated_By,
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,

Line 5292: FII_AP_PS_Rates_Temp RATES,

5288: g_fii_user_id Last_Updated_By,
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,

Line 5565: FII_AP_PS_Rates_Temp RATES,

5561: g_fii_user_id Last_Updated_By,
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,

Line 5964: FII_AP_PS_Rates_Temp RATES,

5960: WHERE PS.Invoice_ID = AI.Invoice_ID
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

Line 7030: TRUNCATE_TABLE('FII_AP_PS_RATES_TEMP');

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