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.CE_CSH_FCST_POP dependencies on CE_CURRENCY_RATES_TEMP

Line 469: ce_currency_rates_temp curr ';

465:
466: IF( CE_CASH_FCST.G_rp_exchange_type IS NULL OR
467: CE_CASH_FCST.G_rp_exchange_type <> 'User')THEN
468: from_clause := from_clause || ' ,
469: ce_currency_rates_temp curr ';
470: END IF;
471:
472: IF (CE_CASH_FCST.G_trx_type IN ('APP','ARR','PAY','XTI','XTO','XTR')) THEN
473: from_clause := from_clause || ' ,

Line 509: -- Special case for OE, need to join to ce_currency_rates_temp to figure out

505: END IF;
506: END IF;
507:
508: --
509: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
510: -- the functional value of the transaction amount
511: --
512: IF(CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL AND
513: CE_CASH_FCST.G_rp_src_curr_type = 'F' AND

Line 516: ce_currency_rates_temp curr2 ';

512: IF(CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL AND
513: CE_CASH_FCST.G_rp_src_curr_type = 'F' AND
514: CE_CASH_FCST.G_trx_type IN ('OEO','XTR'))THEN
515: from_clause := from_clause || ' ,
516: ce_currency_rates_temp curr2 ';
517: END IF;
518:
519: cep_standard.debug(from_clause);
520: return from_clause;

Line 807: -- Special case for OE, need to join to ce_currency_rates_temp to figure out

803: where_clause := where_clause || '
804: AND abs(nvl(src.amount,0)) > ' ||to_char(fnd_number.number_to_canonical(CE_CASH_FCST.G_rp_amount_threshold));
805: ELSIF(CE_CASH_FCST.G_rp_src_curr_type = 'F')THEN
806: --
807: -- Special case for OE, need to join to ce_currency_rates_temp to figure out
808: -- the functional value of the transaction amount
809: --
810: -- bug4345353 added the function fnd_number.number_to_canonical
811: IF(CE_CASH_FCST.G_trx_type <> 'OEO')THEN

Line 1153: ce_currency_rates_temp curr

1149: INTO l_end_of_day
1150: FROM gl_daily_balances gdb,
1151: gl_sets_of_books org,
1152: gl_code_combinations glcc,
1153: ce_currency_rates_temp curr
1154: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1155: AND curr.currency_code = gdb.currency_code
1156: AND gdb.period_name = l_period_name
1157: AND gdb.currency_code = org.currency_code

Line 1225: ce_currency_rates_temp curr

1221: FROM gl_balances src,
1222: gl_sets_of_books org,
1223: gl_periods gp,
1224: gl_code_combinations glcc,
1225: ce_currency_rates_temp curr
1226: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1227: AND curr.currency_code = src.currency_code
1228: AND src.period_name = gp.period_name
1229: AND src.currency_code = DECODE(CE_CASH_FCST.G_rp_src_curr_type,

Line 1267: ce_currency_rates_temp curr

1263: FROM gl_je_lines jl,
1264: gl_je_headers jh,
1265: gl_sets_of_books org,
1266: gl_code_combinations glcc,
1267: ce_currency_rates_temp curr
1268: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1269: AND curr.currency_code = jh.currency_code
1270: AND jl.effective_date <= CE_CASH_FCST.G_rp_forecast_start_date
1271: AND jl.status = 'P'

Line 1304: ce_currency_rates_temp curr

1300: INTO initial_cash_pos
1301: FROM gl_balances src,
1302: gl_sets_of_books org,
1303: gl_code_combinations glcc,
1304: ce_currency_rates_temp curr
1305: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1306: AND curr.currency_code = src.currency_code
1307: AND src.period_name = CE_CASH_FCST.G_rp_forecast_start_period
1308: AND org.period_set_name = CE_CASH_FCST.G_rp_calendar_name

Line 1492: from ce_currency_rates_temp

1488: cep_standard.debug('>>Bank Account currency conversion');
1489:
1490: select exchange_rate
1491: into l_exchange_rate
1492: from ce_currency_rates_temp
1493: where currency_code = l_bank_acc_curr
1494: and to_currency = CE_CASH_FCST.G_rp_forecast_currency
1495: and forecast_request_id = CE_CASH_FCST.G_forecast_id;
1496:

Line 1580: ce_currency_rates_temp curr

1576: ELSE
1577: SELECT SUM(src.amount*curr.exchange_rate)
1578: INTO l_app_cflow
1579: FROM ce_ap_fc_payments_v src,
1580: ce_currency_rates_temp curr
1581: WHERE src.bank_account_id = p_bank.bank_account_id
1582: AND src.payment_date >= l_balance_date
1583: AND src.payment_date < l_fc_start_date
1584: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1591: ce_currency_rates_temp curr

1587:
1588: SELECT SUM(src.amount*curr.exchange_rate)
1589: INTO l_arr_cflow
1590: FROM ce_ar_fc_receipts_v src,
1591: ce_currency_rates_temp curr
1592: WHERE src.bank_account_id = p_bank.bank_account_id
1593: AND src.cash_activity_date >= l_balance_date
1594: AND src.cash_activity_date < l_fc_start_date
1595: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1602: ce_currency_rates_temp curr

1598:
1599: SELECT SUM(src.amount*curr.exchange_rate)
1600: INTO l_xtr_cflow
1601: FROM ce_xtr_cashflows_v src,
1602: ce_currency_rates_temp curr
1603: WHERE src.bank_account_id = p_bank.bank_account_id
1604: AND src.trx_date >= l_balance_date
1605: AND src.trx_date < l_fc_start_date
1606: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1613: ce_currency_rates_temp curr

1609:
1610: SELECT SUM(src.amount*curr.exchange_rate)
1611: INTO l_pay_cflow
1612: FROM ce_pay_fc_payroll_v src,
1613: ce_currency_rates_temp curr
1614: WHERE src.bank_account_id = p_bank.bank_account_id
1615: AND src.trx_date >= l_balance_date
1616: AND src.trx_date < l_fc_start_date
1617: AND curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1727: from ce_currency_rates_temp

1723: cep_standard.debug('>>Subsidiary Bank Account currency conversion');
1724:
1725: select exchange_rate
1726: into l_exchange_rate
1727: from ce_currency_rates_temp
1728: where currency_code = p_sub_acct.currency_code
1729: and to_currency = CE_CASH_FCST.G_rp_forecast_currency
1730: and forecast_request_id = CE_CASH_FCST.G_forecast_id;
1731:

Line 2662: ce_currency_rates_temp curr ';

2658:
2659: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
2660: CE_CASH_FCST.G_rp_exchange_type IS NULL)THEN
2661: main_query := main_query || ',
2662: ce_currency_rates_temp curr ';
2663: END IF;
2664:
2665: main_query := main_query || '
2666: WHERE gp.start_date(+) = cab.start_date

Line 2928: FROM ce_currency_rates_temp

2924: AND org_id = p_org_id;
2925:
2926: CURSOR C_rate(p_currency_code VARCHAR2) IS
2927: SELECT exchange_rate
2928: FROM ce_currency_rates_temp
2929: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id
2930: AND to_currency = CE_CASH_FCST.G_rp_forecast_currency
2931: AND currency_code = p_currency_code;
2932:

Line 3893: FROM ce_currency_rates_temp

3889: AND org_id = p_org_id;
3890:
3891: CURSOR C_rate(p_currency_code VARCHAR2) IS
3892: SELECT exchange_rate
3893: FROM ce_currency_rates_temp
3894: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id
3895: AND to_currency = CE_CASH_FCST.G_rp_forecast_currency
3896: AND currency_code = p_currency_code;
3897:

Line 5017: FROM ce_currency_rates_temp

5013: AND org_id = p_org_id;
5014:
5015: CURSOR C_rate(p_currency_code VARCHAR2) IS
5016: SELECT exchange_rate
5017: FROM ce_currency_rates_temp
5018: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id
5019: AND to_currency = CE_CASH_FCST.G_rp_forecast_currency
5020: AND currency_code = p_currency_code;
5021:

Line 5384: FROM ce_currency_rates_temp

5380: conversion_table CE_FORECAST_REMOTE_SOURCES.ConversionTab'||db_link||';
5381: amount_table CE_FORECAST_REMOTE_SOURCES.AmountTab'||db_link||';
5382:
5383: CURSOR conversion_cursor IS SELECT currency_code, exchange_rate
5384: FROM ce_currency_rates_temp
5385: WHERE forecast_request_id = CE_CASH_FCST.G_forecast_id; ';
5386:
5387: IF( db_link IS NOT NULL )THEN
5388: main_query := main_query ||'